Bill McClintock writes:
> > Are you positive that this user can access each of these databases?
> Yes...When the script is run on a Win32 platform using DBD::ODBC I can
> specify the username and password and get the specified data from the
> specified database. with the DBD::Sybase driver all data for all
> combinations comes form the users 'default' database.
You can always specify the database in the query itself:
select ... from databasename..table where ...
You could try that and see how that works (just as a test.)
> > Right - this comes from dbdimp.c, in the syb_db_use() function. In
> > general there should be some other errors associated with that -
> > messages from the server - something like:
> the only message what I see, and I believe its a warning, is the 'cant
> change context'
Can you run that with DBI->trace(3) or so?
> > Have you tried a simple $dbh->do('use my_database2'); to see if that
> No...I have not and not even sure if thats a valid test for my scenario...
Yes it is - it's the exact same functionality, only called explicitly
on the database handle.
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] *or* [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com
