ODBC connection- can anybody help....
| From: | Donna Clark | Date: | Wed, 04 Oct 2000 09:23:26 +0000 |
| Subject: | ODBC connection- can anybody help.... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3284@lists.php.net to get a copy of this message | ||
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.