Skip to main content
Inspiring
May 9, 2007
Answered

Setting up remotely

  • May 9, 2007
  • 3 replies
  • 415 views
I have a few basic pages that on my local machine are working.

index.cfm which has a register link and login form
register.cfm, linked from the index.cfm that inserts into medrec.users
addbiographical.cfm that updates medrec.users table

these are set up in dreamweaver 8 with coldfusion developer. My datasource is medrec and datasource variable name is Request.DSN. Here is some of the code from index.cfm.



The folks at register.com have setup a datasource and the info they provided is as follows:

DSN: medrec_preventmd_net
Database Type: Access
Database Name: medrec.mdb
Language: ColdFusionMX

I need some direction on how to make changes to the code to connect and query the datasource on the remote server. And is there a way to set up future pages locally and test and put them remotely with minimal coding changes. Thanks in advance for your help, I apologize for my newbieness. As a side note I have watched the video tutorials from lynda.com "Learning Coldfusion" and "Dreamweaver 8 Dynamic Development" and find them to be quite informative but of course they can't address every question/problem and that is why I look to you.
This topic has been closed for replies.
Correct answer a1fast_eddie
Fixed it. The problem was the query was using "medrec.user" to access the user table when it should be just "user" without the dot notation. Thanks again Phil

3 replies

a1fast_eddieAuthorCorrect answer
Inspiring
May 10, 2007
Fixed it. The problem was the query was using "medrec.user" to access the user table when it should be just "user" without the dot notation. Thanks again Phil
Inspiring
May 10, 2007
Thanks Phil,
I have changed the datasource name and database path as suggested in the above tech note within my files and I reveive the following errors when :

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\CFusionMX7\db\slserver54\logging\medrec.mdb'.

Is there a way to find this invalid path in dreamweaver and correct it or is it linked by the coldfusion setup of the datasource associated with the files.



Participating Frequently
May 10, 2007
Sorry, I don't use Dreamweaver so perhaps someone who does can offer a suggestion here.

Phil
Participating Frequently
May 9, 2007
See the tech note at Dreamweaver writes full path to Access database table in data source code when using ColdFusion MX 7.0.1

Also, there will be issues with user account permissions on your remote server by the admin account on your web server under which you installed ColdFusion. You will probably have to install CF under an account that has the appropriate access permissions on your remote server in order to access the Access database file on that server.

Phil