RE: [PHP-DB] ODBC connection- can anybody help....
| From: | Andrew Hill | Date: | Wed, 04 Oct 2000 13:10:37 +0000 |
| Subject: | RE: [PHP-DB] ODBC connection- can anybody help.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3292@lists.php.net to get a copy of this message | ||
Acutally, DSN=Name may be required, it depends on the pickiness of your
driver mananger.
The problem here is, I believe, and inability of your PHP script to find the
odbc.ini file where your DSN is setup.
Try passing a:
putenv("ODBCINI=/path/to/odbc.ini"); into the first line of your script.
Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider
> -----Original Message-----
> From: Ermanno Iannacci [mailto:ermannov@libero.it]
> Sent: Saturday, September 30, 2000 12:32 AM
> To: Donna Clark; php-db@lists.php.net
> Subject: Re: [PHP-DB] ODBC connection- can anybody help....
>
>
> 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.
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>