How do I get rid of the user id in front of the database object name when
connecting to ms sql database using ODBC driver from jaguar cts? I am
getting this error because the user is not the owner of the table:

ERROR: Retrieve Failed = -1 *****
Select error: SQLSTATE = S0002 [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'ppmchong.rdg_negara'.

When I check the database, the owner is the db administrator.

Basically, we have migrated the database to a new server, however the owner
of the table changed. When we are using the same datawindow object, we have
this problem.

Your help much appreciated.

Syed.