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
DSN.
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 http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server
-----Original Message-----
From: Tracker 1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 8:28 AM
To: [EMAIL PROTECTED]
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
in
> >/var/www/html/index.php on line 4@
>
> Microsoft. :-)
>
> Microsoft defines possible database connections as "DSN" in the ODBC
Control
> 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*]theroughnecks.com
Roughneck BBS: http://www.theroughnecks.net telnet://theroughnecks.net
=======================================================================
Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email
One program for aim/icq/yahoo/msn/irc - http://www.trillian.cc/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
