Access database error

[SolidEnder87]

I'm trying to add an Access data source in coldfusion following step for step a guide from lynda.com. When I try to submit, this is what I get:

"Connection verification failed for data source: Shadowreaver
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Disk or network error.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Disk or network error."

I've looked all over but really can't find any solutions.

[Guest]

Where is your database located? Is it on the same drive or is it somewhere on the network drive?

[SolidEnder87]

Everything I'm using is located on the same drive, the C drive.

[jboyus]

Some quick questions to get a better hold on things...

Is your DSN set up correctly on the system?
Is your ColdFusion Administrator saying the connection is "OK"?
Are you using the "with Unicode" option for the Access DB? (seems to help)
Can we see what you are "trying" to submit? (The code behind the form I mean)

[SolidEnder87]

I've tried doing it with and without unicode and neither work. I'm not quite sure how to answer the rest since this is my first time using coldfusion.

[Newsgroup_User]

I have to use the "Access with Unicode" option also .. the question is "why"
?
It really should not be necessary .. anyone know "why" it helps?


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development


"jboyus" <webforumsuser@macromedia.com> wrote in message
news:e7uevr$n82$1@forums.macromedia.com...
> Some quick questions to get a better hold on things...
>
> Is your DSN set up correctly on the system?
> Is your ColdFusion Administrator saying the connection is "OK"?
> Are you using the "with Unicode" option for the Access DB? (seems to
> help)
> Can we see what you are "trying" to submit? (The code behind the form I
> mean)
>