Have you actually gotten this to work with a database on the same machine? I've been unable to make anything happen with OLEDB without first setting them up in the CF administrator.
tom "Larry C. Lyons" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Because of the HOF server problems last week (and this week from the > sounds of it), there was no response to this, so I'm trying again. > > Using CF 4.5.2 on an NT box with all the most recent patches. The web > server is WebSite Pro 3.0 > > I'm experimenting with OLEDB for our data sources. From what I > understand, you can use direct OLEDB access for DSN-less DB connections, > however, you need to have at least one OLEDB connection for this to > work. > > So you can have something like this: > > <CFSET DBPath = "_Path_To_DataBase_"> > <CFQUERY NAME = "QueryName" > DATASOURCE = "#DBPath#" > DBTYPE = "OLEDB" > PROVIDER = "SALOLEDB" > PROVIDERDSN = "#DBPath#" > USERNAME = "UserName" > PASSWORD = "Whatever" > > SELECT UserID, UserName, Street, City, UserState, Zip > FROM UserInfo > WHERE UserName = '#FORM.USERNAME#' > </CFQUERY> > > Here's the question, I can see how this works when the database is on > the same machine as the CF Server, but how do you set up the path to the > database when its on a separate machine? > > thanks, > > larry > > -- > Larry C. Lyons > ColdFusion/Web Developer > EBStor.com > 8870 Rixlew Lane, Suite 201 > Manassas, Virginia 20109-3795 > tel: (703) 393-7930 x253 > fax: (703) 393-2659 > http://www.ebstor.com > http://www.pacel.com > email: [EMAIL PROTECTED] > > Chaos, panic, and disorder - my work here is done. > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
