Re: Datasource creation errors
-now it will work ;-) Unfortunately not. Also there is no provision for testing Access DSNs in Windows ODBC (like there is for SQL). Perhaps I am missing something here? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Datasource creation errors
I'm having trouble creating Access and socket DSNs with the ColdFusion Administrator. The error message is: Connection verification failed for data source: DSN_NAME []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. Oddly, the sample DSNs, which use the ODBC socket driver also, work fine. Also SQL DSNs verify with no problem. I am using CFMX 6.1 and have upgraded to the 3.3 versions of the JDBC drivers. I have also uninstalled/reinstalled the CFMX ODBC Agent and Server, and installed Macromedia hotfixes hf53486_61.jar and hf53852_61.jar. I have been stuck on this for a while and am at a loss, all help appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Datasource creation errors
OK...here's what I've always had to do: -set up the DSN via Windows ODBC -set the DSN to use Windows Authentication -test it at the end -go into CF Admin -setup the datasource as you normally would -now it will work ;-) Ahhh...I long for the good old days wehn CF Admin did it all ;-) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Kathleen Cashel To: CF-Talk Sent: Friday, June 18, 2004 8:36 AM Subject: Datasource creation errors I'm having trouble creating Access and socket DSNs with the ColdFusion Administrator. The error message is: Connection verification failed for data source: DSN_NAME []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. Oddly, the sample DSNs, which use the ODBC socket driver also, work fine. Also SQL DSNs verify with no problem. I am using CFMX 6.1 and have upgraded to the 3.3 versions of the JDBC drivers. I have also uninstalled/reinstalled the CFMX ODBC Agent and Server, and installed Macromedia hotfixes hf53486_61.jar and hf53852_61.jar. I have been stuck on this for a while and am at a loss, all help appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Datasource creation errors
I'm having trouble creating Access and socket DSNs with the ColdFusion Administrator. The error message is: Connection verification failed for data source: DSN_NAME []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. The odd thing is that the sample DSNs, which use the ODBC socket driver also, work fine. But if I try to re-create them using the same settings (and the same system DSNs in the windows odbc admin), they give me this same error. SQL DSNs verify with no problem. I am using CFMX 6.1 and have upgraded to the 3.3 versions of the JDBC drivers. I have also uninstalled/reinstalled the CFMX ODBC Agent and Server. I am at a loss what to try next, all help appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Datasource creation errors
Just a shot in the dark, but did you try setting up the ODBC datasource in the ODBC administration panel (control panel administrator settings, I believe), rather than via the CFMX admin? Cheers, barneyb -Original Message- From: Kathleen Cashel [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 6:18 PM To: CF-Talk Subject: Datasource creation errors I'm having trouble creating Access and socket DSNs with the ColdFusion Administrator. The error message is: Connection verification failed for data source: DSN_NAME []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. The odd thing is that the sample DSNs, which use the ODBC socket driver also, work fine. But if I try to re-create them using the same settings (and the same system DSNs in the windows odbc admin), they give me this same error. SQL DSNs verify with no problem. I am using CFMX 6.1 and have upgraded to the 3.3 versions of the JDBC drivers. I have also uninstalled/reinstalled the CFMX ODBC Agent and Server. I am at a loss what to try next, all help appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Datasource creation errors
Access DSNs seem to set up fine via control panel administrative tools data sources (odbc). But since it's MX they do not then show up in CFMX admin, and are not accessible to my CF apps. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
