Re: Creating DSN by application
I believe you can do this with the ColdFusion servicefactory; it is not officially supported but works well in CFMX and 6.1 (it may change in future versions, YMMV) Check out http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=10 for a good reference. Matt - Original Message - From: Marco Antonio C. Santos [EMAIL PROTECTED] Date: Fri, 13 Aug 2004 10:36:19 -0300 Subject: Creating DSN by application To: CF-Talk [EMAIL PROTECTED] It's possible? Or only by CF Administrator? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating DSN
Try a different password, what did you set the SA password to when you set up the server (SQL) Looks like you are using the wrong pass... Steve -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 10:25 AM To: CF-Talk Subject: Creating DSN Hi all: I'm running CF MX 6.1 version. When i try to create DSN in the CF Server Administrator for an MS SQL Server Database i get this error msg: Connection verification failed for data source: DATADIGI []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Creating DSN
No..It's not wrong pass. When i try to create DSN via Adminsitrative Tools/Data Sources (ODBC) the DSN is created fine I tryed in an ASP page opening one recordset with the connection string using sa loging and the same pass i typed in the CF Server administrator and all works fine I installed all last patches for CF Server 6.1 including the hot fix for Data source connection pooling..but still the same problem.. Thanks steven __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 08:36 AM To: CF-Talk Subject: RE: Creating DSN Try a different password, what did you set the SA password to when you set up the server (SQL) Looks like you are using the wrong pass... Steve -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 10:25 AM To: CF-Talk Subject: Creating DSN Hi all: I'm running CF MX 6.1 version. When i try to create DSN in the CF Server Administrator for an MS SQL Server Database i get this error msg: Connection verification failed for data source: DATADIGI []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Creating DSN
looks like a password error for sure. I am concerned to the SA log-in pair being used in production, however. Best practices would be to create a limited SQL account for use in production queries (one that restricted in particular the account's ability to DROP the table).That way you're double protected against having the drop table command slipped in to the url string (yourfirst protection is, of course, properly validated code in your forms). Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Creating DSN
Hassan - Once you're able to resolve your login issue, I would suggest setting up a dbo specifically for your web application.Connecting via SA opens yourself up to all sorts of malicious exploits as well as inadvertent mistakes that wouldn't generally be possible with a limited-scope account. - Jim Hassan Arteaga Rodriguez wrote: Hi all: I'm running CF MX 6.1 version. When i try to create DSN in the CF Server Administrator for an MS SQL Server Database i get this error msg: Connection verification failed for data source: DATADIGI []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Creating DSN
Actually i'm using another login with store procedure permission only The same error persist when i create another login .. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 09:46 AM To: CF-Talk Subject: RE: Creating DSN looks like a password error for sure. I am concerned to the SA log-in pair being used in production, however. Best practices would be to create a limited SQL account for use in production queries (one that restricted in particular the account's ability to DROP the table).That way you're double protected against having the drop table command slipped in to the url string (yourfirst protection is, of course, properly validated code in your forms). Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]