RE: [PHP-DB] ODBC connection- can anybody help....
| From: | Andrew Hill | Date: | Wed, 04 Oct 2000 13:16:13 +0000 |
| Subject: | RE: [PHP-DB] ODBC connection- can anybody help.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3293@lists.php.net to get a copy of this message | ||
Whups,
I missed that you want to connect to a DSN on server 2... you cannot do
this with most drivers, but you will be able to make a connection by setting
up your DSN and driver manager on Server 1. If you do need to make a
connection to another DSN on a second box for some reason, you will want to
explore Openlink's Multi-Tier drivers, setup in a 3 tier configuration. I
would be happy to assist.
Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider
> -----Original Message-----
> From: Andrew Hill [mailto:ahill@openlinksw.com]
> Sent: Wednesday, October 04, 2000 9:11 AM
> To: Ermanno Iannacci; Donna Clark; php-db@lists.php.net
> Subject: RE: [PHP-DB] ODBC connection- can anybody help....
>
>
> 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
> >
> >
> >
>
>
> --
> 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
>
>
>