table names not correct, help..

[Ian]

Hi there,   This is probably a really easy one but I just converted an MS SQL Server DB to Sap and the conversion went ok. I have a user called dba which is the database administrator but everytime I use the ODBC driver to connect to the sap db. My tables are coming back in the form of dba.tablename   Hence a table by the name of “extensions” is no longer extensions but dba.extensions   I know this is an easy one but I can’t figure it out <grin>.. Our existing application only does queries using the base table and not dba.tablename so I would need to update quite large collection of querys   I thought maybe it is something to do with the ODBC sqlMode or similar   Any help anyone can offer would be really appreciated   Ian   This email has been scanned for viruses and found to be clean. I can be contacted via MSN Messenger using [EMAIL PROTECTED] as the signin name. Why not use it!?