coldfusion8 and java

[scheinz]

:confused; 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.

[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:confused;

[Ken Ford - *ACE*]

Post by 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:confused;

Download Java for your browser here:

http://www.java.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==-]

Post by scheinz
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

Post by scheinz
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.

Post by scheinz
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.

[-==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

Loading Image...

[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==-]

Post by scheinz
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).

Post by scheinz
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.

[Ian Skinner]

Post by -==cfSearching==-
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