This will work in Access. I just tried it out. (ok, kinda missed the original post so this is just a guess, but here is an example of combining two Access databases in one query)
http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914&Start=Last ======================================= ok! Not pretty but I got it working here... Datasource1=iether of your valid datasources t2 *the path to the second "database" *be sure to add the table name as "SecondDBTable" *SecondDbase is the filename of the second database <cfquery datasource="DataSource1" name="myQuery"> SELECT t1.id, t1.Uname, t2.email FROM members t1, C:\YourPath\SecondDbase.mdb.SecondDBTable t2 WHERE t1.Uname = t2.UserName </cfquery> <cfoutput query="MyQuery"> #Uname# #Email# <br> </cfoutput> ======================================== ----- Original Message ----- From: "tom muck" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 2:51 PM Subject: Re: Repost: OLEDB Pathing Question > 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. > > -- > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
