Hi Stephane ---

I don't think you can use one DSN for two SQL Server databases but I could be wrong. Are you explicitly naming the database in all SQL statements, ie, "SELECT * FROM database table" ?


>HI !
>
>I have a problem with VFP 5.0 and SQL Server 6.5.
>I want to update 2 tables that are in a different database in SQL Server.
>
>code with the problem
>=================
>1- I use the command "SQLConfigDataSource" to create a datasource for my server. The database is the database by default. (Database_1)
>2- I create one connection to SQL with the command "SQLCONNECT" for my tables.
>3- I make each cursor updatable.
>
>When I update the table that is in the default database (Database_1) of the DataSource everything works fine.
>But, for the other table (in Database_2) I receive the error : [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'MySecondTable'.
>
>code to resolve the problem
>=====================
>1- I create 2 DataSources. (One for each Database in Sql Server).
>2- I create 2 connections. (One for each Table).
>When I update the data, my code just works fine.
>
>Did someone know a better way to update tables in different database.
>Can I use only one DataSource ?
>
>Thanks in advance ! :o)
>
>Steph