469,568 Members | 1,477 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

Federated Access - DB2 to SQLServer using unixODBC driver

Hi:

We have a setup which connects a V8.2 32bit db2 instance on AIX to
SQLServer 2000 using the unixODBC driver.

We have 5 SQLServer "Server mappings" and 4 of them work just fine and
can use the nicknames associated with it. The one last mapping is going
against a sqlserver and can't seem to get the nicknames setup on db2.

The error is:
==========
[IBM][CLI Driver][DB2/6000] SQL1822N Unexpected error code "IM002"
received from data source "SQLSERVERIDX". Associated text and tokens
are " Data source name not found and no default driver s".
SQLSTATE=560BD

I am being told that the name of the NT Server hosting the SQLServer is
different than the "SQLServer name" and this could be the reason for
the mapping not to work.

So, in the odbc.ini file, is it possible to give the SQLServer Name
along with the database name?

The odbc has the following entry for this data source:

[SQLServerIDX]
Driver=/opt/odbc32v51/lib/ivmsss21.so
Description=DataDirect 5.1 SQL Server Wire Protocol
Database=Clarra
Address=192.168.127.57,1433
Is there an option like "Server=<your_sqlserver_name>" that i could add
to the above ????

Any help is appreciated!
Thanks!

Vijay

Jun 27 '06 #1
0 1374

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Mairhtin O'Feannag | last post: by
3 posts views Thread by Greg | last post: by
reply views Thread by stevenkblack | last post: by
5 posts views Thread by Alias | last post: by
6 posts views Thread by Paradigm | last post: by
3 posts views Thread by harsha.patibandla | last post: by
4 posts views Thread by Gregor =?UTF-8?B?S292YcSN?= | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.