ODBC.INI file error

har · Post by **har** » Wed Apr 18, 2007 10:03 am

Hello,
I'm able to connect sql server db in dev but when i try to connect to same db from QA env the example script in branded_odbc is unable to connect to dsn.And the interesting thing here is , i able to connect to different dsn on same database in QA.
i didnt find any diff bwten two odbc.ini file's.
And ideas:
Here is the odbc.ini file for DEV and QA:
DEV:
[TransferDatabase]
Driver=/apps/ascential/dev/ds/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect SQL Server Wire Protocol
Database=TransferDatabase
LogonID=ABC
Password=abc
Address=10.2.210.96,1155
QuotedId=No
AnsiNPW=No
.....................................................................................................
QA :
[TransferDatabase]
Driver=/apps/ascential/tst/ds/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect SQL Server Wire Protocol
Database=TransferDatabase
LogonID=ABC
Password=abc
Address=10.2.210.96,1155
QuotedId=No
AnsiNPW=No

The following error is thrown by example script :
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [DataDirect][ODBC lib] Data source name not found and no default driver specified

SQLConnect: Retrying Connect.
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [DataDirect][ODBC lib] Data source name not found and no default driver specified

SQLConnect: Retrying Connect.
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [DataDirect][ODBC lib] Data source name not found and no default driver specified

Thanks,
Har

DSguru2B · Post by **DSguru2B** » Wed Apr 18, 2007 10:25 am

How many entries of "TransferDatabase" do you have in .odbc.ini file?

har · Post by **har** » Wed Apr 18, 2007 11:03 am

Only one entry

DSguru2B · Post by **DSguru2B** » Wed Apr 18, 2007 12:36 pm

Make sure the DSN name is identical inside your job and in the .odbc.ini file. Thats the only other thing that could be wrong. Make sure there are no leading trailing spaces. They should be identical.

har · Post by **har** » Wed Apr 18, 2007 1:46 pm

I'm trying to test connection form branded_odbc example script.
I check .odbc.ini file and their are no spaces in it.
And i comapre dev and tst enironment .odbc.ini file with diff command and i didnt find any difference.Its so strange for me..
And from tst env i'm able to connect three database on same box and except this one.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 18, 2007 4:23 pm

Is 1155 the correct port number in your QA environment?

har · Post by **har** » Thu Apr 19, 2007 6:49 am

Yes and i able to connect this port from dev server.
Not able to connect to same port from QA server.It was so misterious for me.I compare dev and qa .odbc.ini file and their is no difference.
Do i need to contact IBM Tech support or ami doing any silly misatke !

DSguru2B · Post by **DSguru2B** » Thu Apr 19, 2007 8:21 am

Delete the entry and retype it again. Save the file and then try again.

har · Post by **har** » Thu Apr 19, 2007 1:33 pm

i gone throug the process,wat ur saying but it didnt work ..

DSguru2B · Post by **DSguru2B** » Thu Apr 19, 2007 1:38 pm

I guess I have hit the limit to the amount of help I can provide sitting on this side of the screen. Get someone else involved who is present at your site. If to no avail, contact support.

mctny · Post by **mctny** » Thu Apr 19, 2007 1:51 pm

Did you check your uvconfig.odbc files and compare them?