RE: [PHP-DB] ODBC connection- can anybody help....
| From: | Sanders, Nicholas | Date: | Wed, 04 Oct 2000 10:06:33 +0000 |
| Subject: | RE: [PHP-DB] ODBC connection- can anybody help.... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3286@lists.php.net to get a copy of this message | ||
Need to set up ODBC Data Source on Server 1 not Server 2. You will need SQL
Server Client libaries on Server 1.
> ----------
> From: Donna Clark[SMTP:dclark@sasdesign.co.uk]
> Sent: 04 October 2000 10:23
> To: php-db@lists.php.net
> 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.
>
>
>
>