[AccessD] Pass Trough Query to SQL Server

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon Sep 26 08:46:58 CDT 2005


I am trying to build a pass through query to add a column to a table in
SQL Server. For the ODBC Connect Str I added the text from the Connect
field in the MSysObjects table after the ODBC; that is already in the
field giving me the following 

ODBC;DSN=Forceast;Description=Forceast;APP=Microsoft Office
2003;WSID=KAUPCHE1-TX;DATABASE=Forecast;Trusted_Connection=Yes

 

The SQL statement I used is as follows:

ALTER Table dbo_Sharon_Ridge ADD COLUMN SR_CO2_Sep_ 05 DOUBLE

 

I get the following message when I try to run the query

ODBC - call failed

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'COLUMN'. (#156)

 

I can open the table fine from the table window.

 

What am I missing here. THANKS!

 

 

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 




More information about the AccessD mailing list