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);