Oh yea, that was the one I forgot -- afaik you pretty much have to use sql server authentication mode (not windows and I _think_ not mixed mode) to get the standard JDBC drivers to work. DB drivers are always such a pain. :)
> Thanks Matt! > Set SQL Server to mixed authentication, > used "sa" as username in CF Admin DSN, > and that which did not work before, does now! > Still can't get the JDBC option to work, but the issue is > moot now. > Good check list! Thanks for the help Matt & Isaac! > Take notes fellow MS SQL Server Admin rookies! > Joe Kelly > ----- Original Message ----- > From: "Matthew Woodward" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, March 08, 2004 7:38 AM > Subject: Re: SQL Server connection >> Hopefully I'm not restating things you've already tried, >> but here are some >> things to check: >> >> 1. Make sure SQL Server is set to use either SQL Server >> authentication > only >> or mixed authentication >> >> 2. They fixed this in 6.1, but in 6.0 there was an issue >> with password >> length--I think the limit is 16 characters. The >> administrator would let > you >> enter a password longer than 16 characters but it would >> truncate it and > not >> tell you, so if your password was longer than 16 >> characters it would just >> create a login failure with no other explanation. >> >> 3. Make sure your ports are correct. If you use >> instances in SQL Server >> 2000, SQL Server more or less randomly assigns ports for >> instances other >> than the default instance. >> >> 4. If you have the SQL Server driver still in its jar >> file, make sure the >> full path to the jar file *including the name of the jar >> file itself* > (e.g. >> "X:\path\to\jar\mssqlserver.jar") is in your classpath. >> Just putting the >> name of the directory in which the jar file resides won't >> cut it. >> >> 5. There are multiple jar files distributed with the SQL >> Server JDBC > driver >> (3 to be exact). Make sure they are all in your >> classpath as indicated >> above. >> >> 6. Try creating another database and explicitly setting a >> user name and >> password; then at least you'll know if there's just >> something messed up > with >> your Northwind database if another database works. >> >> HTH, >> Matt >> >> ------------------------- >> Matthew P. Woodward >> [EMAIL PROTECTED] >> >> ----Original Message Follows---- >> From: "Joe Kelly" <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> To: <[EMAIL PROTECTED]> >> Subject: Re: SQL Server connection >> Date: Sun, 7 Mar 2004 23:34:11 -0600 >> >> 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 >> >> _________________________________________________________ >> ________ >> Create a Job Alert on MSN Careers and enter for a chance >> to win $1000! >> > http://msn.careerbuilder.com/promo/kaday.htm?siteid=CBMSN_ > 1K&sc_extcmp=JS_JA > Sweep_MSNHotm2 >> >> ----------------------------------------------- >> 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 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
