Skip to main content
A
Anonymous
February 12, 2008
Question

Oracle DB connectivity

  • February 12, 2008
  • 2 replies
  • 478 views
I installed Oracle 9i server and CFML 7.0 server on a machine.
Created DSN. When i tried to add a datasource using Administrator page i am receiving the following error:

Connection verification failed for data source: dn
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Please tell me if i need to install any other plug ins.

Your help is appreciated.

Thanks and Regards,
Ghali.Sriparthu
This topic has been closed for replies.

2 replies

N
Nick_B2
Inspiring
February 20, 2008
sorry 4 & 5 are the wrong way round.
N
Nick_B2
Inspiring
February 20, 2008
I've just had similar... this is what worked for me... it might not always be the case though.

1. Delete Coldfusion DSN
2. Delete ODBC DSN
3. Restart CF ODBC Server and Agent Services
4. Re-add Coldfusion DSN
5. Re-Add ODBC DSN

Hope this works for you.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices