Professional Web Applications Themes

Microsoft Access driver problem - Coldfusion Database Access

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

  1. #1

    Default Microsoft Access driver problem

    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



    erpl08 Guest

  2. #2

    Default Re: Microsoft Access driver problem

    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]dphillipscfxhosting.com[/email]
    CFXHosting.com
    a division of Hosting.com


    dphillipsCFX Guest

  3. #3

    Default Re: Microsoft Access driver problem

    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.

    erpl08 Guest

  4. #4

    Default Re: Microsoft Access driver problem

    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

    sdupre Guest

  5. #5

    Default Re: Microsoft Access driver problem

    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

    basky Guest

  6. #6

    Default Re: Microsoft Access driver problem

    Is there any further information on this? I can't connect to microsoft access
    sources since upgrading to CFMX 7.

    I get this error:

    Connection verification failed for data source: stafftour
    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.

    Any advice would be appreciated.

    Dirk

    klingner Guest

Similar Threads

  1. Replies: 6
    Last Post: September 2nd, 01:22 PM
  2. Need Microsoft Access DB driver for Mac OS
    By Keira* in forum Coldfusion Server Administration
    Replies: 0
    Last Post: December 13th, 12:07 AM
  3. Microsoft Access is not listed in my driver list
    By mistainfa in forum Coldfusion Server Administration
    Replies: 0
    Last Post: November 5th, 05:13 AM
  4. Replies: 2
    Last Post: July 20th, 11:36 AM
  5. Replies: 7
    Last Post: December 8th, 07:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139