none
OLEDB Provider for ODBC and DB2 - Data Source Name Not Found And No Default Driver Specified

    Question

  • Windows version : Windows Server 2008 R2
    DB2 UDB version : DB2 v 9.5 fixpack 4 (64 bit ) (It is not Mainframe database)

    Datasource name for database (XXXXXDB) is defined under SystemDSN and able to connect successfully (in ODBC Data Source Administrator).

    For OLE DB provider test:

    I am able to connect database with 'IBM OLE DB Provider for DB2 - DB2COPY1' .

    Opened Excel ->Data->Import External Data->Import Data->New Source ->Other/Advanced
    Select
    Microsoft OLE DB Provider for ODBC

    But in case of 'Microsoft OLE DB Provider for ODBC' hitting the following error message.

    Test Connection failed because of an error in initializing provider.
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    Please let me know how to resolve the issue.

    Thanks,
    Naidu

    Thursday, October 04, 2012 7:25 PM

Answers

  • After reinstalled IBM thin client, it is working fine now.

    Thanks,

    Naidu

    • Marked as answer by VMNaidu Friday, October 05, 2012 2:02 PM
    Friday, October 05, 2012 2:02 PM

All replies

  • This may help:

    http://www.databasejournal.com/features/db2/article.php/3685391/DB2-9-and-Microsoft-Excel-2007---Part-1-Getting-the-Data.htm 

    and

    http://www.ibm.com/developerworks/data/library/techarticle/dm-0606thakkar/index.html


    If a post answers your question, please click "Mark As Answer" on that post or "Vote as Helpful".
    http://dwhanalytics.wordpress.com/


    • Edited by _AKS Friday, October 05, 2012 5:39 AM
    Friday, October 05, 2012 5:38 AM
  • Dear AKS,

    Thanks for your reply.

    I am facing problem with Microsoft OLE DB Provider for ODBC.

    <%
    Dim adoCon
    Set adoCon = Server.CreateObject("ADODB.Connection")
    adoCon.Open "Driver={IBM DB2 ODBC DRIVER};Database=XXXXXDB;HOSTNAME=LOCALHOST;PORT=50000;PROTOCOL=TCPIP;UID=DB2ADMIN;PWD=xxxxxxxxxxxxx*"
    %>

    Simple ASP program to connect database hittingerror because of Microsoft OLE DB Provider for ODBC problem.

    This program has worked upto yesterday since a year.
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    /xxxxxxxxxxxxxxxxx/connection.asp, line 4 

    Please let me know hot to resolve this issue.
    I am reproduced the same issue with EXcel sheet using Microsoft OLE DB Provider for ODBC.

    Thanks,
    Naidu

    Friday, October 05, 2012 10:34 AM
  • Dear AKS,

    Thanks for your reply.

    I am facing problem with Microsoft OLE DB Provider for ODBC.

    <%
    Dim adoCon
    Set adoCon = Server.CreateObject("ADODB.Connection")
    adoCon.Open "Driver={IBM DB2 ODBC DRIVER};Database=XXXXXDB;HOSTNAME=LOCALHOST;PORT=50000;PROTOCOL=TCPIP;UID=DB2ADMIN;PWD=xxxxxxxxxxxxx*"
    %>

    Simple ASP program to connect database hittingerror because of Microsoft OLE DB Provider for ODBC problem.

    This program has worked upto yesterday since a year.
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    /xxxxxxxxxxxxxxxxx/connection.asp, line 4 

    Please let me know how to resolve this issue.
    I am reproduced the same issue with EXcel sheet using Microsoft OLE DB Provider for ODBC.

    Thanks,
    Naidu

    Friday, October 05, 2012 10:36 AM
  • After reinstalled IBM thin client, it is working fine now.

    Thanks,

    Naidu

    • Marked as answer by VMNaidu Friday, October 05, 2012 2:02 PM
    Friday, October 05, 2012 2:02 PM