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 |
|
Chubbly Geezer
Starting Member
8 Posts |
 Posted - 2005-07-28 : 11:46:15
|
| Hi I have some code that I am testing to read data from a FoxPro file.I have copied the FoxPro file locally to test.I have created a linked server that points to this file.Enterprise manager correctly shows the tables available.Works fine.! However, when I create another linked server pointing towards the network files,enterprise manager shows no available tables and my code returns an error stating that the table does not exist.I can however import these tables using a DTS job.The following 2 lines of code ALSO return table data:EXEC sp_tables_ex @table_server='OPERA_SERVER'EXEC sp_columns_ex @table_server='OPERA_SERVER', @table_name='ssale'I have checked the security permissions on the network drive/directories and I appear to have full access.I can indeed move, delete etc these files.Any ideas why I cannot connect in enterprise manager and execute my code..? Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-28 : 12:01:37
|
| some questions:1. How many machines are involved in your testing? Do you have a client workstation and a server? or is everything installed (sql server, etc.) and being tested on your workstation.2. When you say you copied the Foxpro file locally, do you mean that you copied the foxpro file to your workstation C: drive or your Server C: drive?3. When you point the linked server to the network resource, where have you mapped the drive? on your workstation or on the server?-ec |
 |
|
|
Chubbly Geezer
Starting Member
8 Posts |
Posted - 2005-07-28 : 12:15:56
|
| Hi ecmy workstation is also a test server. Live data is held on a remote server.To test:Within Enterprise manager I connect to my local workstation (server) where I have 2 linked servers created. One connects to test data copied to my workstation c: drive which works fine. The other apparently connects to a remote server (lets say Server A) and returns no tables.Live:On the live SQL server I have a linked server which again connects to Server A. This agin returns no tables.Does this answer the questions? |
|
|
|
Chubbly Geezer
Starting Member
8 Posts |
Posted - 2005-07-28 : 12:34:46
|
| Correction. The following 2 lines of code DO NOT WORK.. EXEC sp_tables_ex @table_server='OPERA_SERVER' EXEC sp_columns_ex @table_server='OPERA_SERVER', @table_name='ssale' |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Chubbly Geezer
Starting Member
8 Posts |
Posted - 2005-07-28 : 12:39:47
|
| Yep, downloaded yesterday. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-28 : 13:04:58
|
quote:
Originally posted by Chubbly Geezer
Yep, downloaded yesterday.
I'll try some testing later on today and see if I can see what is going on.-ec |
|
|
|
Chubbly Geezer
Starting Member
8 Posts |
Posted - 2005-07-28 : 13:06:21
|
| Would be very much appreciated thanks.Can link to an Excel file on the same server, just not FoxPro. |
|
|
|
|
|
|
|
|
Linked Server problems