No, not yet, today. But I don't think that will help because it DOES work on the local dev box...
At 01:22 PM 20/09/02 -0400, you wrote: >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
