Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: MySQL ODBC - Data Source Name Too Long

  1. #1
    Join Date
    Feb 2009
    Posts
    14

    Lightbulb MySQL ODBC - Data Source Name Too Long

    I know, I know... ODBC is not the preferred method to connecting to databases. With that said, I'm wondering if anyone has run into this issue before?

    Code:
    Error connecting to database [edw] : org.pentaho.di.core.exception.KettleDatabaseException: 
    Error occured while trying to connect to the database
    
    
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] Data source name too long
    
    
    
    
    org.pentaho.di.core.exception.KettleDatabaseException: 
    Error occured while trying to connect to the database
    
    
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] Data source name too long
    The actual data source name is "edw", which I have setup as a system DSN and it tests fine in the Mysql Connector interface (v5.1 Driver). If I remove the name, put in a dummy name, it throws the same error. So, I think the "name too long" is not the real issue at hand.

    Is there something more that needs to be done?

    Again, I can get it to work as JDBC but I have a specific need for using ODBC.

  2. #2
    Join Date
    Oct 2010
    Posts
    369

    Default

    i got this error sometime back but not able to recall.i think this error is relating to ur odbc connection, check the jars name if names r too long

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.