Sorry to bother you so much but i am new to SQL server .. can you tell me how can i do that. transfer data using DSN ?
Thanks ..i really appreciate your help with this issue
The rest of the options on linked server are as follows:
Linked server = AS400
other data source provider name = Microsoft OLE db provider for ODBC drivers
Product name =Client Access
Data source = MyDSN name here
Provider string = no value (blank)
Location = no value (blank)
catalog = no value...
Thanks again for your response. I am connected using the same id and password using client access. and on security tab on sQL server linked servers, i am clicking (they will be mapped to then the exact same user id and pwd)
I think that the problem might be coneecting OLE DB to ODBC (DSN) but i have already installed SQL server SP1,2,3 and MDAC 2.5 and 2.6 ...is there any other way to change ole db provier for ODBC drivers?
Thanks for your continued interest
Hello,
We are trying to link SQL server 7 (with sp3 on NT 4 machine) with
AS400 using client access. I created a DSN but i am getting this
error. I'll really appreciate if anyone can help me resolve this
issue.
Thanks
Fahd
Server: Msg 7399, Level 16, State 1
OLE DB provider `MSDASQL` reported...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.