I don't know if this is the issue, but if your DSN is correctly configured in the administrator, you shouldn't need the username, pass, or IP of the server. Also, as of CF6(?) dbtype is defunct except for query of query.
--Ben Jim Louis wrote: > Hello > > I am using MS SQL for the first time and I am trying to get the query right > > This is what I have > > <CFSET request.lcDatasource = "LC_KCALA"> > <CFSET request.Username = "*****"> > <CFSET request.Password = "****"> > <CFSET REQUEST.dbLoc = "10.0.0.1"> > > <cfquery name="qryActiveFeatures" datasource="#request.lcDatasource#" > username="#request.Username#" password="#request.Password#" dbtype="OLEDB" > providerdsn="#REQUEST.dbLoc#"> > SELECT LC_FEATURE_PATH FROM LC_FEATURE WHERE IS_ACTIVE = 1 AND AVAILABLE = > 1 > </cfquery> > > What am I missing? > > Jim Louis > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234155 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
