RE: connections
-Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 6:28 PM To: CF-Talk Subject: connections hey does anyone know how to set up the database connection on the webserver if your database is not located on your webserver?? i can do this if the database is a SQL server...but i dont see how if the database is Access. right now..i have to always have a specific drive letter mapped to my filer in order for the applications that use the access database on that server to run properly. any ideas are appreciated. thanks, bec. Bec, You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map a network drive and use that when selecting your .mdb file on the other server. You set this up on the computer running ColdFusion, under the machine's Datasources. Also to make this work you must have the ColdFusion Application Server service log on as a user with the appropriate permissions. While ColdFusion normally runs under the LocalSystem account, the drawback to this is that it cannot access network drives--it has no network access rights. So you can log on the service as a specific user with admin rights, say, and the service will be able to access the network drives (as long as they are set with the proper permissions, as well). -Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: connections
that's my problem. i want to use a vnc path, but i cant if it is an access database. unless i am missing something...when it comes up to choose the path, it always selects a drive to map the connection to. and that's what i dont want to do. i know u can do what i want to do if the database is SQL. like i said, not sure for access. thanks, bec. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 7:02 PM To: CF-Talk Subject: RE: connections -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 6:28 PM To: CF-Talk Subject: connections hey does anyone know how to set up the database connection on the webserver if your database is not located on your webserver?? i can do this if the database is a SQL server...but i dont see how if the database is Access. right now..i have to always have a specific drive letter mapped to my filer in order for the applications that use the access database on that server to run properly. any ideas are appreciated. thanks, bec. Bec, You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map a network drive and use that when selecting your .mdb file on the other server. You set this up on the computer running ColdFusion, under the machine's Datasources. Also to make this work you must have the ColdFusion Application Server service log on as a user with the appropriate permissions. While ColdFusion normally runs under the LocalSystem account, the drawback to this is that it cannot access network drives--it has no network access rights. So you can log on the service as a specific user with admin rights, say, and the service will be able to access the network drives (as long as they are set with the proper permissions, as well). -Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: connections
Assuming you're on NT: I don't think you can use the UNC with a file DSN... Try mapping a drive to the folder where the file resides and pointing the ODBC connection to that file. Than just use cfquery datasource=MyNewFileDSNblah blah blah/cfquery If not NT, dunno... -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 4:28 PM To: CF-Talk Subject: RE: connections that's my problem. i want to use a vnc path, but i cant if it is an access database. unless i am missing something...when it comes up to choose the path, it always selects a drive to map the connection to. and that's what i dont want to do. i know u can do what i want to do if the database is SQL. like i said, not sure for access. thanks, bec. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 7:02 PM To: CF-Talk Subject: RE: connections -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 6:28 PM To: CF-Talk Subject: connections hey does anyone know how to set up the database connection on the webserver if your database is not located on your webserver?? i can do this if the database is a SQL server...but i dont see how if the database is Access. right now..i have to always have a specific drive letter mapped to my filer in order for the applications that use the access database on that server to run properly. any ideas are appreciated. thanks, bec. Bec, You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map a network drive and use that when selecting your .mdb file on the other server. You set this up on the computer running ColdFusion, under the machine's Datasources. Also to make this work you must have the ColdFusion Application Server service log on as a user with the appropriate permissions. While ColdFusion normally runs under the LocalSystem account, the drawback to this is that it cannot access network drives--it has no network access rights. So you can log on the service as a specific user with admin rights, say, and the service will be able to access the network drives (as long as they are set with the proper permissions, as well). -Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: connections
Becky, You can use a UNC path, it just doesn't SEEM like you can ;) Create a system DSN, go to select, and where the *.mdb is highlighted, type: \\servername\directory\yourdb.mdb I did this before I responded the first time, and it works like a charm. I had never had the need to do it, so I wanted to make sure I was giving you good advice. -Andy -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 7:28 PM To: CF-Talk Subject: RE: connections that's my problem. i want to use a vnc path, but i cant if it is an access database. unless i am missing something...when it comes up to choose the path, it always selects a drive to map the connection to. and that's what i dont want to do. i know u can do what i want to do if the database is SQL. like i said, not sure for access. thanks, bec. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 7:02 PM To: CF-Talk Subject: RE: connections -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 6:28 PM To: CF-Talk Subject: connections hey does anyone know how to set up the database connection on the webserver if your database is not located on your webserver?? i can do this if the database is a SQL server...but i dont see how if the database is Access. right now..i have to always have a specific drive letter mapped to my filer in order for the applications that use the access database on that server to run properly. any ideas are appreciated. thanks, bec. Bec, You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map a network drive and use that when selecting your .mdb file on the other server. You set this up on the computer running ColdFusion, under the machine's Datasources. Also to make this work you must have the ColdFusion Application Server service log on as a user with the appropriate permissions. While ColdFusion normally runs under the LocalSystem account, the drawback to this is that it cannot access network drives--it has no network access rights. So you can log on the service as a specific user with admin rights, say, and the service will be able to access the network drives (as long as they are set with the proper permissions, as well). -Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
