coldfusion8 and java

[scheinz]

I am trying to point the web site to a data base . In dreamweaver under data bases, I press modify data source and go into coldfusion. I select the Data source and microsoft access as the driver type and press add. I get an error message : Slelct file on the server: 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 Java Runtime environtment and be sur eto install the browser plug ins.
I have already done this and I do not know wher to go from here. Can someone help me? I have a file in my coldfusion folder : coldfusion8/runtime/jre. Is there some manual way this needs to be connected?? Thanks
Kenn

[-__cfSearching__-]

> Please install Java Runtime environtment and be sur eto install the browser plug ins.
> ...

That is installed with CF by default. The issue is with your browser. You need to install a plugin for whatever browser you are using (Intenet Explorer, Firefox, etcetera) to be able to view the applet. But technically you do not have to use the applet. Just type the file path into the "Database File" textbox manually.

Database File : c:\someFolder\myDatabase.mdb

[scheinz]

I am using internet explorer ver 6. How do I install the applets ? I have installed JRE on my computer already. Thank you
Kenn

[Newsgroup_User]

"scheinz" <webforumsuser@macromedia.com> wrote in message news:gpj2rs$ebm$1@forums.macromedia.com...
>I am using internet explorer ver 6. How do I install the applets ? I have installed JRE on my computer already. Thank you
> Kenn

Download Java for your browser here:

http://www.java.com/

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com

[scheinz]

When I hand input the pathway to my database I get an error message Connections verification failed for data source:Newland java.sql.SQLException:{MacromediaJDBC Driver)ODBC Socket}{Microsoft}{ODBC Microsoft Access not a valid accout name or password???

[scheinz]

I downloaded the file and when I checked it it was already on my computer. I still get the error messages. can I e-mail a adobe acrobat copy of the error messages I am getting. I am stuck at this point and don't know what do do from here. I am putting the data base in my all users,shared documents,Database and file name.mdb. Iam using the official Dreamweaver adobe CS3 training source. Please help me if you can
Kenn

[-__cfSearching__-]

> I downloaded the file and when I checked it it was already on my computer.
> I still get the error messages.

Either you do not have the _browser_ plugin installed or you have java disabled. You can verify the installation here: http://www.java.com/en/download/installed.jsp

> can I e-mail a adobe acrobat copy of the error messages I am getting

This forum does not allow file uploads, but you can always upload a screen shot to a free image hosting site like imageshack.us. Then post the url here.

> I get an error message Connections verification failed for data source

I am not very familiar with Access. But 1) did you verify the path is correct 2) what version are you using and 3) is the database password protected? Upload a screen shot of the settings you entered and post the url here.

[scheinz]

http://img18.imageshack.us/gal.php?g=errormessagecontactingd.tif
I have uploaded the screen shots. I have no security on the database it is only a lesson. I have check the java site and all the files are installed. I verified the path but the automatic browse doesnt work and I get the error message displayed. On one screen (the grey box) if did a queery as to what when wrong.

[-__cfSearching__-]

Okay, I can see the error message.
1) What version of access are you using?
2) Can you upload a screen shot or post the datasource settings you entered in the CF Administrator? Be sure to include the "Show Advanced Settings".

[scheinz]

http://img5.imageshack.us/gal.php?g=editdatafile3.tif
These are the screen shots you asked for. The database file is one that came with the bookAdobe dreamweaver CS3 :Training from the source. The data base can be just opened without a password on my computer C:\documents and settings\all users\shared files\newland_tours.mdb

[-__cfSearching__-]

> ColdFusion User: Admin
> ColdFusion Password: xxxxxxxx

I am not familiar with that material. But IIRC, the default user for MS Access databases is "Admin", and the password is blank. Try clearing out the password in the datasource settings. If that does not work, try clearing both the username ("Admin") and password.


Update:
Also, you usually leave the "System Database File" path blank and use only the "Database File" path. Unless your tutorial says otherwise ..

Database File: c:\documents and settings\..(rest of path)...\Newland_tours.mdb
System Database File: (leave this blank)

[-__cfSearching__-]

I do not have access to ODBC datasources on this computer, but here are some sample settings for a "Microsoft Access with _Unicode_" datasource

http://img17.imageshack.us/img17/2058/cfmsaccessunicodedataso.png

[scheinz]

The CF Data source you have as MyAccessunicodedatasource..Is that folder somewhere? What does the MyAccessunicodedatasource contain?

[-__cfSearching__-]

It is just and example of what settings you might use for a unicode datasource. The datasource name can be whatever you want. Obviously the path to the database file should be changed to wherever your MS Access database is located on your computer.

[scheinz]

Also I am only using coldfusion with Dreamweaver and not SQL or anyother program. I seem to be missing something. When I even start looking for the database I get an error message when pressing the first browse button. http://img19.imageshack.us/gal.php?g=databaseloading1.tif

[scheinz]

Also I am only using coldfusion with Dreamweaver and not SQL or anyother program. I seem to be missing something. When I even start looking for the database I get an error message when pressing the first browse button. http://img19.imageshack.us/gal.php?g=databaseloading1.tif

[-__cfSearching__-]

> Also I am only using coldfusion with Dreamweaver and
> not SQL or anyother program.

If you using any database in your ColdFusion code, you are in fact using SQL (Structured query language).

> I get an error message when pressing the first browse button

The "Browse" error looks like the same problem you described above. Either you do not have the proper java plugin installed OR you have java disabled in your browser settings. I am not using Dreamweaver, so other than that I cannot assist you there, sorry.

[Newsgroup_User]

-==cfSearching==- wrote:
> The "Browse" error looks like the same problem you described above. Either
> you do not have the proper java plugin installed OR you have java disabled in
> your browser settings. I am not using Dreamweaver, so other than that I cannot
> assist you there, sorry.
>

I have not followed this thread, but you can also have problems with
that Java browser button in the CFIDE if you have RDS disabled.

[scheinz]

RDS is enabled.

[scheinz]

I went to the java test site and everything checks out.

[scheinz]

Is there a step by step way of testing the java applets. Shouldn't this load automatically. I also checked the browser and the java applets is loaded.

[scheinz]

Is there a step by step way of testing the java applets. Shouldn't this load automatically. I also checked the browser and the java applets is loaded.

[scheinz]

I have found one new element. When dreamweaver first loads there is a check box that has java load on it. I found this by logging into my computer under a new name and opening Dreamweaver for the first time under a new identity. Can I get this initial startup page back in Dreamweaver CS3 without having to reinstall the whole adobe CS3 suite???
Kenn