Re: ODBC connection- can anybody help....
| From: | Ermanno Iannacci | Date: | Sat, 30 Sep 2000 04:31:47 +0000 |
| Subject: | Re: ODBC connection- can anybody help.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3289@lists.php.net to get a copy of this message | ||
This is yours:
$connect = odbc_connect( "DSN=Name" , "UserID", "Passwrd" ) or die
("Couldn't connect to datasource.");
You don't need to write DSN=Name. Only the name is needed. So:
$connect = odbc_connect( "Name" , "UserID", "Passwrd" ) or die
("Couldn't
connect to datasource.");
----- Original Message -----
From: "Donna Clark" <dclark@sasdesign.co.uk>
To: <php-db@lists.php.net>
Sent: Wednesday, October 04, 2000 11:23 AM
Subject: [PHP-DB] ODBC connection- can anybody help....
I have my PHP my php on server 1 and I am trying to connect to a SQL Server
database on Server 2. I have set up an ODBC datasource on Server 2. But
when I try to connect using the following command :
$connect = odbc_connect( "DSN=Name" , "UserID", "Passwrd" ) or die
("Couldn't connect to datasource.");
I receive the following warning:
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified, SQL state IM002 in SQLConnect....
How can I make it look on server 2 for the DSN ??
Any help would be greatly appreciated !
Donna.