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
--
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]
