Hi Kevin/Giz/Peter,
I'm experiencing something pretty weird. Actually i have created a database
together with the cdata and cglobal manually. It works perfectly fine when i
do some tests locally, that is, the tests are performed on my machine
whereby i have a personal edition of coldfusion server (4.5.1) and with the
database residing on the server (oracle 8.0.6).
Well, but now when i put the files - cfm files - on the server to enable my
colleagues to perform the test from their PC and on the Server itself, the
cold fusion server prompts me the error.
In fact, there is nothing wrong with the database since it worked when i've
done the tests locally.I just can't get the point... have any idea?
Error:
----------------------------------------------------------------------------
--------------------------------------------
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
[Oracle][ODBC][Ora]ORA-01008: not all variables bound
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the fields
included in your query exist and that you have specified their names
correctly.
Date/Time: 05/18/01 11:35:18
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
----------------------------------------------------------------------------
--------------------------------------------
-----Original Message-----
From: Giz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 4:20 PM
To: Fusebox
Subject: RE: Creating client variables / oracle 8.06
Actually sounds more to me like a client library/server mismatch issue.
Best thing to do is make sure that all the software is fully patched to the
latest available patch levels.
-----Original Message-----
From: Kevin Bridges [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 7:16 AM
To: Fusebox
Subject: RE: Creating client variables / oracle 8.06
Sounds like your problem resides in "cold fusion not recognize the database
format". Make sure your setting the datasource up properly by selecting
Native Drivers and "Oracle80" and that your datasource verifies. I'm no
Oracle dba but that would be my first guess
-----Original Message-----
From: Sneid [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 12:23 AM
To: Fusebox
Subject: Creating client variables / oracle 8.06
Hi Everybody,
I have some problems while trying to store client variables in my database -
Oracle 8.06. In fact, i have created the CDATA and CGLOBAL tables manually
since coldfusion server does not recognize the database format. Has anyone
experience such problem?
Here is the error message:
----------------------------------------------------------------------------
---------------------------------------------
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
[Oracle][ODBC][Ora]ORA-01008: not all variables bound
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the fields
included in your query exist and that you have specified their names
correctly.
Date/Time: 05/16/01 10:14:21
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
----------------------------------------------------------------------------
---------------------------------------------
Thanks,
Sneid
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
