RE: Connecting Coldfusion MX7 to SQL Server 2005
> 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 of the error I copied above that cold fusion gives me > when I try to connect. I will get some screen shots when I get home. First of all, I'm pretty sure that the latest database drivers available with CF do support SQL Server 2005, so you shouldn't need to even bother with all this. I don't know why I didn't just suggest that in the first place. Second, are you actually trying to connect to SQL Server 2005 Express? If so, make sure you've enabled TCP/IP and native SQL logins. Actually, the DataDirect drivers are supposed to support Windows authentication too, but it's just easier to use native SQL logins. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Connecting Coldfusion MX7 to SQL Server 2005
>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 question... I didn't even know the CF administrator had >an area to look .jars. I will have to look at that when I get home this >afternoon. Thank you :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Connecting Coldfusion MX7 to SQL Server 2005
> >> 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 entered into your datasource settings? You are using the > "other" > >datasource option, right? > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > > > >Fig Leaf Software provides the highest caliber vendor-authorized > >instruction at our training centers in Washington DC, Atlanta, > >Chicago, Baltimore, Northern Virginia, or on-site at your location. > >Visit http://training.figleaf.com/ for more information! > > > About your first question... I didn't even know the CF administrator > had an area to look .jars. I will have to look at that when I get home > this afternoon. > > 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 of > the error I copied above that cold fusion gives me when I try to > connect. I will get some screen shots when I get home. > > CW I just went back and looked at those instructions again, and at the bottom in the comments area about half way through it looks like some one else was having the same problem I am having. I will also try that when I get home :). Still though if you have any thoughts I greatly appreciate them :). CW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Connecting Coldfusion MX7 to SQL Server 2005
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 question... I didn't even know the CF administrator had an area to look .jars. I will have to look at that when I get home this afternoon. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connecting Coldfusion MX7 to SQL Server 2005
>> 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 entered into your datasource settings? You are using the "other" >datasource option, right? > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! About your first question... I didn't even know the CF administrator had an area to look .jars. I will have to look at that when I get home this afternoon. 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 of the error I copied above that cold fusion gives me when I try to connect. I will get some screen shots when I get home. CW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Connecting Coldfusion MX7 to SQL Server 2005
> 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. However I did > see multiple lib folders... perhaps I put it in the wrong one > on accident. When you say it has to be in the class path, are > you referring to the path that I use in the CF administrator > that lets me make data sources or something else? Once again > I appreciate the help. I have been working with Coldfusion > and SQL Server for almost a year now, I just haven't had to > set this stuff up from scratch before. 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 entered into your datasource settings? You are using the "other" datasource option, right? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connecting Coldfusion MX7 to SQL Server 2005
>> 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 copied it >> into all of the lib files under cold fusion directories. Even >> after that though it still did not work. > >I don't know if it'll work if you put it in multiple places. You have to put >it in one place, and that place has to be part of the classpath >automatically searched by CF. > >If you're running CF in the standalone configuration, the default, your lib >directory will be c:\coldfusion7\lib, I think. If you're running CF in a >multi-server configuration, your lib directory will be >c:\jrun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib, I >think. > >Also, of course, you'll need to restart CF. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! Hello again, 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. However I did see multiple lib folders... perhaps I put it in the wrong one on accident. When you say it has to be in the class path, are you referring to the path that I use in the CF administrator that lets me make data sources or something else? Once again I appreciate the help. I have been working with Coldfusion and SQL Server for almost a year now, I just haven't had to set this stuff up from scratch before. Thanks again! CW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Connecting Coldfusion MX7 to SQL Server 2005
> 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 copied it > into all of the lib files under cold fusion directories. Even > after that though it still did not work. I don't know if it'll work if you put it in multiple places. You have to put it in one place, and that place has to be part of the classpath automatically searched by CF. If you're running CF in the standalone configuration, the default, your lib directory will be c:\coldfusion7\lib, I think. If you're running CF in a multi-server configuration, your lib directory will be c:\jrun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib, I think. Also, of course, you'll need to restart CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connecting Coldfusion MX7 to SQL Server 2005
>> 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 your lib directory. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! Hello, 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 copied it into all of the lib files under cold fusion directories. Even after that though it still did not work. Thanks! CW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Connecting Coldfusion MX7 to SQL Server 2005
>> 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 your lib directory. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! Hello, 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 copied it into all of the lib files under cold fusion directories. Even after that though it still did not work. Thanks! CW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Connecting Coldfusion MX7 to SQL Server 2005
> 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 ---> > http://www.fusioncube.net/index.php/coldfusion-sql-server-expr > ess ). That was a very good guide. However on of the last steps > he says to do is to download a .jar driver so that cold > fusion can make the JDBC connection, and he gives a link > (http://www.fusioncube.net/index.php/%20http://www.microsoft.c > om/downloads/details.aspx?familyid=e22bc83b-32ff-4474- > a44a-22b6ae2c4e17&displaylang=en) > which doesn't work. He also says to put that file into a > folder in my coldfusion directory that does not exist. > > I ended up tinkering around with it for about two hours and > stopped when I couldn't figure out this error. > > Connection verification failed for data source: GTOTDsite > java.sql.SQLException: No suitable driver The root cause was > that: java.sql.SQLException: No suitable driver 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 your lib directory. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4