May 25, 2004 at 9:46 am
At our company, we use Excel with MS Query to return data from the SQL Server. It has worked for all the computers except for the brand new XP computers (running Office 2003). I set up the ODBC connection and to connects just fine. I am able to connect to the database through Excel --> Import External Data --> It then opens the data source (using MS Query wizard) and I am able to set up my query. Once I get to the end where I need to return the data to either Excel or MS Query I get the following error: "Incorrect syntax near 'ID'. Statement(s) could not be prepared."
I don't know what it could be?!!?
HELP!!
Cynthia
May 25, 2004 at 9:55 am
for what you posted is seems that you have an error in the sql statement... is all i can think of from reading your post
why don't you post the query, omitting the sensitive parts of course
Jose Torres
May 25, 2004 at 10:11 am
I don't think it is a problem with the SQL statement since I can run the exact same query on another XP machine that is running Office 2002 and it works just fine.
Anymore ideas?
May 25, 2004 at 2:16 pm
Are you running SQL Server 2000 SP3? What MDAC version is on the server? (Check the registry under HKLM\SOFTWARE\Microsoft\DataAccess)
Is this the same as the MDAC on the new XP wiorkstations?
Francis
June 1, 2004 at 8:17 am
I have checked the server and the workstations. The server is running SQL Server SP3 and the MDAC is 2.71.9030.9 version. The workstations are running MDAC 2.71.9030.0 version. Could this be the problem?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply