In order for this to work NetBIOS must be allowed over the network. If you are going over the internet, having NetBIOS ports exposed to the world is a very bad idea. If the endpoint is fixed, you could open up NetBIOS for that single address, however.
IMHO, a better option is to pull the DB local and build a web-based data entry tool for the client to use over the network. If the network goes down between the server and the client, only the data entry dies and not the entire application. Data integrity is also greatly enhanced (well, for Access). Regards, Kevin >>> [EMAIL PROTECTED] 06/18/02 12:08PM >>> In theory, you would setup a mapped network drive to the remote machine by using either the DNS name or IP address of the remote machine followed by the name of the shared drive. But if you don't have a T-1 on both ends, the connection speed may be too slow to maintain or even connect. So, for example, if the DNS name of the remote machine was "www.fusioneers.com", and the shared drive was "public", then you'd setup a network drive with the following path: \\www.fusioneers.com\public >From there, you would select it as though the .MDB file was on your local machine >since you would have a mapped drive on your local machine. But in practice, I've never seen it work. I tried it with a DSL connection on my end (restricted to 128k upstream) with multiple T-1's on the other end and still couldn't get at it. But you may be able to if you've got a super fast connection. OK so maybe I'm better at networking than CF these days. ;) ---mark ======================================================== Mark Warrick ([EMAIL PROTECTED]) Founder, Fusioneers.com / CTO, ZapConnect.com Phone: 714-547-5386 / 714-667-0203 / Efax: 801-730-7289 http://www.warrick.net / http://www.fusioneers.com http://www.zapconnect.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti ======================================================== > -----Original Message----- > From: Timothy Heald [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 11:25 AM > To: CF-Talk > Subject: RE: Getting to an Access DB on a remote machine > > > How would I do that? I have gone into data sources and looked for where I > can set it up by giving it an ip address or whatever, and I can't seem to > find it. By remote I don't mean even on the same network, maybe > not even in > the same country. > > Tim Heald > ACP/CCFD :) > Application Development > www.schoollink.net > > > -----Original Message----- > > From: Shawn Regan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, June 18, 2002 10:13 AM > > To: CF-Talk > > Subject: RE: Getting to an Access DB on a remote machine > > > > > > You can create a DSN on the CF machine that points the access > file on the > > remote machine. > > > > Shawn Regan > > > > -----Original Message----- > > From: Timothy Heald [mailto:[EMAIL PROTECTED]] > > Sent: Monday, June 17, 2002 10:02 PM > > To: CF-Talk > > Subject: Getting to an Access DB on a remote machine > > > > > > Hey, > > I was wondering if anyone knew how to get CF to talk to an access DB > > on a > > remote machine? Here's my thing. > > > > Client buys products from vender. Vender has product list in an > > access db. > > Client wants to be able to automatically update it's available > > product line > > without waiting for updates. Now I am thinking there should be > > an easy way > > to register the Access db as an odbc data source, then on > clients machine > > use that. But I can't seem to find a straight ODBC driver. > > Seems to be all > > product specific. We need this to be able to go to MX, so no dns-less > > connections or whatever. > > > > I am sorry if this is something I should know how to do. I don't > > often > > work with windows based servers, and almost never with Access when I do. > > > > TIA > > > > Tim > > > > > > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
