Unable to retrieve table

Discussion in 'C#' started by emerld, May 1, 2006.

  1. #1
    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.
     
    emerld, May 1, 2006 IP
  2. jfilley

    jfilley Peon

    Messages:
    18
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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;
     
    jfilley, May 2, 2006 IP