TM 9E and Windows 7

Reply

Jeff Salutz Posted: Sun, Apr 1 2012 2:04 PM

rated by 0 users

I was wondering if anyone has used Windows 7 on a workstation to connect to a TM9E database. The install went fine but I'm getting "cannot connect to sql server". It is showing all connection parameters correctly and I can ping the server. All other XP stations connect fine. Just wordering if it's Windows 7 compatibility issue or someting else. Thanks

Jeff Salutz
Salutz & Salutz LLP
Manitowoc, WI

Reply

Michael W. Gaines Jr. replied on Tue, Apr 3 2012 11:12 AM

rated by 0 users

Jeff,

Are you able to establish a Data Source Name (ODBC) to the Time Matters 9 database?

Administrative Tools>Data Sources

Reply

Jeff Salutz replied on Tue, Apr 3 2012 1:43 PM

rated by 0 users

The ODBC connection did not work untill I specified the port. I then went into the TM file locations and changed the sql server line to <servername>\<sqlinstance>, <portnumber> (TimeMatters9). This fixed the connection. I also found Sql Server was not using the default port 1433 even though I never changed it. Thanks for your responce.

Jeff

Reply

Michael W. Gaines Jr. replied on Tue, Apr 3 2012 3:24 PM

rated by 0 users

That certainly explains it but seems like that would be the case for the XP machines as well.  Good catch.

Reply

Jeff Salutz replied on Tue, Apr 3 2012 6:21 PM

rated by 0 users

If I set up an ODBC connection on an XP Machine It figures out the port number without specifying it. Windows 7 for some reason has trouble determining the port without specifying it.

Jeff