Skip to Content
avatar image
Former Member

Re:1111340 error.

Hi All,

I am a newbie to BODI. I have installed 11.7.2 Data Integrator version and have installed MySQL-connector-odbc-5.1.6-winx64 on a windows 7 OS. I have set up the ODBC connection and while trying to log in to the Data Integrator Designer it gives me the following error:

BODI-1111340 error:ODBC call <SQLDriverConnect> for data source <SAPODBCconnection> failed:[MySQL][ODBC 5.1 Driver] Cant connect to MySQL server on 'localhost' (10061). Notify Customer Support.

Can some one tell me how to resolve this.

Thanks In Advance!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 24, 2010 at 11:18 PM

    DI on windows is 32-bit Application, you can't use 64-bit Driver

    Install MySQL 32-bit driver and create a System DSN (use 32-bit version of ODBC Manager) and use that

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Manoj.

      Thank you. When I use, 32 bit,5.1 ODBC driver, it gets installed well, however driver does not show up in the ODBC drivers tab.

      I figured out a workaorund for this. We need to get into:

      Windows \ SysWOW64 >odbcad32.exe.

      Hope this helps anybody, who has similar issues!

      Thank you.

  • avatar image
    Former Member
    Jun 25, 2010 at 03:27 PM

    I have another issue, after installing the 32 bit, 3.51.27 MySql odbc driver, it still gives me the following error:

    BODI-1111340:Error: Cannot retrieve <Version> from the repository. Also, <No Database Selected>.

    When i try to set up the Job Server Configuration, it gives me the following error:

    SQL Submitted to ODBC data source <MyODBC> resulted in error <[MySQL][ODBC#>%! driver][mysqld-5.0.34-enterprise-nt] No Databse Selected>

    The SQL submitted is <select SERVER_NAME, MACHINE_NAME, PORT from AL_MACHINE_INFO>.

    Is it necessary to have a repository?

    Also, when i try to create a Repository, it gives me the following error:

    BODI-20004: Error or warning in executing the SQL statement <select count() from AL_ATTR where 1=0>. The message from the underlying database is: <Cannot retrieve <Generic Object> from the repository. Additional database information: <SQL submitted to ODBC data source <MyODBC> resulted in error <[MySQL][ODBC 3.51 Driver][mysqld-5.0.34-enterprise-nt]No database selected>. The SQL submitted is <select count() from AL_ATTR where 1=0>.>.>.

    BODI-300054: An error occurred during creation of the local repository.

    Any help is appreciated!

    Thank you.

    Edited by: Ragini_sri on Jun 25, 2010 5:30 PM

    Add comment
    10|10000 characters needed characters exceeded