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