SQL Server 2000 JDBC driver??

Ask a Question related to Macromedia ColdFusion, Design and Development.

  1. #1

    Default SQL Server 2000 JDBC driver??

    I know that Microsoft offers a JDBC driver for SQL Server 2000, but its
    a EXE file. I'm also under the impression that the actual jar file
    needs to be copied to a specific location in order for CFMX 7 to take
    advantage of it.

    Does anyone know what this jar file is called?

    Thanks,
    Steve
    Steve Grosz Guest

  2. Similar Questions and Discussions

    1. DataDirect 3.5 JDBC Driver / Problem with CFQUERYPARAMand SQL Server
      Is anyone else experiencing this? I just reported it as a bug, but want to be sure that I'm not the only one, and that it doesn't disappear into the...
    2. SQL Server JDBC Driver / Validation Failure
      Hmmm... I posted earlier today, but the message naver made it to the forums. I'll try again We have been trying to install an app (prototype...
    3. SQL Server JDBC Driver Encryption
      Hi, does anyone know if its possible to encrypt a SQL server jdbc driver datasource? I know it is with ODBC but CF seems to have no options...
    4. Export UniData database to SQL Server 2000 using DTS via ODBC driver failed
      Dear all, I've downloaded, installed, and running UniData 6.0 for Windows beautifully in the last three hours or so, during which time, I've...
    5. DB2 JDBC Driver
      What should I use for the DB2 JDBC driver form JDBC SPs? I'm using "DriverManager.getConnection("jdbc:default:connection");" at the moment. Is...
  3. #2

    Default Re: SQL Server 2000 JDBC driver??

    Steve Grosz wrote:
    > I know that Microsoft offers a JDBC driver for SQL Server 2000, but its
    > a EXE file. I'm also under the impression that the actual jar file
    > needs to be copied to a specific location in order for CFMX 7 to take
    > advantage of it.
    >
    > Does anyone know what this jar file is called?
    If I remember correctly it's an exe, but all it does is expand things
    onto your hard drive. Once it's expanded you should be able to see the
    jar file, which you can put anywhere so long as you tell CFMX 7 where
    it's located. There are three jar files:
    msbase.jar
    mssqlserver.jar
    msutil.jar

    Put those somewhere and add them to CF's classpath and you should be
    good to go.

    Matt

    --
    Matt Woodward
    Team Macromedia - ColdFusion
    mpwoodward *TMM* Guest

  4. #3

    Default Re: SQL Server 2000 JDBC driver??

    It may have simply expanded in the past, but now it seems to install,
    and doesn't tell you where its installing to.

    I'll look for those files.

    Thanks
    Steve

    mpwoodward *TMM* wrote:
    > Steve Grosz wrote:
    >
    >> I know that Microsoft offers a JDBC driver for SQL Server 2000, but
    >> its a EXE file. I'm also under the impression that the actual jar
    >> file needs to be copied to a specific location in order for CFMX 7 to
    >> take advantage of it.
    >>
    >> Does anyone know what this jar file is called?
    >
    >
    > If I remember correctly it's an exe, but all it does is expand things
    > onto your hard drive. Once it's expanded you should be able to see the
    > jar file, which you can put anywhere so long as you tell CFMX 7 where
    > it's located. There are three jar files:
    > msbase.jar
    > mssqlserver.jar
    > msutil.jar
    >
    > Put those somewhere and add them to CF's classpath and you should be
    > good to go.
    >
    > Matt
    >
    Steve Grosz Guest

Posting Permissions

  • You may not post new threads
  • You may 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