RE: switching to a different database from a DSN to INFORMIX database

2001-07-12 Thread Mahdi A. Sbeih

When defining a new DSN, you need to supply a database name to 
connect to by defualt, so it is just the defualt database, that
means that I can connect to any database on the Informix server
where the defualt database resides.

The question here, how? It seems that I am a lecturer :-)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 5:42 PM
To: [EMAIL PROTECTED]
Subject: RE: switching to a different database from a DSN


Some databases allow you to share tables form others, so you could try 
that, I think that it is called a Database Link.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: 11 July 2001 14:18
 To: [EMAIL PROTECTED]
 Subject: switching to a different database from a DSN
 
 
 Hi all,
 
 I am using DBI::ODBC on windows platform to
 access Informix database.
 I defend database x when I created the DSN.
 Is there a way to switch to a database different
 from the one defined when creating the DSN.
 
 In other words use the same DSN to access all the 
 database on the same database server.
 $dbh = DBI-connect(dbi:ODBC:myDSN,,,\%attr);
 




RE: switching to a different database from a DSN

2001-07-11 Thread Gregory_Griffiths

Some databases allow you to share tables form others, so you could try 
that, I think that it is called a Database Link.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: 11 July 2001 14:18
 To: [EMAIL PROTECTED]
 Subject: switching to a different database from a DSN
 
 
 Hi all,
 
 I am using DBI::ODBC on windows platform to
 access Informix database.
 I defend database x when I created the DSN.
 Is there a way to switch to a database different
 from the one defined when creating the DSN.
 
 In other words use the same DSN to access all the 
 database on the same database server.
 $dbh = DBI-connect(dbi:ODBC:myDSN,,,\%attr);