I just recently converted a shared site at an ISP from CF5 to CFMX. With CF5 I used a DSN-less connection string to connect to a SQL2000 shared db. Now, as I know, CFMX won't accept DSN-less strings. Problem is, I don't know how to plug in the parameters into a CFQUERY. Specifically, where do I put the network connection string that the ISP supplies? I notice that since its left off in my CFMX query statements, performance in doing a query is extremely slow (because the query is looking all over the network for my db). The DSN string supplied to me to use is as follows:
"dsn=abcd;uid=myUserID;pwd=myPassword;network=dbmssql" Here's my <cfquery> statement: <cfquery name="qProduct" datasource="abcd" username="myUserID" password="myPassword"> This works, albeit slow. So what setting do I use to point to the network? There's so many Cfquery parameters that are deprecated in CFMX I'm at a loss of what to do. Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
