ODBC Error 37000 Revisted

2001-04-10 Thread Robert Everland
Ok I found out what is causing the error. I am marking up a lot of data to insert as a client variable. Basically I am joining three queries in a structure then marking up the structure. When it is someone who only has a few customers to mark up, no error. Once I get to someone with

RE: ODBC Error 37000 Revisted

2001-04-10 Thread Bryan Love
: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 7:58 AM To: CF-Talk Subject: ODBC Error 37000 Revisted Ok I found out what is causing the error. I am marking up a lot of data to insert as a client variable. Basically I am joining three queries in a structure

RE: ODBC Error 37000 Revisted

2001-04-10 Thread Robert Everland
-Talk Subject: RE: ODBC Error 37000 Revisted Yes there are limits to client variables: 1. Cookie client vars = 4000 chars. 2. Registry client vars = ?? 2. Database client vars for ORACLE 8i using native drivers = 4000 chars 3. Database client vars for ORACLE 8i using ODBC drivers = 2000 chars 4

RE: ODBC Error 37000

2000-12-14 Thread Aaron Johnson
al Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 7:20 PM To: CF-Talk Subject: RE: ODBC Error 37000 Chris, Wow... This is going to sound strange When I first got that message, I went into the enterprise manager, and strangely a

RE: ODBC Error 37000 (anyone using SQL 7 SP2 - read!!!)

2000-12-14 Thread Al Musella, DPM
essage- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 7:20 PM To: CF-Talk Subject: RE: ODBC Error 37000 Chris, Wow... This is going to sound strange When I first got that message, I went into the enterprise manager, and strangely a

ODBC Error 37000

2000-12-13 Thread Al Musella, DPM
I have been getting this error message a lot lately.. I have no idea where the problem is. When it happens, I have been rebooting the cold fusion server and sql 7 server. Then it works for a while and then stops. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC

RE: ODBC Error 37000

2000-12-13 Thread Lomvardias, Christopher
: Wednesday, December 13, 2000 1:41 PM To: CF-Talk Subject: ODBC Error 37000 I have been getting this error message a lot lately.. I have no idea where the problem is. When it happens, I have been rebooting the cold fusion server and sql 7 server. Then it works for a while and then stops. ODBC