noobie Error Connecting to Access DB

I have several MS Access databases that are linked together in on way or
another that work fine. I now have to make reports for our intranet to view
the data, but not edit it, for our upper echelon of employees. The workers
enter the data thru front-end/back-end MS Access db's. No problem there.
The problem is when I try to connect to the main db thru an asp page. I have
done every way possible to connect to this db, ie: setting up all different
DSN's possible to the db, and using both the full connection string
("driver=........) and DSN connection string ("DSN=....."). So what I did,
was to recreate the system at home. I have a server(NT4.0 SP4 stand alone
w/the Option pack installed, IIS4.0, VS6.0, Office2k) on a generic machine,
no name brand computer (Dell,HP,.....). I use Visual Studio 6.0 on my
computer (HP w/WinXP H.E.,Office2007) I could not connect using the full
connection string, but when I made the systemDSN and used the DSN connection
string, it works. I can access the db. So, I took that info and went to
work. I get an error that the SETSQLATTR(?) can not be set. The work svr is
a Dell OptiplexGX110 w/NT4.0, VS6.0, Office2k. I made the connection string
and it tested good but when I try to test the connection via asp, I get the
error. I have also set the permissions on every folder that I can think of to
allow everyone and the IUSR_* and IWEB_* to full permissions and to execute
scripts. What else should or could I do?

My Connection String
Provider=MSDASQL.1;Persist Security Info=False;Mode=ReadWrite;Extended
Properties="DBQ=I:\Cadets_be.mdb;DefaultDir=I:\;Driver={Micr osoft
Access Driver (*.mdb)};DriverId=25;FIL=MS
Access;FILEDSN=\\Orion\Databases\Cadets_be.mdb.dsn;MaxBuffer Size=2048;
MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=10;UI D=admin;
UserCommitSync=Yes;"

Re: noobie Error Connecting to Access DB

Check out www.w3schools.com for more samples and www.connectionstrings.com
for sample connection strings.

--

Best regards,

Steve Schofield
Windows Server MVP - IIS
http://weblogs.asp.net/steveschofield


"Joseph" wrote in message
news:33D774E7-4AED-4B75-9FE2-8CEA3020ECEE@microsoft.com...
>I have several MS Access databases that are linked together in on way or
> another that work fine. I now have to make reports for our intranet to
> view
> the data, but not edit it, for our upper echelon of employees. The
> workers
> enter the data thru front-end/back-end MS Access db's. No problem there.
> The problem is when I try to connect to the main db thru an asp page. I
> have
> done every way possible to connect to this db, ie: setting up all
> different
> DSN's possible to the db, and using both the full connection string
> ("driver=........) and DSN connection string ("DSN=....."). So what I
> did,
> was to recreate the system at home. I have a server(NT4.0 SP4 stand alone
> w/the Option pack installed, IIS4.0, VS6.0, Office2k) on a generic
> machine,
> no name brand computer (Dell,HP,.....). I use Visual Studio 6.0 on my
> computer (HP w/WinXP H.E.,Office2007) I could not connect using the full
> connection string, but when I made the systemDSN and used the DSN
> connection
> string, it works. I can access the db. So, I took that info and went to
> work. I get an error that the SETSQLATTR(?) can not be set. The work svr
> is
> a Dell OptiplexGX110 w/NT4.0, VS6.0, Office2k. I made the connection
> string
> and it tested good but when I try to test the connection via asp, I get
> the
> error. I have also set the permissions on every folder that I can think of
> to
> allow everyone and the IUSR_* and IWEB_* to full permissions and to
> execute
> scripts. What else should or could I do?
>
> My Connection String
> Provider=MSDASQL.1;Persist Security Info=False;Mode=ReadWrite;Extended
> Properties="DBQ=I:\Cadets_be.mdb;DefaultDir=I:\;Driver={Micr osoft
> Access Driver (*.mdb)};DriverId=25;FIL=MS
> Access;FILEDSN=\\Orion\Databases\Cadets_be.mdb.dsn;MaxBuffer Size=2048;
> MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=10;UI D=admin;
> UserCommitSync=Yes;"