Hello to everyone,

I'm just trying to connect a SQL Server database to my page.
When I'm defining the connection, I test it and everything is right.
When I insert a recordset, exactly after choosing the name of my connection, an alert window pop up and tell me "Unable to retrieve tables form this connection, click on Define or Cancel" and ant table compare under it.

I don't know what to do.

The SQL database is OK, the connection is OK, What I missed ?

what are your connection settings? is the database local or remote?

-- J

The database is on a remote server, connected to my computer through local Network.

Defining the DSN, I set up the server name and the database name on the server itself.

The connection is good, the tables are not !