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 - 2002-04-01 : 09:12:48
|
| jet writes "hi. i have an application which needs to access a text file regularly on a different pc(say pc_remote). i tried linking pc_remote via the Linked Servers but sql server(which is installed in pc_local) couldn't see the file. however when i transferred the text file to pc_local, sql server successfully accessed it.the schema.ini file is located in the same directory as the text file. i used the ff linked server configuration:Provider Name: Microsoft Jet 4.0 OLE DB ProviderData Source: \\pc_remote\ewsdProvider String: texti am using windows nt server 4.0, windows nt workstation 4.0 andsql server7." |
|
|
|
|
|
distributed queries