Re: CFMX / MSSQL
What type of drivers are you using? The ODBC Socket Connection should work. If you want to use the Sql Server Driver, you need to have mixed mode authentication on your SQL Server. You need to setup a sql server login, with a username an password. Then use this username and password to connect to the datasource via CFMX. In earlier version you could use window authentication with the sql server driver, but not in MX. And you should try to avoid the ODBC Socket Connection. I have both those services stopped.. Brook At 08:24 PM 30/09/02 -0400, you wrote: I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / MSSQL
I am using the local dbo account of sa no password. It will not authenicate in CF MX Admin. The drivers are those in CF MX. -Original Message- From: Brook [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 8:54 PM To: CF-Talk Subject: Re: CFMX / MSSQL What type of drivers are you using? The ODBC Socket Connection should work. If you want to use the Sql Server Driver, you need to have mixed mode authentication on your SQL Server. You need to setup a sql server login, with a username an password. Then use this username and password to connect to the datasource via CFMX. In earlier version you could use window authentication with the sql server driver, but not in MX. And you should try to avoid the ODBC Socket Connection. I have both those services stopped.. Brook At 08:24 PM 30/09/02 -0400, you wrote: I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX / MSSQL
On Monday, September 30, 2002, at 05:24 PM, CF-DEV wrote: I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? Why use ODBC - CFMX has a built-in JDBC driver that works just fine. Below are 3 different ways that work on CFMX OS X (Linux). HTH Dick __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / MSSQL
This is the error: Connection verification failed for data source: Mindkeeper_SQL []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 8:51 PM To: CF-Talk Subject: Re: CFMX / MSSQL On Monday, September 30, 2002, at 05:24 PM, CF-DEV wrote: I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? Why use ODBC - CFMX has a built-in JDBC driver that works just fine. Below are 3 different ways that work on CFMX OS X (Linux). HTH Dick __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / MSSQL
FYI there is a virus going around that targets MSSQL machines with account sa set with no password... More Info here: http://vil.nai.com/vil/content/v_99499.htm At 05:48 PM 9/30/02, you wrote: I am using the local dbo account of sa no password. It will not authenicate in CF MX Admin. The drivers are those in CF MX. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX / MSSQL
On Monday, September 30, 2002, at 05:51 PM, Dick Applebaum wrote: On Monday, September 30, 2002, at 05:24 PM, CF-DEV wrote: I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? Why use ODBC - CFMX has a built-in JDBC driver that works just fine. Below are 3 different ways that work on CFMX OS X (Linux). HTH Dick __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX / MSSQL
That says the driver is specified OK is loaded. The problem is with the URL, UserID or Password. You might want to download ViennaSQL (quick easy) and play around with your connections with it -- it's easier than with CFMX when you get it workin, you cancopy paste the results to CFMX Admin. HTH Dick On Monday, September 30, 2002, at 05:56 PM, CF-DEV wrote: Connection verification failed for data source: Mindkeeper_SQL []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX / MSSQL
I am having trouble posting the setups below -- copy pasted __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX / MSSQL
This is weird -- I'll try sending direct Dick On Monday, September 30, 2002, at 06:03 PM, Dick Applebaum wrote: I am having trouble posting the setups below -- copy pasted __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / MSSQL
Don't I feel like a total A$$ In the HELP it stated to put LOCAL within the parathesis. Such as: (local) Not True.. It is the standard: localhost Thanks everyone!! -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 9:09 PM To: CF-Talk Subject: Re: CFMX / MSSQL This is weird -- I'll try sending direct Dick On Monday, September 30, 2002, at 06:03 PM, Dick Applebaum wrote: I am having trouble posting the setups below -- copy pasted __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
