1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Unable to retrieve table

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

  1. #1
    Hi,
    SEMrush
    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
    SEMrush
  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