SQL Server 2005 and CF?
OS: WinXP Professional (SP2)
CF: CFMX 6.1 Professional
DB: SQL Server 2005 Express
Having issues getting a DSN set up (without resorting to ODBC via the
OS). Anybody successfully gotten this working?
I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.
Installed to C:\Program Files (the default install).
In the CF Administrator, under datasources, I entered the datasource
name ('comix'), and selected 'Other' for Driver.
Here are the settings that I've tried on the screen that followed:
JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
Driver Class: com.microsoft.sqlserver.jdbc
Driver Name: com.microsoft.sqlserver.jdbc
Error message is:
Connection verification failed for data source: comix
[]java.sql.SQLException: No suitable driver available for comix,
please check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
The root cause was that: java.sql.SQLException: No suitable driver
available for comix, please check the driver setting in resources
file, error: com.microsoft.sqlserver.jdbc
I've found bits and pieces of information that are almost relevant,
but none that are 100%. For example:
Kola Oyedeji has a blog posting that discusses JDBC logging with
P6spy and CFMX. Not relevant to SQL Server 2005 (or any version of
SQL Server), but had some good info about JDBC drivers.
(http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/+meaning+of+bloghl=en)
MM themselves have a tech note, but it's regarding SQL Server 2000, not 2005.
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)
I also looked at the documentation that came with the driver. The
settings that I've posted above are kind of an amalgam of what I was
able to glean from the 3 sources combined.
Oh...the other variable in the equation is the classpath.
I've tried:
C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
F:\CFusionMX\lib\sqljdbc.jar
the first two were the location of the jar file by the default driver
installation (tried both with and without the filename itself). The
last was due to a suggestion that Kola had made regarding placing the
jar file in the CFusion\lib directory (I copied the file over
over...wasn't sure if that would require a classpath variable, but
figured it wouldn't hurt to try). CFMX service was cycled after each
time I modified the classpath var.
Been at this for a while, and really ready to give up and take a nap
(it's 7:30 am Sunday morning). Anybody have any info they can share?
Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)
Thanks
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225324
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server 2005 and CF?
I don't think it supports CF yet. Tried in vain to get it to work with
CF7.01. Like the new Enterprise Manager though but stuck with SQL Server
2000 for now it seems.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Sunday, 27 November 2005 10:36 PM
To: CF-Talk
Subject: SQL Server 2005 and CF?
OS: WinXP Professional (SP2)
CF: CFMX 6.1 Professional
DB: SQL Server 2005 Express
Having issues getting a DSN set up (without resorting to ODBC via the OS).
Anybody successfully gotten this working?
I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.
Installed to C:\Program Files (the default install).
In the CF Administrator, under datasources, I entered the datasource name
('comix'), and selected 'Other' for Driver.
Here are the settings that I've tried on the screen that followed:
JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
Driver Class: com.microsoft.sqlserver.jdbc Driver Name:
com.microsoft.sqlserver.jdbc
Error message is:
Connection verification failed for data source: comix
[]java.sql.SQLException: No suitable driver available for comix, please
check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
The root cause was that: java.sql.SQLException: No suitable driver available
for comix, please check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
I've found bits and pieces of information that are almost relevant, but none
that are 100%. For example:
Kola Oyedeji has a blog posting that discusses JDBC logging with P6spy and
CFMX. Not relevant to SQL Server 2005 (or any version of SQL Server), but
had some good info about JDBC drivers.
(http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/
+meaning+of+bloghl=en)
MM themselves have a tech note, but it's regarding SQL Server 2000, not
2005.
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)
I also looked at the documentation that came with the driver. The settings
that I've posted above are kind of an amalgam of what I was able to glean
from the 3 sources combined.
Oh...the other variable in the equation is the classpath.
I've tried:
C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
F:\CFusionMX\lib\sqljdbc.jar
the first two were the location of the jar file by the default driver
installation (tried both with and without the filename itself). The last
was due to a suggestion that Kola had made regarding placing the jar file in
the CFusion\lib directory (I copied the file over over...wasn't sure if that
would require a classpath variable, but figured it wouldn't hurt to try).
CFMX service was cycled after each time I modified the classpath var.
Been at this for a while, and really ready to give up and take a nap (it's
7:30 am Sunday morning). Anybody have any info they can share?
Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)
Thanks
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies, and
whenever they catch you, they will kill you. But first they must catch you,
digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225325
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Server 2005 and CF?
I think the driver class name should be
com.microsoft.sqlserver.jdbc.SQLServerDriver
if you drop the jar in the cf lib dir you do not need to change the
classpath
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, November 27, 2005 1:36 PM
Subject: SQL Server 2005 and CF?
OS: WinXP Professional (SP2)
CF: CFMX 6.1 Professional
DB: SQL Server 2005 Express
Having issues getting a DSN set up (without resorting to ODBC via the
OS). Anybody successfully gotten this working?
I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.
Installed to C:\Program Files (the default install).
In the CF Administrator, under datasources, I entered the datasource
name ('comix'), and selected 'Other' for Driver.
Here are the settings that I've tried on the screen that followed:
JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
Driver Class: com.microsoft.sqlserver.jdbc
Driver Name: com.microsoft.sqlserver.jdbc
Error message is:
Connection verification failed for data source: comix
[]java.sql.SQLException: No suitable driver available for comix,
please check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
The root cause was that: java.sql.SQLException: No suitable driver
available for comix, please check the driver setting in resources
file, error: com.microsoft.sqlserver.jdbc
I've found bits and pieces of information that are almost relevant,
but none that are 100%. For example:
Kola Oyedeji has a blog posting that discusses JDBC logging with
P6spy and CFMX. Not relevant to SQL Server 2005 (or any version of
SQL Server), but had some good info about JDBC drivers.
(http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/+meaning+of+bloghl=en)
MM themselves have a tech note, but it's regarding SQL Server 2000, not
2005.
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)
I also looked at the documentation that came with the driver. The
settings that I've posted above are kind of an amalgam of what I was
able to glean from the 3 sources combined.
Oh...the other variable in the equation is the classpath.
I've tried:
C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
F:\CFusionMX\lib\sqljdbc.jar
the first two were the location of the jar file by the default driver
installation (tried both with and without the filename itself). The
last was due to a suggestion that Kola had made regarding placing the
jar file in the CFusion\lib directory (I copied the file over
over...wasn't sure if that would require a classpath variable, but
figured it wouldn't hurt to try). CFMX service was cycled after each
time I modified the classpath var.
Been at this for a while, and really ready to give up and take a nap
(it's 7:30 am Sunday morning). Anybody have any info they can share?
Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)
Thanks
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225326
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server 2005 and CF?
Hey,
There are two posts on:
http://weblogs.macromedia.com/mxna/index.cfm?query=byCategorycategoryId=1c
ategoryName=ColdFusion
about this exact topic. Pretty timely eh?
Mark
-Original Message-
From: Dirk De Bock - Lists [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 10:00 AM
To: CF-Talk
Subject: Re: SQL Server 2005 and CF?
I think the driver class name should be
com.microsoft.sqlserver.jdbc.SQLServerDriver
if you drop the jar in the cf lib dir you do not need to change the
classpath
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, November 27, 2005 1:36 PM
Subject: SQL Server 2005 and CF?
OS: WinXP Professional (SP2)
CF: CFMX 6.1 Professional
DB: SQL Server 2005 Express
Having issues getting a DSN set up (without resorting to ODBC via the
OS). Anybody successfully gotten this working?
I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.
Installed to C:\Program Files (the default install).
In the CF Administrator, under datasources, I entered the datasource
name ('comix'), and selected 'Other' for Driver.
Here are the settings that I've tried on the screen that followed:
JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
Driver Class: com.microsoft.sqlserver.jdbc
Driver Name: com.microsoft.sqlserver.jdbc
Error message is:
Connection verification failed for data source: comix
[]java.sql.SQLException: No suitable driver available for comix,
please check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
The root cause was that: java.sql.SQLException: No suitable driver
available for comix, please check the driver setting in resources
file, error: com.microsoft.sqlserver.jdbc
I've found bits and pieces of information that are almost relevant,
but none that are 100%. For example:
Kola Oyedeji has a blog posting that discusses JDBC logging with
P6spy and CFMX. Not relevant to SQL Server 2005 (or any version of
SQL Server), but had some good info about JDBC drivers.
(http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/
+meaning+of+bloghl=en)
MM themselves have a tech note, but it's regarding SQL Server 2000, not
2005.
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)
I also looked at the documentation that came with the driver. The
settings that I've posted above are kind of an amalgam of what I was
able to glean from the 3 sources combined.
Oh...the other variable in the equation is the classpath.
I've tried:
C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
F:\CFusionMX\lib\sqljdbc.jar
the first two were the location of the jar file by the default driver
installation (tried both with and without the filename itself). The
last was due to a suggestion that Kola had made regarding placing the
jar file in the CFusion\lib directory (I copied the file over
over...wasn't sure if that would require a classpath variable, but
figured it wouldn't hurt to try). CFMX service was cycled after each
time I modified the classpath var.
Been at this for a while, and really ready to give up and take a nap
(it's 7:30 am Sunday morning). Anybody have any info they can share?
Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)
Thanks
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Server 2005 and CF?
very cool. Checking 'em out now.
Thanks Mark.
On 11/27/05, Mark Fuqua [EMAIL PROTECTED] wrote:
Hey,
There are two posts on:
http://weblogs.macromedia.com/mxna/index.cfm?query=byCategorycategoryId=1c
ategoryName=ColdFusion
about this exact topic. Pretty timely eh?
Mark
-Original Message-
From: Dirk De Bock - Lists [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 10:00 AM
To: CF-Talk
Subject: Re: SQL Server 2005 and CF?
I think the driver class name should be
com.microsoft.sqlserver.jdbc.SQLServerDriver
if you drop the jar in the cf lib dir you do not need to change the
classpath
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, November 27, 2005 1:36 PM
Subject: SQL Server 2005 and CF?
OS: WinXP Professional (SP2)
CF: CFMX 6.1 Professional
DB: SQL Server 2005 Express
Having issues getting a DSN set up (without resorting to ODBC via the
OS). Anybody successfully gotten this working?
I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.
Installed to C:\Program Files (the default install).
In the CF Administrator, under datasources, I entered the datasource
name ('comix'), and selected 'Other' for Driver.
Here are the settings that I've tried on the screen that followed:
JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
Driver Class: com.microsoft.sqlserver.jdbc
Driver Name: com.microsoft.sqlserver.jdbc
Error message is:
Connection verification failed for data source: comix
[]java.sql.SQLException: No suitable driver available for comix,
please check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
The root cause was that: java.sql.SQLException: No suitable driver
available for comix, please check the driver setting in resources
file, error: com.microsoft.sqlserver.jdbc
I've found bits and pieces of information that are almost relevant,
but none that are 100%. For example:
Kola Oyedeji has a blog posting that discusses JDBC logging with
P6spy and CFMX. Not relevant to SQL Server 2005 (or any version of
SQL Server), but had some good info about JDBC drivers.
(http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/
+meaning+of+bloghl=en)
MM themselves have a tech note, but it's regarding SQL Server 2000, not
2005.
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)
I also looked at the documentation that came with the driver. The
settings that I've posted above are kind of an amalgam of what I was
able to glean from the 3 sources combined.
Oh...the other variable in the equation is the classpath.
I've tried:
C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
F:\CFusionMX\lib\sqljdbc.jar
the first two were the location of the jar file by the default driver
installation (tried both with and without the filename itself). The
last was due to a suggestion that Kola had made regarding placing the
jar file in the CFusion\lib directory (I copied the file over
over...wasn't sure if that would require a classpath variable, but
figured it wouldn't hurt to try). CFMX service was cycled after each
time I modified the classpath var.
Been at this for a while, and really ready to give up and take a nap
(it's 7:30 am Sunday morning). Anybody have any info they can share?
Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)
Thanks
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225342
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
