On Thu, 2003-09-11 at 11:32, [EMAIL PROTECTED] wrote:
> Hi,
>
> Thanks, "use dbA" works. It doesn't work as part of a do statement (i.e. $dbh-
> >do("use dbA")), but it looks like it's working when I prep and execute "use
> dbA" using a statement handle.
If the do() doesn't work it's probably because you already have an
active statement handle for that $dbh, and DBD::Sybase will open a
second connection in that situation.
>
> I'm using DBD::Sybase v1.01, so I guess there's still an issue with DBI only
> connecting to the default db. I've cc'd dbi-dev since they might like to know
> about this bug.
I know that setting the database this way works when using the Sybase
libraries. I suggest that you run your script with DBI->trace(3) and
send me (not the list) the output from that trace.
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html
