MX7 Admin problem - ODBC

[Guest]

Yesterday, our SQL 2005 database server crashed so I moved the databases to an alternate database server.  But the Coldfusion Admin website just hung and I could not access it.  So, I took the IP address that was on the the crashed server and added that IP to the database server where I moved the databases, and the Admin screens came up and I can login.

I started to edit the ODBC connections in the Admin screen.  I started to change the IP address to the primary IP on that server, and change the SQL username to a different username, but I hit cancel on that change.

The databases are restored on the new server with the same username & password that they had on the old server, and the IP address from the old server has been added to the new server.  The websites are now up and running just fine.  From the web server, I can use the Windows ODBC function to successfully test the database connections using the IP address, user & password that are setup in the Coldfusion Admin. 

That's the long story, here is my issue.  Now, I can log in the the Admin website and click to all the pages; Coldfusion Settings, Mail, etc.  But when I click on the Data Source link, that page just hangs.

I checked the ...\lib\neo-query.xml file and that still has the original IP address and username, as if my canelled changes were, in fact, not saved.

Any clue why the Data Source linkhangs and I can no longer access that page ?

I appreciate any help...

Joe Voelker

[Charlie Arehart]

Joe, this is curious. I can't see why the CF admin page for DSNs would hang, regardless of the settings for any DB, other than perhaps when you "verify" a DSN (which is also done when you add a dsn). But you're saying it hangs when you open the page. That's very surprising.

Anyway, as for your observation of the xml file, in that you think it may be the solution, you could edit the file manually--but note that you do need to stop CF, then edit it, then start it, to ensure that your change is loaded (and not overridden by CF itself before or during its shutdown).

Finally, as for using ODBC, I'm curious: my not use the built-in SQL Server JDBC database type? I no longer have a CF7 install on which to test, but is that an option, even if you may be using CF Standard? I just find that many folks who moved from CF5 or earlier used ODBC then and didn't change things once they moved past CF6 and its available JDBC driver alternatives. If the option is there, it may be worth a try for you.

Then again, I can't recall if CF7's SQL Server drivers supported SQL Server 2005. I will note that Adobe came out with a technote for CF 6, though, that showed how to add the driver which could be obtained from MS directly: http://kb2.adobe.com/cps/421/ded4216b.html. (I'll note that since that was written, MS came out with a 1.1 update for their driver, pointed to at the bottom of the page the Adobe technote links to.)

Let us know if any of this helps.

/charlie