Re: Problems setting up a DSN

Hi Daniel, Did u try to connect the DSN using MS Access? Try some troubleshooting so that u can find where the error is. If u can't connect to DSN using MS Access also, there may have some problems in ur database drivers or ODBC settings. P/S: You dun have to reboot the computer in order to add a new DSN. -- regards, chen wei (http://www.cw213.net) =================================== Solutions Developer of Earth9.com =================================== Wednesday, September 26, 2001, 5:48:05 AM, you wrote: DP> Hi, DP> I'm running PHP 4.0 on WinNT 4 with IIS and attempting to use an Access DP> 2000 database. When I use this is a script: DP> $logdb = odbc_connect("uptime", "user", "password"); DP> it gives the following error : DP> Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name DP> not found and no default driver specified, SQL state IM002 in DP> SQLConnect in D:\Inetpub\wwwroot\daniel\showuptime.php on line 20 DP> I have set up a System DSN with the name 'uptime' in the ODBC DP> connections on the server and just can't figure out why it isn't finding DP> it. I haven't rebooted the server since adding the DSN but it is running DP> some other stuff that means rebooting is really a last resort thing. DP> Can anyone enlighten me to the really small obvious thing that I have DP> probably overlooked? DP> Cheers, DP> Daniel