ok - first off that will not work because your cf server has no way of getting to the server '1crp025' that name in turn must be resolved to an ip addr. at some lvl. when you create odbc datasources in the cf administrator what is really happening is that the cf administrator is creating systemDSN's in your registry and using the 'named pipes' method of connecting to your db server(mssql7...)(allaire probably integrated that feature into cfquery for dsnless connections in vs. 5). i hope you are using a db server if you are gonna hop the pond (oracle|mssql7|sybase|...). what you should do is create the system dsn yourself (w2k | 'control panel' > 'administrative tools' > 'data sources (odbc)') (nt4 | 'control panel' > 'odbc data sources') click add put in the name, then ip addr for 'which sql server you want to connect to?'. on the next page click 'client configuration' under 'network libraries' use tcp/ip, then put in the ip and port number. other db servers should be similar. if you are intent on doing the access thing, you need to resolve that name. either get the name from dns or wins. if not then you can locally resolve the name using the 'lmhosts' file. default in this folder 'C:\WINNT\system32\drivers\etc'. use lmhosts.sam as an example. but the file name needs to be 'lmhosts'. after you edit the file run 'nbtstat -R' from the cmd line, this will reload the name cache in memory so you don't have to reboot the server. that should work. good luck, Alexander Sicular Technical Director, Information Technology The Neurological Institute of New York Columbia University 212.305.1318 [EMAIL PROTECTED] -----Original Message----- From: S.E.Fling [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 4:07 AM To: CF-Talk Subject: server mappings Hi all, OK here is the situation We have a ColdFusion Server in London and one in the US. I want to map the server in London so that it can see the US data base. I have created a "mapping" using the fully qualified path beginning with the server \\1crp025\inetpub\wwwhrisroot\hris\edge and then tried to created an ODBC mapping to the database. The mapping will not verify. \\1crp025\indetpub\hris\mdbs\edge.mdb I cannot user the BROWSE buttons in the ColdFusion administrator because it only sees Drives A, B, C, and D Can this be done? How can I do it? (posted by Sharon for Bruce) Manager HRIS [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
