Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 multiple odbc connections sql and php

Author  Topic 

yaditzal
Starting Member

22 Posts

Posted - 2010-04-28 : 08:59:05
Hi.
I need help with this problem.
I need to connect more than one database using odbc from php.
I'm doing a wdb base aplication in php and I have to use odbc but I don't know how to make the connection to 2 database.
these is how I make a single connection.

define('DB_HOST', 'Bupa01');
define('DB_USER', 'root');
define('DB_PASSWORD', 'root1');
define('DB_DATABASE', 'CWF');


$link = odbc_connect(DB_DATABASE, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server!');
}


I have another database in the same server, the user and pw is same, the only thing that chanse is the database name.

please any help with that.

Thanks
   

- Advertisement -