Have you applied the CFMX Updater? On Fri, 20 Sep 2002, Brook wrote:
> 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. > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
