Bill McClintock writes:
> USER:
> my_user w/ access to all four my_databaseX but 'my_database1' is default
Are you positive that this user can access each of these databases?
> [bmcclint@BM0054 perl]$ ./mssql.pl
> [Thu Mar 21 17:30:49 2002] mssql.pl: DBD::Sybase - can't change context
> to database my_database2
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:
Msg 10351, Level 14, State 1
, Line 1
Server user id 4 is not a valid user in database 'excalibur'
Have you tried a simple $dbh->do('use my_database2'); to see if that
works?
> SO WHAT I HAVE DETERMINED:
> I am guessing that the username is not getting processed correct by the
> Sybase driver.
I really don't think that this is the case. It *is* possible that this
is a bug in the FreeTDS libraries, though.
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] *or* [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com
