Daniel, If you are accessing an Access 2k database, I would use OLEDB rather than ODBC. With this you would not require a DSN, and the speed is greater.
ex. $conn = new COM("ADODB.Connection"); $connString = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=F:\someMDB.MDB;User Id=Foo;Password=Bar'; $conn->Open($connString); $rs = $conn->Execute("SomeSQL"); $conn->Close(); "Daniel Parsons" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > I'm running PHP 4.0 on WinNT 4 with IIS and attempting to use an Access > 2000 database. When I use this is a script: > > $logdb = odbc_connect("uptime", "user", "password"); > > it gives the following error : > > Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name > not found and no default driver specified, SQL state IM002 in > SQLConnect in D:\Inetpub\wwwroot\daniel\showuptime.php on line 20 > > I have set up a System DSN with the name 'uptime' in the ODBC > connections on the server and just can't figure out why it isn't finding > it. I haven't rebooted the server since adding the DSN but it is running > some other stuff that means rebooting is really a last resort thing. > > Can anyone enlighten me to the really small obvious thing that I have > probably overlooked? > > Cheers, > Daniel > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]