> 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.
> 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'
> 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...
DB SERVER is a WinNT Server w/ SQL Server 7.0
Clients are a different WinNt server and a Linux RH7.2 using DBD::Sybase
and FreeTDS
> I really don't think that this is the case. It *is* possible that this
> is a bug in the FreeTDS libraries, though.
Only reason I say this is that the script function correctly with
DBD::ODBC on win32.
Michael Peppler wrote:
> 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
--
Bill McClintock - EDMS App/Web Development
MCIWorldcom - Colorado Springs (GOG)
VNet:622-0054 Local:(719)265-0054
Pager:1-800-PAGEMCI PIN#1686599
EMail:[EMAIL PROTECTED]
AOLIM:bm0054
