tracker issue : CF-4199730

select a category, or use search below
(searches all categories and all time range)
Title:

ODBC Datasource is not found - Missing entry in swandm.ini

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Jürgen Wittsiepe / Jürgen Wittsiepe ()

Created: 09/18/2017

Components: Database, ODBC

Versions: 2016

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2016.0.05.303689 /

Priority/Frequency: Normal / All users will encounter

Locale/System: / Win 2012 Server x64

Vote Count: 0

Problem Description: I configured a 64-bit ODBC datasource. When I try to add this to the Coldfusion datasources I receive the error: 

Connection verification failed for data source: test
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.

Steps to Reproduce: Try to add a ODBC datasource

Actual Result: Datasource is not defined.

Expected Result: Datasource should be defined

Any Workarounds: I found that the required entry in the file ColdFusion2016\cfusion\db\slserver54\cfg\swandm.ini is missing.
I added this to swandm.ini:

Type=6
DataSourceLogonMethod=DBMSLogon(UID,PWD)
DataSourceProviderTypesFile=E\www-server\ColdFusion2016\cfusion\db\slserver54\bin\swsoc.ini
ServiceName=ColdFusion 2016 ODBC Server
DataSourceName=test
DataSourceSOCODBCConnStr=dsn=test
DataSourceFetchTimeStampAsString=0

Attachments:

Comments:

Hi Jürgen, I am unable to repro this issue. I am able to configure 64.bit data source with ODBC Socket. Are you on the latest CF 2016 update? Did you make sure both ODBC Server and ODBC Agent services are running?
Comment by Nimit S.
322 | September 22, 2017 12:16:48 PM GMT
Yes, ODBC Server and ODBC Agent services are running. I have two machines with CF 2016.0.05.303689. Only one machine shows this behaviour.
Comment by Jürgen W.
323 | September 22, 2017 12:26:47 PM GMT
Thanks Jürgen for replying back. Which ODBC Data Sources(64Bit) or (32Bit) utility did you use to register the data source?
Comment by Nimit S.
324 | September 22, 2017 06:40:44 PM GMT
Hi Jürgen, Can you please provide the information asked in the previous comment?
Comment by Nimit S.
325 | September 26, 2017 09:58:37 AM GMT
Hello Jürgen, Did you get a chance to look into this? Can you please provide the required information?
Comment by Nimit S.
326 | October 06, 2017 10:32:55 AM GMT
I tried both, but at least I used 64bit. And they were shown in the CF Administrator (I could select them).
Comment by Jürgen W.
327 | October 06, 2017 12:23:02 PM GMT
Hi Jürgen, Are you still facing this issue? Is it possible to come on a call and help me in troubleshooting this issue? -Nimit
Comment by Nimit S.
29585 | August 22, 2018 04:12:56 AM GMT
At the moment I am not facing the issue. Best, Jürgen
Comment by Jürgen W.
29602 | August 22, 2018 01:49:17 PM GMT
Thanks Jürgen for confirming this. I am closing this bug for now. Please do let us know if you face this issue in future. We will re-open this bug for further investigation. -Nimit
Comment by Nimit S.
29603 | August 22, 2018 02:10:53 PM GMT