Kaup, Chester
Chester_Kaup at kindermorgan.com
Mon Sep 26 09:53:34 CDT 2005
Thanks for the help. That got the query to work. I should have checked into SQL server data types. That's what happens when engineers put me outside my comfort zone. Now another question if I may. Is there a way to tell if a SQL server or Oracle link is to a table or a view? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James Barash Sent: Monday, September 26, 2005 9:44 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pass Trough Query to SQL Server There is no data type DOUBLE in SQL Server. Try changing that to float. James Barash -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Monday, September 26, 2005 10:28 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Pass Trough Query to SQL Server You are correct I don't need the word COLUMN. Also found an error with a space before 05. Took out the space. Now get an error of incorrect syntax near ;. Removed the ; and get a message of incorrect syntax near DOUBLE. Persistence will prevail. Thanks. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Monday, September 26, 2005 9:17 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pass Trough Query to SQL Server It's possible that you don't need the keyword COLUMN but why don't you try running the statement in Query Analyzer and see what kind of error you get -- might be a more helpful message. Just a thought. Susan H. 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) -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com