Thanks. This is what I have so far and it seems to work when run on the server where the DB is located: OSQL -s <<SERVER_NAME>>\<<DB_NAME>> -U <<USERNAME>> -P <<PASSWORD>> -i <<PATH_TO_SQL_COMMAND_FILE>> The above makes the connection to the DB and runs the SQL statements held in a text file (PATH_TO_SQL_COMMAND_FILE), which looks a little like this: UPDATE <<TABLE_NAME>> SET <<Column>> = '<<VALUE>>' WHERE <<PREDICTAES>> GO Now, I am facing the following issue. I am unable to run this command from a different server that does not host the DB. I get the below error: [Shared Memory]SQL Server does not exist or access denied. [Shared Memory]ConnectionOpen (Connect()). I am using the host name of the DB server including DNS for server_name. Any ideas? modified on Wednesday, December 10, 2008 9:15 AM

Thanks Dave :-D

You can use simple javascript for this: a href='javascript: window.close();' :zzz:----------------------------------------------------------------------:(( T Manjaly C# Tutorials and samples : http://www.dotnetspider.com

Hi, Sorry, I'm quite new to ASP.NET:~ . I do not know how I can "Add a regular expression validator for your textbox control". Could you tell me how to do this? Thank you for your help.

Thanks Heath :)

See my article, Role-based Security with Forms Authentication[^], for information on how to use a database to store and validate credentials using Forms Authentication, which provides many features over most home-brewed solutions (which are typically pretty insecure if you don't have a lot of experience with security). The .NET Framework 2.0 will make this even easier with pluggable authentication back-ends to various front-ends (like Forms Authentication). For now, you're pretty much left with either extending what's available or implementing your own authentication modules. Microsoft MVP, Visual C# My Articles

Mazdak wrote: you can use if you want. That's what I mean...it's just a bunch of extra typing for nothing... RageInTheMachine9532

please give some more info about the issue... :zzz:----------------------------------------------------------------------:(( T Manjaly C# Tutorials and samples : http://www.dotnetspider.com

If that is just ASP try Code project or a forum from David Wulff[^] Else MSDE is the best thing if u want in ASP.net I was born intelligent Education ruined me!.

You already asked this and got an answer. If you didn't like it, try http://www.google.com[^]. Besides, Access is a TERRIBLE database to use for a backend for something with many concurrent connections. It's not optimized for it. Either use the MSDE - which is a free but slightly limited (for # of connections) SQL Server complete with ACID capabilities - or use SQL Server. You should use a good RDBMS that runs under a daemon so that the database is always available and handles concurrent connections well, something for which Access (JET databases, to be exact) was never intended. Microsoft MVP, Visual C# My Articles

check http://www.webwizguide.info/[^]

True. But, that depends on the purpose. There will probably be licensing issues. I don't know much about it, but MSDE isn't supposed to be for production use, as far as I know. Michael Flanakin Web Log

hi, here is everything u need ;-) i hope it helps u! using System; using System.Threading; // needs to use Thread class namespace ConsoleApplication1 { // the class with main function class Class { /// /// The main entry point for the application. /// static void Main() { // create new Traffic_light object Traffic_light t_l = new Traffic_light(); // loop 10 times for(int i = 0; i < 10; i ++) { t_l.ShowState(); // show current state Thread.Sleep(5000); // wait 5 seconds } // show exit msg. Console.WriteLine("press enter to exit"); Console.ReadLine(); } } // the class u need class Traffic_light { // array with ur states private string[] Array; // index of currrent state private int State; // Constructor to set up default values public Traffic_light() { State = 0; Array = new string[] { "prepare to go", "go", "prepare to stop", "stop" }; } // function u need to show current state // new call - new state public void ShowState() { State %= Array.Length; // same as: State = State % Array.Length; Console.WriteLine(Array[State ++]); // same as: Console.WriteLine(Array[State]); State = State + 1; } } } output u see: ==================== prepare to go go prepare to stop stop prepare to go go prepare to stop stop prepare to go go press enter to exit ==================== best regards !:)