The OLE DB provider "X" has not been registered

Discussion in 'Databases' started by craigedmonds, Feb 3, 2008.

0
  1. #1
    Hi SQL Gurus,

    I have moved a sql 2000 database (not the first time) to a newer sql 2005 database and I have changed the ip address in the connection string etc and now I get this error.


    Microsoft OLE DB Provider for ODBC Driverserror '80004005'[Microsoft][ODBC SQL Server Driver][SQL Server]The OLE DB provider "SQL01-123MARBEL" has not been registered.

    This is the connection string: connection="Provider=MSDASQL;Driver={SQL Server};Server=XXXX;Database=XXXX;UID=XXXX;PWD=XXXX;"

    Any ideas becasue this has cost me 6 hours today.
     
    craigedmonds, Feb 3, 2008 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What programming language are you using?
     
    AstarothSolutions, Feb 3, 2008 IP
  3. Bryce

    Bryce Peon

    Messages:
    1,235
    Likes Received:
    93
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Why are you using an OLE DB connection, why not use a DSN-less connection? PM me if you need thecode or help, will help you out.
     
    Bryce, Feb 5, 2008 IP
  4. craigedmonds

    craigedmonds Notable Member

    Messages:
    706
    Likes Received:
    135
    Best Answers:
    0
    Trophy Points:
    235
    #4
    I also switched to a dsnless connection and still the same problem.

    Its a bit baffling really becasue we can do selectes and inserts etc.

    It must be some setting on the new sql server I guess.
     
    craigedmonds, May 18, 2008 IP