Naw, this is Linux :)

But for anyone searching the archives, the "Data source name not 
found, and no default driver specified" means one of four things:

1. you don't have a DSN with the name you are using
2. you don't have a driver where the DSN expects to find it
3. on Windows, you are trying to use a File/User DSN instead of a System
4. on *nix - you haven't specified your ODBCINI environment variable
like: putenv("ODBCINI=/path/to/odbc.ini");   
(note LD_LIBRARY_PATH and ODBCINSTINI may have to be defined as well!)
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software
Universal Data Access & Virtuoso Universal Server

-----Original Message-----
From: Tracker 1 [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, July 03, 2002 8:28 AM
Subject: [PHP] Re: Where do I specify a DSN?

"Richard Lynch" <[EMAIL PROTECTED]> wrote in message...
> > I'm getting this error message...where does it come from?
> >
> >Warning: SQL error: [unixODBC][Driver Manager]Data source name not
> >found, and no default driver specified, SQL state IM002 in SQLConnect
> >/var/www/html/index.php on line 4@
> Microsoft. :-)
> Microsoft defines possible database connections as "DSN" in the ODBC
> Panel.
> Open up the ODBC Control Panel, and make a DSN named "foo" and point
it to
> the database you want to access.

it said unixODBC, not sure what he was trying to connect to though,
may be best to use the native connection drivers?

Michael J. Ryan  -  tracker1[*at*]
Roughneck BBS:  telnet://
Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email
One program for aim/icq/yahoo/msn/irc  -

PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to