Skip to main content
Participant
June 28, 2006
Question

Access database error

  • June 28, 2006
  • 3 replies
  • 996 views
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.
This topic has been closed for replies.

3 replies

Inspiring
July 13, 2006
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)
>


Participant
June 28, 2006
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)
Participant
June 28, 2006
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.
June 28, 2006
Where is your database located? Is it on the same drive or is it somewhere on the network drive?
Participant
June 28, 2006
Everything I'm using is located on the same drive, the C drive.