RE: [PHP] Re: Where do I specify a DSN?
| From: | Andrew Hill | Date: | Thu, 25 Jul 2002 17:34:41 +0000 |
| Subject: | RE: [PHP] Re: Where do I specify a DSN? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109552@lists.php.net to get a copy of this message | ||
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:tracker1@theroughnecks.net]
Sent: Wednesday, July 03, 2002 8:28 AM
To: php-general@lists.php.net
Subject: [PHP] Re: Where do I specify a DSN?
"Richard Lynch" <rich@phpbootcamp.com> 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