The administrator setup is similar to the setup for an ODBC datasource; the
main difference is you must type in "SQLOLEDB" in the provider field...other
than that, setting your server & database names as well as username and
password are the same.
The datasource name used in cfquery is whatever you assign it in
administrator, much the same way as an ODBC datasource.
Matt
-----Original Message-----
From: Jay Brushett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 9:04 AM
To: CF-Talk
Subject: sql server 2000
Hi,
I was wondering if someone could help me. I need to connect to SQL Server
using OLE. I'm not sure exactly what needs to be done inside the
administrator (if anything) and inside cfquery.
TIA,
Jay
< > < > < > < > < Strategy ~ Creativity ~ Technology > < > < > < > < > < >
Jay Brushett
[EMAIL PROTECTED]
Developer
< ZeddComm Inc. >
2nd Floor, The Tower | 100 Signal Hill Road
St. John's, Newfoundland | Canada A1A 1B3
Main: 709.570.5669 | Fax: 709.739.9003
Web: www.zeddcomm.com
< > < > < > < St. John's ~ Toronto ~ Newport Beach ~ Ottawa > < > < > < >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
