John,
I don't have a SQL reference in front of me either. But I remember that if you specify the full name of the table, including database name, you need to reference the database owners name also.
PF
>I don't have a SQL reference here right now, but I think you can specify the database name in fron of the table name in SQL Server, as in SELECT db.table.column .......
>
>>I have an SQL system with a "master" database used for system functions and mulitple "company" databases. The ODBC is defaulted to the "master" and the program targets the appropriate "company". I do not have access to the code that does this. I need to execute a stored procedure that increments the next customer number for the company. The code that I have works, but only if I manually set the default database to the appropriate "company" in the ODBC setup as the default database. To execute the sp I create a new connection (SQLCONNECT) and then make a call to the sp.
>>
>>What code can I use to select the appropriate company database before calling the sp? i.e. What is the i-sql equivalent of "OPEN DATA dbname"?
>>
>>TIA
>>Larry
(On an infant's shirt): Already smarter than Bush