RE: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread Dave Watts
I am having trouble setting up a connection from Coldfusion MX7 to SQL Server 2005. After several hours of tinkering with settings that I know and searching the internet for the things I didn't, I found a very helpful guide to setting it up (here ---

Re: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread C W
I am having trouble setting up a connection from Coldfusion First, you can just search the Microsoft site for SQL Server 2005 JDBC drivers. Download those, and run the setup. If I recall correctly, the setup just unpacks the jar files you need to some directory; you'll then need to put them in

Re: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread C W
I am having trouble setting up a connection from Coldfusion First, you can just search the Microsoft site for SQL Server 2005 JDBC drivers. Download those, and run the setup. If I recall correctly, the setup just unpacks the jar files you need to some directory; you'll then need to put them in

RE: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread Dave Watts
Thank you for responding. I did end up doing that (sorry I should have put that little bit of info in there :-\) I downloaded the one from Microsoft. I found the .jar file that I was told to put into my /cffusion/lib ---(Which was not in my coldfusion directories) I pulled that file, and

Re: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread C W
Thank you for responding. I did end up doing that (sorry I should have put that little bit of info in there :-\) I downloaded the one from Microsoft. I found the .jar file that I was told to put into my /cffusion/lib ---(Which was not in my coldfusion directories) I pulled that file, and

RE: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread Dave Watts
Ya I just got frustrated thats why I just was like AHHH screw this I'm putting you in every directory so cf can find you :p I am running in the standalone version. I did put it in the lib folder and restarted coldfusion before I copied it every where and restarted coldfusion again.

Re: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread C W
Ya I just got frustrated thats why I just was like AHHH Then you should be able to just put it in \coldfusion7\lib. Is it showing up in the CF Administrator, on the page that shows all the discovered jar files? When you say it isn't working, how exactly are you verifying that? What do you have

RE: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread Brad Wood
Click on the words System Information at the very top of the page in CF Admin. There is a Java Class Path entry that lists all the jars that are loaded. The same info is available under the Server Settings Settings Summary page. ~Brad = About your first

Re: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread C W
Ya I just got frustrated thats why I just was like AHHH Then you should be able to just put it in \coldfusion7\lib. Is it showing up in the CF Administrator, on the page that shows all the discovered jar files? When you say it isn't working, how exactly are you verifying that?

Re: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread C W
Click on the words System Information at the very top of the page in CF Admin. There is a Java Class Path entry that lists all the jars that are loaded. The same info is available under the Server Settings Settings Summary page. ~Brad = About your first

RE: Connecting Coldfusion MX7 to SQL Server 2005

2008-07-14 Thread Dave Watts
About the second question. I am using the other data source feature, and I followed the instructions that were on this page to set up the data source .(http://www.fusioncube.net/index.php/coldfusion-sql-server-express ) The only way that I am verifying that it isn't working is because