Dino, The simplest way is to install the MSDE as an instance on the local machine and not use the SA account for the login, create your own there also. Use a connect string for that instance and redo it each and everytime that the program is opened.
Then add a table that keeps track of how many times the user is logged in and limit the users to 1 instance. Robert At 11:00 PM 3/17/2006, you wrote:
Date: Fri, 17 Mar 2006 19:25:18 +1300 From: Dean Cleaver <[EMAIL PROTECTED]> Subject: Slightly OT - how to be sure I am getting data from a local db Hi, I've got a project that I am considering making free for single users, whereas the networked version would be licenced. So, each installation would have MSDE installed on the local machine and the free version would only connect to local host. However, it's easy enough to use a port redirector on port 1433 to defeat this, and redirect it to another server/machine. So I can't rely on using 127.0.0.1 or (local) to connect to SQL Server. I could try query SQL Server for @@SERVERNAME and compare that to the local machine name, but that's the name of the machine SQL was installed on, not necessarily the same as the name of the server now, so this could be unreliable if they change machine names - unlikely I guess, but possible. Any other ways I could try to guarantee that the SQL Server is actually on the local machine? Dino
=================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
