Ask a Question related to Coldfusion Database Access, Design and Development.
-
csw11235 #1
ODBC datasource not working
I'm running ColdFusionMX7 and I'm trying to set up an ODBC connection.
I've manually installed some new ODBC drivers on the server, and I've set up
the machine ODBC connection (which works fine from that machine - tnsping is OK
and the TestConnection is OK, so I know both that the target DB is findable and
I'm using a valid username and password).
When I try to use that ODBC connection I get the error:
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error
Any suggestions on what's wrong and how to fix it? Thanks!
csw11235 Guest
-
Query on ODBC datasource
How do I create an ODBC driver for an access database located on a remote server without using CFadmin -
ODBC datasource with Windows XP, SP2
I am trying to connect an ODBC data source to my coldfusion mx7. I have been successful using Windows XP SP1 on another computer, but when I try ... -
unable to verify ODBC socket datasource
In the CF Admin, I am trying to create an ODBC Socket datasource to a System datasource that is pointing to an Excel file. I receive the following... -
CF5: Oracle 8i ODBC datasource works, 9i doesn't.
Hey folks. I have a CF5 box that has the Oracle 8i client on it. I created an Oracle "net service name" to our Oracle 9i database server using the... -
Cannot create a ODBC Socket Datasource
Hello I cannot create a ODBC Socket datasource. I get a message " The ColdFusion MX 7 ODBC Server service is not running or has not been... -
alagukannan #2 Re: ODBC datasource not working
Did you Create the datasource from the Administration page of Coldfusion..?or from Windows ODBC..
Your New drivers should be available there.
thx
AL
alagukannan Guest
-
Kronin555 #3 Re: ODBC datasource not working
I highly suggest using JDBC. ODBC has issues, especially with dealing with long strings and BLOBs/CLOBs. Also, when using ODBC, you're going through one more step (which is an ODBC/JDBC bridge).
Kronin555 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
