Re: Help with first connection to ODBC SQL datasource

On Sunday 20 Jul 2003 03:05 am, Terry Troxel wrote: cfquery name=getdata datasource=formsSQL dbtype=ODBC debug dbserver=DEVELOPER select * from cthru /cfquery which returned the following error: ODBC Error Code =

Help with first connection to ODBC SQL datasource

I just migrated/imports my first Access database to my new SQL2000 server named DEVELOPER. I added a datasource in CF Administrator called formsSQL. Checked off used trusted connection and the administrator said OK to the Verify. I went in and tried to do a simple cfquery which works in the

Re: Help with first connection to ODBC SQL datasource

: cfquery name=getdata datasource=formsSQL select * from cthru /cfquery Bruce Sorge From: Terry Troxel [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Help with first connection to ODBC SQL datasource Date: Sat, 19 Jul 2003 19:05:06 -0700 I