Search results for query: *

Thanks alot I really appreciate your help.

So you think ..the problem is with OLE DB driver then? to link servers ?

Thanks for the link ....works like a charm. I am able to improt a table from AS400.

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

I can use that exact DSN using microsoft access 97. so i must have the autherization.

I am keeping it blank but in SQL server security/Linked server(they will be mapped to), i am giving name and password to use if none is given.

Thanks for your response. yes i do have a link using client access and i am connected. Thanks

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...