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]

Reply via email to