[unixODBC-support] WAS: unix-odbc : db2 IBM iseries over cygwin; Now: over Linux

Eric Sharkey sharkey at netrics.com
Tue Jul 12 20:39:57 BST 2005


>  # then I made a 'template' odbc.ini_template with the following content
>  # $ cat odbc.ini_template
>  # [DB2]
>  # Description     = iSeries Access for Linux  ODBC data source
>  # Driver          = /usr/local/etc/libcwbodbc.so
>  # Setup           = /usr/local/etc/libcwbodbcs.so
>  # and ran   odbcinst -i -s -f odbc.ini_template
>  odbcinst -i -s -f odbc.ini_template
>  # the above ran silently
> 
> 
>  # finally I try isql
> $ isql -v sys06
> [IM002][unixODBC][Driver Manager]Data source name not found, and no 
> default driver specified
> [ISQL]ERROR: Could not SQLConnect
> 
> So what do I do now? Where did I go wrong?

The datasource name is the thing in square brackets in the odbc.ini
file.

You've set up a datasource named "DB2" and asked isql to connect to
the datasource "sys06" and it responded "Data source name not found",
because there is no [sys06] section in your odbc.ini file.

Eric



More information about the unixODBC-support mailing list