What version of CF are you using? Generally speaking OLEDB isn't used with the recent versions... I'm not sure if it's strictly unavailable (it wouldn't surprise me) but generally speaking with CF6 and later JDBC replaces OLEDB (or maybe ODBC via the ODBC Socket driver which uses JDBC anyway, but doesn't talk properly, so you may as well use JDBC drivers). So unless you're using CF5 you shouldn't need the dbtype or providerdsn attributes. If you're using CF5 then the providerdsn argument seems odd to me... I don't remember for certain, but I don't recall the provider or providerdsn arguments being ip addresses -- iirc they were strings like "com.oledb.blah" -- C++ class paths I think, although I never got that deep with C+... The IP address would be in your DSN settings in the CF admin unless you're creating a DSN-less connection using the connectString argument.
That's all I got. :) > 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 s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234156 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
