Hmm. I must be missing something. The article only talks about OLE DB using SQL Server. I've gotten this to work with machines on the same network and across the country, but not like you described it. With SQL Server, you need to have one OLEDB data source already set up in the CF administrator going to the same server, then you can access different databases on that same server by specifying the dbname in the <CFQUERY> tag. So I always set up an OLE DB datasource going to Northwind, and then change the DBNAME in my <CFQUERY> tag to point to the correct database.
Is this what you're talking about, or were you talking about Access? tom "Larry C. Lyons" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Tom, > > I've been able to get the oledb to work following an article from July > 2000 (Vol2 #7) in CFDJ by Randy Smith. Its on the ColdFusion Developers > Journal site at http://www.sys-con.com/coldfusion/article.cfm?id=126. > But only when the db is on the same machine so far. > > larry > > tom muck wrote: > > > > 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 = "SQLOLEDB" > > > 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. > > > -- > > -- > 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
