Thanks I have just tried what you said and run the following query as
you said which brought back the error shown below,
Does that look like a driver problem to you ? or could it be permissions
on the DB ? which i dont think it is as it worked OK when using CF 4.5
There is something like MX does not like ????
<cfquery name="recordset_pay_details" datasource="NEWSELIMA">
SELECT EmployeeNumber FROM SQL_PERS_DATA
</cfquery>
Ian
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC
Socket][VMARK][UVODBC][1401030]Error ID: 39 Severity: ERROR Facility:
DBCAPERR - Serialization failure.
The error occurred in F:\Websites\Intranet\testsel.cfm: line 7
5 : <title>Untitled</title>
6 :
7 : <cfquery name="recordset_pay_details" datasource="NEWSELIMA">
8 : SELECT EmployeeNumber FROM SQL_PERS_DATA
9 : </cfquery>
-----Original Message-----
From: Christian Cantrell [mailto:[EMAIL PROTECTED]
Sent: 05 February 2004 15:47
To: CF-Talk
Subject: Re: What could be wrong with this code ? Any expertise
on this please??
Can you verify that all queries fail as opposed to just this
one? For
instance, can you run a simple query like this?
SELECT * FROM SQL_PERS_DATA
Should we be focusing on your query syntax, or should we be
looking at
a potential driver problem?
Christian
On Feb 4, 2004, at 10:49 AM, Ian Vaughan wrote:
> I have set up a connection to an IBM universe database
through Windows
> Administrative Tools > ODBC Datasource Administrator, this
pings and
> tests correctly...
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
