Leave feedback
  • Question

    ODBC on win 64-Bit (Data source name not found and no default driver specified)

Enter a new topic
  • Aristar Borg Aristar Borg
    0 likes 1073 views

    Hi all,

    I have an issue where I think that I have set up ODBC correctly but still getting "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

    I am working on Streamserve 32 Bit on Win Server 2012 R2 64 Bit. I am using ODBC 32 Bit with a 32 Bit Oracle Driver installed. Test connection is ok so the data source is correct.

    What comes next? Do I just call OdbcConnect(str_dbidentifier, str_data_source, str_userID, str_password); ? Or is there something I must do before?

    If that is all I have to do, any ideas why its not working for me?

    As Vyv recommended here http://streamshare.streamserve.com/Forum/Topic/?topicID=1104&p=2
    my Streamserve installation is in C:\Program Files\OpenText\StreamServe i.e. (no brackets in path)

    thanks
    Aristar Borg

    Monday 23 May, 2016
  • Peter Martens Peter Martens StreamServe Employee
    0 likes

    Hi Aristar,

    It's sounds obvious, but is often forgotten. Do you have next to your ODBCConnect(..) also a corresponding ODBCDisconnector ?

    Regards, 
    Peter

    Monday 23 May, 2016
  • Aristar Borg Aristar Borg
    0 likes

    Hi Peter,

    yes I have. I am attaching my details just to be sure about the parameter details.
    My script: $v_ODBC_ret = OdbcConnect("CER11STG01","CER11STG01","STRSRVAPPDOMAIN","XXX"); 

    thanks
    Aristar

     

    Monday 23 May, 2016

    Attached files

  • Peter Martens Peter Martens StreamServe Employee
    0 likes

    Hi Aristar, 

    What does the StreamServe log say? What error are you getting?

    Regards,
    Peter

    Monday 23 May, 2016
  • Aristar Borg Aristar Borg
    0 likes

    Hi Peter

    This is what I am getting:

    SQL State = "IM002", Error Message = "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" $v_ODBC_ret = -1 SQL State = "IM002", Error Message = "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" $v_ODBC_ret = -1 SQL State = "IM002", Error Message = "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" $v_ODBC_ret = -1 SQL State = "IM002", Error Message = "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" $v_ODBC_ret = -1 Failed to process queue item 337EDE70-F391-35E2-E053-46B810AC000B thanks Aristar

    Monday 23 May, 2016
  • Aristar Borg Aristar Borg
    0 likes

    Sorry about that, I don't know why it does not keep my formatting. Attached is a screenshot showing better logging.

    thanks
    Aristar

    Monday 23 May, 2016

    Attached files

    Log.jpg 77 KB
  • Peter Martens Peter Martens StreamServe Employee
    0 likes

    Hi Aristar, 

    You created the ODBC connection as a System DSN?

    Regards, 
    Peter

    Monday 23 May, 2016
  • Aristar Borg Aristar Borg
    0 likes

    Hi Peter,

    I did that and now now I am getting 
    SQL State = "IM014", Error Message = "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

    thanks
    Aristar

    Monday 23 May, 2016
  • Vyv Lomax Vyv Lomax Administrator
    0 likes

    This post may help. Or not.

    Vyv

    Monday 23 May, 2016
  • Aristar Borg Aristar Borg
    0 likes

    Seems like there is a conflict between the 64 Bit OS vs 32 Bit Oracle vs 32 Bit ODBC but cannot figure out why as I think that I'm doing everything the other threads recommend. The ODBC 64 Bit shows any connections I create from under the ODBC 32 Bit but which I cannot touch thus confirming that the connection has really been created from the 32 Bit ODBC. See attached.

    Monday 23 May, 2016

    Attached files

  • Peter Martens Peter Martens StreamServe Employee
    0 likes

    Hi Aristart, 

    Haven't tried this myself yet, but maybe you can create a work around by using the build in JDBC drivers. 

    See also: http://streamshare.streamserve.com/Forum/Topic/?topicID=1680

    Regards,
    Peter

    Monday 23 May, 2016
Next