Ask a Question related to Coldfusion Database Access, Design and Development.
-
Tom Stuart 2 #1
ODBC Syntax
Can you provide a pointer/link to a definition of valid SQL syntax for the SQL
Server ODBC Driver?
Right now a real life-saver would be a list of differences between the Access
ODBC driver and the SQL Server ODBC driver.
Tom Stuart 2 Guest
-
[microsoft][odbc microsoft access driver] syntax error (missing operator) in query expression error
I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when... -
ODBC Socket doesn't show my list of ODBC DSN's!?!
In the ColdFusion MX 7 Administrator, when I try to create a new datasource of type ?ODBC Socket?, the drop down labled ?ODBC DSN? that is supposed... -
[ODBC] ODBC (win32) X PostgreSQL(Linux)
Hi Fabricio, fbbsantos wrote: I need to know enough that if I sat down at your computer I could find the problem. For example, what... -
#24697 [Fbk->NoF]: odbc can not return accurate result when we handle excel file use odbc
ID: 24697 Updated by: sniper@php.net Reported By: tty3000 at hotmail dot com -Status: Feedback +Status: ... -
#24697 [NEW]: odbc can not return accurate result when we handle excel file use odbc
From: tty3000 at hotmail dot com Operating system: win 2000 PHP version: 4.3.2 PHP Bug Type: ODBC related Bug description: ... -
Abinidi #2 Re: ODBC Syntax
huh?
SQL is SQL, I don't think there is a SQL snytax for the driver itself. The
driver is server side and is used to pass your query back and forth from the db
and CF.
Are you wanting to know the difference between coding for Access and SQL?
BTW, you dont want to use Access in a production site either.
Abinidi Guest
-
-
paross1 #4 Re: ODBC Syntax
Download and install the
[url]http://www.microsoft.com/downloads/details.aspx?familyid=BE6A2C5D-00DF-4220-B133[/url]
-29C1E0B6585F&displaylang=en. It will give you everything that you want to know
about SQL syntax for SQL Server. You should already have that for Access if you
are already using that.
Phil
paross1 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
