Step 2: In CF Administrator go to Java and JVM. Under classpath put this C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib(this is the default install for the drivers). You will need to restart CFMX Application server.
Step 3: Go to datasources. Creat a new one, use driver other. Here is what you will need in the fields.
JDBC URL - dbc:microsoft:sqlserver://{your ip or name of server}:1433;DatabaseName={your database name}
Driver Class - com.microsoft.jdbc.sqlserver.SQLServerDriver
Now put in your SQL username and password and I usually give it a good description. That's it, you're ready to go. You don't overwrite CFMX's drivers you just use these instead and you can still use CFMX at the same time with a different datasource which is how I did my testing.
Read the manual that comes with the drivers, that's where I got all my information from. It has some good stuff in there. You can specify a lot of information in the JDBC Url.
Bob Everland
>Joe, Robert, anyone...
>
>I've decided to give the MS JDBC drivers a go. What's the procedure for
>installing them to make CF use the Microsoft drivers over the DataDirect
>ones? I would imagine copying the jar files to the cfmx\lib folder would be
>a start...?
>
>Thanks
>
>-nathan strutz
>
>
>
>-----Original Message-----
>From: Joe Eugene [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, October 21, 2003 7:54 PM
>To: CF-Talk
>Subject: RE: DataDirect JDBC drivers (shipped with CFMX)..
>
>
>My Test was done on CFMX 6.0 and MS-SQL Server Drivers was much faster than
>Data Direct.
>
>Joe Eugene
> -----Original Message-----
> From: Robert Everland III [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 21, 2003 11:30 AM
> To: CF-Talk
> Subject: Re:DataDirect JDBC drivers (shipped with CFMX)..
>
> Take a lookg at what I sent to the list yesterday. I already ran some
>tests with the drivers that come with 6.1 at least they seem to be very
>similar, though on really large sites I'm sure those numbers will increase.
>
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=280
>65&forumid=4
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
