Thanks Bill. -----Original Message----- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 12:36 To: CF-Talk Subject: RE: using CONNECT STRING with CFMX
The string should be: dsn=dsn;uid=uname;pwd=pword I've made the same mistake forgetting that it isn't "username" but "uid". ______________________________________________________ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com ______________________________________________________ > -----Original Message----- > From: John McCosker [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 28, 2003 6:10 AM > To: CF-Talk > Subject: using CONNECT STRING with CFMX > > > Hi, > > Could someone tell what would be the correct syntax to connect > to MSSQL using ODBC SOCKETS through the connect string. > > We are using MX 6.0 and MSSQL 7.0. > > The server docs shed little light on this, and having trouble > getting any > reasonable documentation on the MM website. > > Our IT guy here has been working with the server and everything going > through > ODBC is running very slow, except one ASP site which uses > connection string. > > He wants me to look into this for the time being. > > In coldfusion 5 I'm almost sure there was a connectstring > attribute of the > <cfquery tag>, > there is not with MX. > in MX admin the connect string option is there under the > advanced settings > for my DSN in datasources. > > I really just need to know the correct syntax and what do I > leave out in the > settings for this to take > effect, for instance do I leave USERNAME and PASSWORD blank. > > I tried this, > leaving them blank and in the connect string box, > > dsn=dsn;username=uname;pwd=pword; > > but I get this error, > > Connection verification failed for data source: leocate > []java.sql.SQLException: SQLException while attempting to connect: > java.sql.SQLException: [MERANT][SequeLink JDBC Driver][SequeLink > Server]Required user name is missing. > The root cause was that: java.sql.SQLException: SQLException while > attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC > Driver][SequeLink Server]Required user name is missing. > > Any help would be appreciated, > thanx, > > J > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
