>I have been creating Remote Views with success to attach to a third-party's SQL Server tables. However, I've been using my laptop connected to their server to do the design. This time, the client is in another state and I can't attach to their server. I created a DBC with a remote view to our own SQL Server to a table called TSP_TIMEENTRIES. I sent the DBC to the client but the front end is throwing an error, saying it can't connect to the table. Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.TSP_TIMEENTRIES'.
>
>I removed the dbo. from the SQL code and it still runs fine on mine, but it then just gives me the same error except the object name is 'TSP_TIMEENTRIES'. I should add that it's the same DSN of course.
>
>Any ideas greatly appreciated.
>JR
Joy,
Are you sure you're connecting to correct server and database with that table in it? You can use CONNSTRING clause of "USE" command to change the connection (no need to use a DSN). ie:
Use myView CONNSTRING "Driver=SQL server;Server=192.140.22.1;Integrated Security=SSPI;Initial Catalog=myDatabase"
Cetin