coldfusion8 and java

scheinzAuthor

Participating Frequently

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

Inspiring

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

Inspiring

> 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)

scheinzAuthor

Participating Frequently

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

scheinzAuthor

Participating Frequently

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.

Inspiring

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".

scheinzAuthor

Participating Frequently

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

Inspiring

> 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.

scheinzAuthor

Participating Frequently

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???

Inspiring

> 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