Sign In | Register Now About Bytes | Help | Site Map
Connecting Tech Pros Worldwide

how to connect coldfusion and access?

Question posted by: jesmi (Member) on April 27th, 2007 10:06 AM
how to connect coldfusion and access?
while connecting like mysql gave following error:

This applet displays a file-tree of the server to enable the user to browse its contents. Your browser is not configured correctly to use java applets. Please install the Java Runtime Environment (JRE) and be sure to install the browser plugins.
acoder's Avatar
acoder
Site Moderator
11,740 Posts
April 27th, 2007
11:13 AM
#2

Re: how to connect coldfusion and access?
I assume you are trying to browse the server for the database file. Since the page uses a Java applet for this, you need support for that. Make sure that JRE has been properly installed as well as the browser plugins as mentioned in error message.

Alternatively, instead of browsing for the db file, just manually type in the path to the file and it should work.

Reply
sanjayr08's Avatar
sanjayr08
Newbie
1 Posts
March 20th, 2008
07:01 PM
#3

Re: how to connect coldfusion and access?
Quote:
how to connect coldfusion and access?
while connecting like mysql gave following error:

This applet displays a file-tree of the server to enable the user to browse its contents. Your browser is not configured correctly to use java applets. Please install the Java Runtime Environment (JRE) and be sure to install the browser plugins.


Connect Ms-Access with Cold fusion
1. Start the cold fusion administrator.
On Windows, select start>Progams>coldfusion>coldfusion administrator.
On unix enter the url hostname/administrator in your browser.
2. Enter a password to gain access to the administrator.
3. choose ODBC under the data sources heading on the left menu.
4. Name the datasource companyinfo.
5. select microsoft access driver (*.mdb) from the dropdown box to describe the ODBC driver.
6. Choose Add.
7. In the database file field, enter the full path of the company.mdb access database and click ok.
8. choose create to create the compayinfo data source. the datasource is added to the data source list.
9 locate companyinfo in the data sourcelist.
10. choose verify to run the verification test on the data source.if the data source was created you should see this message. The connection to the data source was verified successfully.
Sanjay Raizada

Reply
acoder's Avatar
acoder
Site Moderator
11,740 Posts
March 20th, 2008
07:06 PM
#4

Re: how to connect coldfusion and access?
Welcome to the site and thanks for the info.

I think, though, that the OP was having problems with the file-tree applet which displays the files and directories.

Reply
Reply
Not the answer you were looking for? Post your question . . .
190,472 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment
Top Coldfusion Forum Contributors