on 03-05-2014 3:05 PM
Hi,
I have issue with connecting to Sybase ASE after upgrading from base IQ 16 to SP03.
Unable to connect to server 'SYBASE_ASE': [Sybase][ODBC Driver]Null ini
file or ini file not found in $SYBASE or current directory
SQLCODE=-656, ODBC 3 State="HY000"
Valid .odbc.ini file exists in $SYBASE as well as in $HOME or in current directory.
Does anyone have same issue with SP03?
Driver used is libsybdrvodb.so which is pointing to Sybase ASE DataAccess64/lib and is properly loaded with LD_LIBRARY_PATH.
Thanks,
The IQ SP03 install does not contain any ASE ODBC driver components. Most likely you have a path conflict.
When you install, do you use a different $SYBASE home directory for the IQ installation vs. the ASE installation? If so, check which $SYBASE is in use, as that points to the 'interfaces' file in use. Your DSN my be using the interfaces name of the ASE and not the host/port.
i.e. the IQ.sh script in the $SYBASE used by IQ will call the $SYBASE/SYBASE.sh when it runs. If you install to a different $SYBASE directory for IQ, then this $SYBASE does not contain an interfaces file.
Correct your paths or copy the interfaces file from the ASE $SYBASE directory to the IQ $SYBASE directory.
Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You may also want to check out Rob V's write-up on this. It doesn't mention IQ 16, but is still valid.
http://www.sypron.nl/iq_ase_odbc.html
Mark
Hi Abhijit,
You can look at this doc for setting up connection between IQ and ASE
http://scn.sap.com/docs/DOC-49096
Thanks
Saroj
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.