The "Class Path" for the driver is set on "Java and JVM" page in Administrator. Choosing "other" for driver in "Data Sources" and using the JDBC driver, produces this:
Connection verification failed for data source: NorthWind []java.sql.SQLException: No suitable driver available for NorthWind, please check the driver setting in resources file, error: com.microsoft.jdbc.SQLServerDriver The root cause was that: java.sql.SQLException: No suitable driver available for NorthWind, please check the driver setting in resources file, error: com.microsoft.jdbc.SQLServerDriver ----- SQL Server driver produces this: Connection verification failed for data source: NorthWind []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. same error above for an Administrator as a user too. Thanks, Joe Kelly ----- Original Message ----- From: "S.Isaac Dealey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 07, 2004 11:11 PM Subject: Re: SQL Server connection > I use the SQL Server Driver ... although I've had problems with them > in the past... They seem to have had more problems with JDBC drivers > than with almost anything else since moving to J2EE from CF5. The ODBC > Socket, while it works, isn't very desirable because even on the Sun > website they say that the ODBC Socket drivers are a "workaround" and > shouldn't be used except as a last resort. Iirc the ODBC Socket also > doesn't allow you to use some of the metadata features of JDBC (which > are included in the onTap framework). > > Though lately I've been able to get the JDBC drivers that came with > Red Sky to work fine. > > What kind of issues are you having with the JDBC drivers for SQL > Server anyhow? > > > > In CF Administrator > Data Sources > > Does anybody use the "Microsoft SQL Server" driver? > > I can't connect w/ this driver. I have to set up an ODBC > > connection the SQL Server db and then use the "ODBC > > Socket" driver. All the tech notes say to use this > > workaround. Any ideas? This doesn't seem very efficient > > to me. > > > Here's what I'm running all on the same box: > > cfmx 6.1 > > windows 2000 adv server > > MS SQL Server 2000 > > SQL Server 2000 Driver for JDBC Service Pack 2 > > > Thanks, > > Joe Kelly > > > > s. isaac dealey 214.823.9345 > > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > http://www.turnkey.to/ontap > > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > Send UNSUBSCRIBE to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org > ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
