Microsoft Access driver problem

[erpl08]

Can anyone throe soem light on this issue?

We have a clean install of CFMX7.1 Enterprise with the latest updates on a
clean Win 2003 Enterprise Server SP1.

We are unable to define Access based datasources with the "Microsoft Access"
driver. It returns:

Connection verification failed for data source: testsource
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error,
connection refused.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver]TCP/IP error, connection refused.


We can define Access based datsources using the "Microsoft Access with Unicode
Support" or using the "Other" drover as per the Macrodmedia Technote at:

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=2d2a7a19[/url]

All the Access .mdb files are on a machine volume i.e. not a network dirve.

All these datasources worked OK with CFMX 6.1 usign the "Microsoft Access"
driver.

The CF ODBC Server and Agent services are both running under the local System
account.

TIA

john

[dphillipsCFX]

How do you have the DSNs setup? Are they listed as "database file" or "system
database file"?

Are the databases password protected at all?


Dan Phillips
[email]dphillips@cfxhosting.com[/email]
CFXHosting.com
a division of Hosting.com

[erpl08]

They are all defined as "Database File" and none are password protected. These
same datasources have been running on our CFMX 6.1 Enterprise Server on Win
2000 Server quite OK .

As I say we have a clean install of CFMX 7 with the latestest updater on a
clean install of Win 2003 Enterprise Server on new hardware. Our SQL 2000 and
Oracle datasources aer OK as are any Access datasources defined with the
"Other" or "Microsoft Access with Unicode". It seems that any driver whch uses
the ODBC Server service, such as the "Microsoft Access" driver is giving
problems.

[sdupre]

Can you telnet to port 19995, 19996?

Is swsoc.exe running? Any errors in the event viewer? Any chance the
/db/cfg/swandm.ini is blocked from writing (this is where Sequelink writes the
datasource after you submit it)

Stephen Dupre
Macromedia QA

[basky]

Hi erpl08 ,
Have you found a solution to this problem?
I am facing the same problem. I am able to telnet to the ports 19995, 19996
and swsoc.exe is running. There are no access privelege issue to any files
underneath cfusionmx7.

Any help would be appreciated.

-basky