change server name

[Paps2]

I need to run my program on my client machine. I had developed my program on my machine and created the DB on my machine. Now I need to transfer the db and my EXE file on to another machine The server name on my machine shows Running - \\Rch1 - MSSQLServer But the server name on the second machine Running - \\Krnot - MSSQLServer How do I replace the servername. My code; Public conn As New OleDbConnection("Provider=sqloledb;server=Rch1;Database=Rch;Trusted_Connection=YES;") Tnx

[Colin Angus Mackay]

You should always put that kind of information in the app.cofig file. That way it can be changed when the application is moved around. Hardcoding this information into the app is just going to cause problems (as you have seen)

---

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog

[Paps2]

Pls Could you give me some more info on this. Tnx

[Frank Kerrigan]

Try google it works a treat http://www.google.co.uk/search?hl=en&q=app.config+in+vb.net+for+sql+connection++strings&meta=[^] Look where you want to go not where you don't want to crash. Bikers Bible