Skip to main content
F
Frosina.Zarezankova
Participant
January 3, 2020
Question

Adobe Cold Fusion 2018 Standard license - Cannot make connection to the database with ODBC Socket

  • January 3, 2020
  • 2 replies
  • 929 views

Cannot make ODBC Socket connection, getting this error:

 

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined

 

I used Developer installation before I purchased the ColdFuison 2018 Standard License and I was using Oracle as a Driver and was able to connect to the database. Once I applied the license (serial number), the Oracle connection was not working anymore and I tried to use ODBC Socket and still cannot connect, the error from above occurred. 

Additional Information: Cold Fusion is installed on Windows Server 2016. I have set up the ODBC connection and it's connecting to the database without errors.

This topic has been closed for replies.

2 replies

EddieLotter
EddieLotter
Inspiring
January 3, 2020

Where are you seeing this error? In the CF Administrator or in a CFM?

If the latter, then you appear to be using a non-existent datasource. In other words, you created and successfully tested a DSN called "A" in the CF Administrator, but in your application you are trying to use a DSN called "B".

Notice that the error message doesn't say the DSN is failing, it's saying that the DSN you are trying to use is not defined in the CF Administrator.

D
Community Expert
Dave WattsCommunity Expert
Community Expert
January 3, 2020

CF Developer and Enterprise editions come with their own Oracle driver, provided by DataDirect. That's not available in Standard Edition. Instead, you should download Oracle's own JDBC driver, and set it up as "Other" in CF. There are instructions in the CF docs for how to do this.

 

The ODBC driver is likely to be problematic in most cases, and I would not recommend using it.

 

Dave Watts, Eidolon LLC

Dave Watts, Eidolon LLC
F
Frosina.ZarezankovaAuthor
Participant
January 3, 2020

Hi Dave,

 

Thank you  for your very quick response.

Is this link to the CF document how to set up "Other" connection

https://helpx.adobe.com/coldfusion/configuring-administering/data-source-management-for-coldfusion.html#Connectingtootherdatasources

Or there is another documentation that I can use?

 

thanks

Frosina

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices