Ask a Question related to Coldfusion Database Access, Design and Development.
-
jsantelli #1
Oracle ODBC Socket MX7 Standard Issues ORA-06502
We have an issue where a stored procedure works fine in MX 6.1 standard but
does nto work in MX 7 Updater 2 standard. Everything is set up the same. We are
using ODBC Socket to make the connection to an Oracle 9 database. The
connection verifies in ColdFusion datasources, and I can return data that is
not coming back from a reference cursor. Whenever I try and retrieve data from
a reference cursor, I receive ORA-06502: PL/SQL: numeric or value error:
character string buffer too small ORA-06512...PL/SQL: numeric or value error:
character string buffer too small ORA-06512: at line 1.This is not an issue
with the stored procedure. It works fine in MX 6.1 and CF 5. It also works fine
if I call it from an ASP application and returns the data. I have updated the
drivers from 3.3 to 3.5 as well as the sequelLink. Appearently, the updater 2
didn't update these so I did it manually and verified the versions.
Does anyone have any recommendations aside from buying the Enterprise version?
I have tested the native drivers in the Enterprise version and they work
without any problems. I want to be able to get the socket connection working.
Thanks!
jsantelli Guest
-
Socket ODBC error
After I submit the ODBC socket, then I got error message saying "Unable to update the ColdFusion MX 7 ODBC Server. Timeout period expired without... -
ODBC Socket
Our system is on Sun Solaris and we need away to read in excel spreadsheet and parse its data into Oracle database. I saw one support article... -
ODBC Socket ERROR
I have a a sql 6.5 that i connect to using odbc sockets on CF 7. It worked fine on my dev machine, but when i installed cf 7 on my production box... -
ODBC Socket doesn't show my list of ODBC DSN's!?!
In the ColdFusion MX 7 Administrator, when I try to create a new datasource of type ?ODBC Socket?, the drop down labled ?ODBC DSN? that is supposed... -
2003 Server - load balancing ODBC and Oracle client issues
Hi all, I have 4 servers running Windows 2003 Server Standard and IIS 6. We are using them as web servers. They are all load balanced together.... -



Reply With Quote

