Howdy -- We have CF5Pro working fine on one of our Linux machines, and in the process of preparing for an upgrade to MX, we've installed CF5 (from the same installation package) on another one of our Linux machines. (This latter installation will be a testbed for testing the upgrade to MX before we upgrade our production machine to MX.)
The problem is, we can't get the test machine to connect to any of the databases on our SQL Server machine. The production machine has many ODBC datasources that connect fine to various databases on the SQL Server machine, but I can't establish an ODBC datasource on the test machine that will connect successfully to any database on the SQL Server machine. Other info: (1) All three machines are on the same Class C subnet. (2) Each of the three machines can ping the other two machines. (3) Each of the Linux machines can telnet to the other. Both can telnet to the SQL Server machine on port 1433. (4) The /home/coldfusion/bin/start files are the same on the two Linux machines. (5) The /home/coldfusion/odbc/odbc.ini files are the same on the two Linux machines. (6) The /home/coldfusion/lib/CFmsss16.so Merant SQL Server driver files are the same on the two Linux machines. (7) The test machine not only can't establish an ODBC connection to the SQL Server on the production machine but also can't establish ODBC connections to a couple of other SQL Servers we have on other machines on the same subnet. (8) The test machine *can* establish ODBC connections to files on the test machine using the Merant Text Driver and the Merant dBase/FoxPro driver. I haven't been able to test yet whether the test machine can establish an ODBC connection to a MySQL database on a remote machine. Any thoughts about why the test machine can't establish an ODBC connection to a remote SQL Server database? -- Larry Afrin Medical University of South Carolina [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
