ODBC socket query error

[tsgtuser]

I have an ODBC socket connection with a database. The DSN says the connection
is OK. I created a simple query in the create a recordset window. When I
test the query the response I get is an error -1[Macromedia][SequeLink JDBC
Driver][ODBC Socket] [OSI][PI-ODBC][PI]Invalid string or buffer length. Does
anyone know what could be a solution to the error? thanks in advance.

[dphillipsCFX]

Did you setup the DSN using the ODBC manager or the ColdFusion Administrator?

Can you please tell us what version of CF and OS you are using?


Dan Phillips
CFXHosting.com

[tsgtuser]

I am using dreamweavermx 2004 on a window XP. Cold fusion mx version 7,0,0,91690 is on a windows 2003 server.

[dphillipsCFX]

Could you post your code please? That may be the problem.

[tsgtuser]

the query I am trying to run is SELECT MAX(value)
FROM picomp
WHERE (tag='REAL_TIME_LD_AUX.MV') . I have run the query in MS Query, and it
works. I have ODBC tracing on and the msquery shows results in the log files,
but the query through dreamweaver does not show up in the log files. Is there
a way to see the query being passed, or is there a way to pass a query through
odbc from dreamweaver or coldfusion?

[scurlo9ck]

I am getting the same error message. I am attempting to convert my application from 5.0 to MX.

[mxstu]

What is the data type of the field you are using MAX() on? Do you get the same error if you try another aggregate function like SUM(), AVG(), MIN()?

[scurlo9ck]

I don't use any aggregate functions, yet, I'm experiencing the same issue. My
ColdFusion and Oracle procedures work in Windows 2000/ColdFusion 5.0, but it is
not working in Windows XP/CF MX. Could it be the CFPROCPARAM CFSQLTYPE? I
have tried defining it as CF_SQL_CHAR, CF_SQL_LONGVARCHAR, and CF_SQL_VARCHAR
yet I get the same error.

[tsgtuser]

The matter if the query uses an aggregate function does not make a difference.
I can run a query like Select tag from picomp where tag = 'REAL_TIME_LD_AUX.MV'
and time = DATE('*') and still get the same error.

[mxstu]

What driver/version are you using? Did you check the knowledgebase for known
issues related to your current driver?

Can you run any query without an error? I mean something very simple like
'Select myIntColumn From myTable'?

[tsgtuser]

I am using a driver by the software manufacturer, OSI Software, Inc. PI-ODBC Version 1.02.00.00. I cannot run any queries without getting the error.

[tsgtuser]

Its a hierarchaical database that uses ansi compliant sql.

[mxstu]

No, I meant the driver.

[tsgtuser]

I used the incorrect Macromedia DSN driver. The correct driver for the DSN
needed to be installed according to the Macromedia technote
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=2d2a7a19[/url]

[mxstu]

I hadn't heard of that driver. Thanks for posting a follow-up.

[TTUChemE]

I was experiencing the exact same problem with accessing data from the PI/OSI
software proprietary database (invalid string or buffer length error). The
solution described by tsgtuser on 10/12/2005 was to use a different DSN driver.
I tried this solution and it did eliminate the invalid string error. However, I
now get an "undefined value... null pointer" error for some of my queries to
the PI database (all these queries worked fine with Cold Fusion 5; now, I'm
using CF MX 6.1). The undefined value error seems to be related to retrieving
float or integer data types from the PI database (queries only returning string
values appear to work OK). tsgtuser, have you had any similar experiences, or
has the new driver eliminated all of your PI related errors?