Hi, I'm using CF9 running on Solaris and I just had Oracle 11g installed using tnsnames. Can someone explain to me how to add the Oracle string in CF admin? I have confirmed that I can connect to the database but I don't think I have the correct syntax for connection string. I think it should be similar to the following: jdbc:datadirect:oracle:TNSNAMES_FILE=/d01/oracle/product/v.184.108.40.206_c lient/network/admin/tnsnames.ora:@dbserver.com:1549:SIDname;driver=ora cle.jdbc.Oracle
Does anyone have an idea?
Thanks in advance
For my installation, we had to have the Oracle client installed onto the web server (because the Oracle database was not co-located on the server). We also used the Oracle driver when setting up the datasource in the CF administrator.
I have Oracle client installed on the web server with Oracle database installed on separate server. When I add DSN and SID, I get the following error:
Connection verification failed for data source: dsn_test
java.sql.SQLNonTransientConnectionException:[Macromedia][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (SID_NAME) was not recognized by the Oracle server.
The root cause was that:java.sql.SQLNonTransientConnectionException:[Macromedia][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (SID_NAME) was not recognized by the Oracle server.
I just checked my Oracle client, and my tnsnames.ora file doesn't have the database defined in it (just have the example database it in).
I am running CF9 off of Windows, so I think we are talking apples and oranges, but I pulled this out of the neo-datasource.xml file (same formatas you showed above):
so try . . .