garthdonovan
asked on
Cold Fusion - dsn-less connection to SQL server database
is there a way of using a DSN-less connection with Cold Fusion MX to connect to a SQL database (located on a different server to CF)? I have seen the following code around, but it doesn't seem to work for CF MX...just generates an error that CONNECTSTRING is not supported.
<cfset Connection = "Provider=SQLOLEDB.1;Persi st Security Info=False;User ID=XXX;Password=XX;Initial Catalog=XXX;Data Source=IP ADDRESS;Network Library=DBMSSOCN">
<CFQUERY NAME="Test" DBTYPE="dynamic" CONNECTSTRING="#Connection #">
SELECT * from SomeTable
</CFQUERY>
<cfset Connection = "Provider=SQLOLEDB.1;Persi
<CFQUERY NAME="Test" DBTYPE="dynamic" CONNECTSTRING="#Connection
SELECT * from SomeTable
</CFQUERY>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Link:
http://www.geocities.com/empiricallyspeaking/index.html