Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-08 : 09:10:06
|
Stacy writes "I've set up a linked server to our as/400 so that I can do a distributed query in DTS using both the sql server database and then as/400 database. It doesn't seem to be working. If I do a query on it it just seems to hang. When on look at the processes it says PAGEIOLATCH_SH under the wait type. There currently is nothing else running whats going on. This is how I have the linked server configured.
Other data source - Microsoft OLE Db provider for odbc drivers
Product name - OLE Db provider
Data source - AS400
Provider string - MSDASQL
Server options - checked data access
options - checked allowinprocess
security - have it mapped to a specific profile
Since this didn't work I tried doing it with a openqyery and same thing happens it hangs." |
|
|
|
|
|
Linked server - ODBC connection