The dropdown SQL Server is the native (OEM'ed Merant) java driver for MSSQL -- the ODBC Socket choice is the JDBC/ODBC bridge.
Of course, using JDBC/ODBC bridge means you can test using ODBC :) You need a JDBC app to test JDBC connectivity. Hey -- as an side, when you say the ODBC connection work, are you simply using the "Test Datasource" in the MSSQL ODBC setup? I don't remember all the details, but it's not a complete test -- it's more like a ping (yes, there's a sql server there) than a real test (yes, login is successful). Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 12:50 PM Subject: RE: HELP!!!! jrun-resources.xml > where does this TYPE IV driver come from where can I get it? > or is it just the sql server driver that comes in the drop down? > > thanks > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -----Original Message----- > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 12:46 PM > To: CF-Talk > Subject: Re: HELP!!!! jrun-resources.xml > > > I second Joachem -- use the Type IV driver -- not the ODBC/JDBC bridge. > But > that aside, if you're getting trusted server errors, it's all about > permissions. Try sharing a drive using the sql admin account (domain > admin > is optimal) from the cfmx box to the sql server. That should create a > trusted connection. > > I'd check to make sure that all the relevant services are still running > as > you originally had them -- that if you ran CF and SQL as named users, > that > the scripts on install didn't flip them back to LocalSystem for some > crazy > reason. > > Another thing you could check -- log onto the CFMX box as the account > you're > using to connect to SQLServer (assuming NTauth) or running the SQL > Server > service as (assuming standard auth) and make sure you can validate > against > the domain. Not a likely thing to have changed, but I've seen weirder. > > Regards, > > John Paul Ashenfelter > CTO/Transitionpoint > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, January 13, 2003 12:26 PM > Subject: RE: HELP!!!! jrun-resources.xml > > > > on the server that is running my cfmx, I can make > > an odbc connection from windows to the other server > > that is running the sql server, test the datasource > > and all is well. the sql server is setup for mixed mode > > auth, and I am using a user/pass that I have and can > > verify. > > > > Connection verification failed for data source: Platypus > > []java.sql.SQLException: SQLException occurred in JDBCPool while > > attempting to connect: java.sql.SQLException: [Macromedia][SQLServer > > JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: > > Not associated with a trusted SQL Server connection.. > > The root cause was that: java.sql.SQLException: SQLException occurred > in > > JDBCPool while attempting to connect: java.sql.SQLException: > > [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user > > 'platypus_admin'. Reason: Not associated with a trusted SQL Server > > connection.. > > > > is now the error I am getting....some trusted server bs, > > that wasn't there just 12 hours ago before we made the > > changes!!!!!!!!!!!!!! > > > > so its like, nothing make sense. the cfmx server connects to other > > db's, the only diff is that the other sql servers are sql2000 not sql7 > > and of course, that they are on different machines. what in the heck > > could this possibly be? this is really making no effing sense!!!!!! > > > > oh, and no matter what dsn or datasource or user/pass combo I try > > nothing to that machine comes out ok, I get the same error regardless > > of the datasource name, etc...i have tried this from 2 production > > servers > > and 2 development machines, all to no avail....and the same error, the > 2 > > dev > > servers have cfmx updater 2, the production servers have cfmx updater > 1, > > so its > > not that either. > > > > any ideas? > > > > ...tony > > > > Tony Weeg > > Senior Web Developer > > UnCertified Advanced ColdFusion Developer > > Information System Design > > Navtrak, Inc. > > Mobile workforce monitoring, mapping & reporting > > www.navtrak.net > > 410.548.2337 > > > > -----Original Message----- > > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 13, 2003 12:14 PM > > To: CF-Talk > > Subject: Re: HELP!!!! jrun-resources.xml > > > > > > Are you using NTAuth or SQL auth to get in? > > > > As a quick test, create a datasource that uses the sa -- that verifies > > that > > SQL Auth is working correctly and the db is accessible. Then try > > connecting > > using NTAuth with whatever account you personally use to connect to > the > > database (through things like Enterprise Manager or Query Analyzer). > > > > That login "\" usually means something is messed up with NTAuth. > > > > Another quick check, you can do an admin-level share between the web > > server > > to the sql box using an account with sql permissions -- that will > handle > > a > > bad set of credentials. > > > > Note that none of these are long-term solutions -- just ways to > > check/address the connectivity -- you want to isolate problem and of > > course > > fix it -- leaving CF connecting as SA can be bad news! > > > > Regards, > > > > John Paul Ashenfelter > > CTO/Transitionpoint > > [EMAIL PROTECTED] > > ----- Original Message ----- > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, January 13, 2003 11:58 AM > > Subject: RE: HELP!!!! jrun-resources.xml > > > > > > > in my odbc connection, system dsn that I am setting up through > windows > > > I am using my correct login info, not "\" as the username....WTF!!!! > > > > > > ...tony > > > > > > Tony Weeg > > > Senior Web Developer > > > UnCertified Advanced ColdFusion Developer > > > Information System Design > > > Navtrak, Inc. > > > Mobile workforce monitoring, mapping & reporting > > > www.navtrak.net > > > 410.548.2337 > > > > > > -----Original Message----- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 13, 2003 11:56 AM > > > To: CF-Talk > > > Subject: RE: HELP!!!! jrun-resources.xml > > > > > > > > > excellent jochem, now here is what I get.... > > > > > > > > > Connection verification failed for data source: Platypus > > > []java.sql.SQLException: SQLException occurred in JDBCPool while > > > attempting to connect: java.sql.SQLException: [MERANT][SequeLink > JDBC > > > Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL > > Server]Login > > > failed for user '\'.. > > > The root cause was that: java.sql.SQLException: SQLException > occurred > > in > > > JDBCPool while attempting to connect: java.sql.SQLException: > > > [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL > > Server > > > Driver][SQL Server]Login failed for user '\'.. > > > > > > ...tony > > > > > > Tony Weeg > > > Senior Web Developer > > > UnCertified Advanced ColdFusion Developer > > > Information System Design > > > Navtrak, Inc. > > > Mobile workforce monitoring, mapping & reporting > > > www.navtrak.net > > > 410.548.2337 > > > > > > -----Original Message----- > > > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 13, 2003 11:48 AM > > > To: CF-Talk > > > Subject: Re: HELP!!!! jrun-resources.xml > > > > > > > > > Tony Weeg wrote: > > > > thanks dina, but this is now what im getting.... > > > > > > > > Connection verification failed for data source: platypus > > > > []java.sql.SQLException: SQLException occurred in JDBCPool while > > > > attempting to connect, please check your username, password, URL, > > and > > > > other connectivity info. > > > > The root cause was that: java.sql.SQLException: SQLException > > occurred > > > in > > > > JDBCPool while attempting to connect, please check your username, > > > > password, URL, and other connectivity info. > > > > > > http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full > > > > > > And if you get a 'cannot establish socket' error use telnet to > verify > > > the SQL server is actually listening. > > > > > > Jochem > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
