Hi, I'm new at ASP. When I try to connect to MSSQL database, I got this error message 'Unable to retrieve table from this connection...'. I try both connection string "Provider=SQLOLEDB;Data Source=localhost;Database=SQLxy;UID=xy;PWD=xy;"and DSN on testing server. OS is Windows XP Pro. Could someone suggest any solution, please. Any help would be appreciated. Thanks.
I think its your datasource. Its not localhost, thats for IIS. Sql default database is (local) try server=(local);database=SQLxy;uid=xy;pwd=xy;