Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2011
    Posts
    4

    Unanswered: Issue creating Linked server using ODBC Connection to an HP3000 Image/sql database

    Hi,

    Scenario: Extract data from HP3000 Image/Sql database into SQL server 2008 every hour.
    I am trying to get the connection working. I tried doing an 'Import Data' using the wizard in SQL Management Studio. Using '.Net Framework Data Provider for ODBC' and by using the string "Dsn=;Driver={}", I was able to dump data from one of the tables on the HP3000 db into sql server.But to pull data every hour, I considered creating a linked server. I selected 'Microsoft OLE DB Provider for ODBC Drivers' as the provider and connection string 'Dsn=;Driver=;Uid=;Pwd='. I get an error 'the data source object of OLE DB provider 'MSDASQL'. Does anyone know what is the correct connection string to be used? I have tried various combinations and none worked.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jul 2011
    Posts
    4
    Thanks

    Yes I had checked this link out.

    I have now been able to get data from the HP 3000 server into SQL server 2005 using the linked server concept. This errors out in SQL Server 2008 when trying to create a linked server.

    I receive 'Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ABC". Data source name not found and no default driver specified.'

    Any ideas why this happened?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Have you installed the ODBC drivers for IMAGE on the machine that is running SQL 2008 ?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Jul 2011
    Posts
    4
    Yes. I have installed the 32 bit MB Foster UDALink ODBC driver using the 32 bit ODBC application from the Syswow4 folder. The same I did on Sql server 2005.
    The error I get is 'Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server"ABC".

    Any ideas?

  6. #6
    Join Date
    Jul 2011
    Posts
    4
    Also, I forgot to mention here that the Sql server 2008 is a clustered Sql server. Could this make things different?

  7. #7
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    You have to install the driver on all the nodes in the cluster than can host your SQL Server instance, apart from that it should not make anything different.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •