Ask a Question related to Coldfusion Database Access, Design and Development.
-
VaHokie #1
Oracle DSN Error
We've recently changed our Oracle cluster. When we tried to change the ODBC
URL connection string in CF we get the following error:
Connection verification failed for data source: DB1
[]java.sql.SQLException: Io exception: Connection
refused(DESCRIPTION=(ERR=1153)(VSNNUM=153093376)(E RROR_STACK=(ERROR=(CODE=1153)(
EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=<server _name>)(PORT=1521))'))(ERROR=(
CODE=305)(EMFI=1))))
The root cause was that: java.sql.SQLException: Io exception: Connection
refused(DESCRIPTION=(ERR=1153)(VSNNUM=153093376)(E RROR_STACK=(ERROR=(CODE=1153)(
EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=<server _name>)(PORT=1521))'))(ERROR=(
CODE=305)(EMFI=1))))
What's interesting is that the port has been changed to 1625, so I have no
idea where it's getting 1521 as the Port. I checked for trailing spaces and
made sure the service name didn't contain any periods. The tnsnames.ora file
has the correct entries. Any help is appreciated.
VaHokie Guest
-
CFMX6.1,7 - Oracle 10G R2 Error
Hi Guys, need your expertise and help for this. Currently we are using CFMX 6.1 on my local machine and CFMX7 on server(win2003) both connect to... -
Oracle error=917 when trying to insert into database
I get the following error when I try to insert into table - Oracle Error Code = 917 ORA-00917: missing comma SQL = "INSERT INTO... -
odbc, oracle --> error "internal error occured"
hi everyone, i'm using cf mx 7 standard and want to connect to an oracle-db via odbc, beause it's not possible directly via oracle-driver, isn't... -
#13053 [Com]: oci8 error, this kill oracle-prosseces in the oracle-instance.
ID: 13053 Comment by: gid at gifpaste dot net Reported By: jsun at basefarm dot no Status: Bogus Bug Type: ... -
Error while connecting to Oracle
I have an .asp file where in I make a simple SELECT query to an Oracle table. But I'm getting error as follows. Microsoft OLE DB Provider for...



Reply With Quote

