Sybase DBD issue

[CherylD]

Hi there,
I'm not sure whether to post this in MS SQL or here, so I'll try both! I think this is a setting in SQL, but maybe someone else has come across this. I have a cgi script that runs a query using Sybase to connect to SQL Server 2000. This works if I use one DB but not another. Here is the error from the apache logs:

DBD::Sybase::st execute failed: Server message number=208 severity=16 state=1 line=1 server=SQLDB1 text=Invalid object name 'SysDBA.CONTACT'.Server message number=208 severity=16 state=1 line=1 server=SQLDB1 text=Invalid object name 'SysDBA.ACCOUNT'.Server message number=208 severity=16 state=1 line=1 server=SQLDB1 text=Invalid object name 'SysDBA.ADDRESS'.


I figure that it's an issue somewhere in SQL as on DB works and one doesn't on the other (same table structure, etc). I run sp_help and the owner of the tables is SysDBA...and I'm at a loss as to why it won't work. Any suggestions/solutions would be greatly appreciated.

Thanks.

 

[hmerrill]

If you don't get an answer here or in MS SQL, ask your question on the DBI mailing list - there are many excellent people on that list, including many who are very knowledgable about Sybase and DBD::Sybase.

HTH. Hardy Merrill

 

[CherylD]

Thanks Hardy Merrill.

 

[Jbajin]

I would make sure that on that other box, that Sybase is available. The other issue is that you might not be pointing to the correct Database.

See if you can manually log in say using ISQL and see if you get the exact same thing. Hope that helps.