Maybe some one here can help. I have been banging my head against the desk on this all week, my site launches Monday, and I still haven't figured it out.
I have a development server with MS SQL7. This box also has a Developers version of CFMX. Then I have another box (production) with CFMX. I am trying to get a datasource connection between the CFMX server and the remote MSSQL Server. Here are the details. CFMX is running under a special account, not the system. It has substantial permissions and CAN access the network. SQL Server is also running under an assigned acount and I am using a specific SQL Server login for the database. On the developer version of CFMX, I can connect to the local datasource just fine using either the ODBC Socket or the SQL Server driver. On the remote CFMX server I can connect to the datasource via the ODBC control panel (using windows authentication or by specifying the user/pass) but can not get a connection via the CFMX administrator. The error I get is at the bottom of this email. Now the strange thing is, I can connect via the ODBC control panel, but not via the ODBC Socket using CFMX. Isn't this the same thing? And I can not connect using the SQl Server drivers at all. I looked at the jrun-resources.xml file and compared it to the same file on the dev server. They look practically identical! The connection string is basically the same. I even tried copying the DNS info from the dev box to the live server to no avail. Does any one know where I should look to resolve this problem? I am really, really stuck on this so any advise is greatly appreciated. Error ------------------------ Connection verification failed for data source: testDB []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. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
