You need to download the SQL Server JDBC Type IV Driver from Microsoft.com, install it and
read the documentation to set the classPath.
Once you have done the above you can check some examples on how to make a connection
and read data from the DataBase and dump that data.
HTH
Joe Eugene
Robyn Follen wrote:
>
> I am going to make a Java class that is called from CF via CFObject. I need
> to do some database queries in this class, but am unsure what I need to do
> to connect to my SQL Server DB. I'm using CF 5 and the jvm that's installed
> with CF. Do I need to install SQL Serv
You will need some SQL server JDBC drivers yes, you can install them
into jvmroot\lib\ext and the jvm should find them no problem.
If your'e using CF5, you may be better off creating a java CFX rather
than using cfobject, might be faster and should be much easier to get
your data/variables back
o: CF-Talk
Subject: RE: JDBC and CF
You will need some SQL server JDBC drivers yes, you can install them
into jvmroot\lib\ext and the jvm should find them no problem.
If your'e using CF5, you may be better off creating a java CFX rather
than using cfobject, might be faster and should be much eas
4 matches
Mail list logo
