The problem is that you are most likely running the query under a SQL Server user account. If you run the query under Integrated Windows security, (and your user account has RW permission on the excel spreadsheet) you will not have any problem.
Alternatively you can use the...
I also recieved an error when I attempted to look at the tables from EM. I was working on a test server and so I was able to stop and start SQL server and was able to continue. I would recommend not looking at the tables of an Excel Spreadsheet that is functioning as an attached server through...
Using attached servers is pretty straightforward. I am including the steps I used to set it up. This was run under SQL 2000.
1. Using the master database run the sp_addlinkedserver stored procedure to add the Excell Spreadsheet as a linked server as follows.
EXEC sp_addlinkedserver...
Does anyone know where you can get just the ODBC drivers for Informix. I know it comes bundled with IConnect and other such products, but does anyone know where I can get just the drivers.
Thanks.
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.