MSSQL & AS400 DB2 (Linked Server)

[humayun]

I have created a Linked Server in MSSQL. When i run a select command in query analyzer thru openquery, i shows me less rows compared to the rows existing on AS400 DB2.
What could be possible reason?

[rmiao]

Which provider do you use for linked server?

[humayun]

Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;Pwd=myP assword;

[rmiao]

Tried with Microsoft ole db provider for odbc driver?

[pinktek]

the function of creating a linked server provide? does it allow you to be able to query information from the server

[rmiao]

There is no function to create provider, you have to get them from vendors.

[MAK]

I used Neon client before.

http://www.databasejournal.com/featu...le.php/1756161

[humayun]

I used Neon client before.

http://www.databasejournal.com/featu...le.php/1756161

Dear MAK
Thanks for the help, i tried exactly as you explained, but when i run the command in query analyze, i got this error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

[pinktek]

Pledge
Donor/Contributor ID
Pledge Date
Pledge Amount
Pledge Expiration
Pledge Receipt confirmation

Donation
Date
Donor/Contributor ID
Amount
Thank you note


Donor
Name
Address
City,State, Postal
Phone
Email


Contributor
Name
Address
City,State,Postal
Phone
Email

Campaign
Campaign Date
Donor/Contributor ID

I would create these tables how do they look each with many to many relationship now i gotta think where and how to enter it.

[MAK]

humayun

1. your subsystem, plan name and catlog prefix may be different. check with your DB2 Admin.

2. did you create the ODBC system DSN DB2C?

3. Did you create the ODBC DSN on the SQL Server machine?