RE: [PHP-DB] ODBC connection- can anybody help.... From: Andrew Hill (ahill <email protected>)
Date: 10/04/00

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 <email protected>]
> Sent: Wednesday, October 04, 2000 9:11 AM
> To: Ermanno Iannacci; Donna Clark; php-db <email protected>
> 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 <email protected>]
> > Sent: Saturday, September 30, 2000 12:32 AM
> > To: Donna Clark; php-db <email protected>
> > 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 <email protected>>
> > To: <php-db <email protected>>
> > 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 <email protected>
> > For additional commands, e-mail: php-db-help <email protected>
> > To contact the list administrators, e-mail: php-list-admin <email protected>
> >
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>