I have created a VB2005 application which uses an Access database which in on a server in the network which require username and password. On Windows XP I can use it just fine without requiring user name and password because I have allready provided this at the beggining. On Windows 2000 an error popups with problem connecting to the server because it cannot loging to the server without providing username and password like Windows XP. Can I configure my application to enter user name and password if required only?
(/Public con As New OleDb.OleDbConnection("Provider = Microsoft.Jet.OleDB.4.0;Data Source = \\server1\Testing.mdb;"))
Thanks in advance.
Login to server
Page 1 of 1
User name and password prevend connection to server
1 Replies - 4233 Views - Last Post: 13 August 2007 - 03:00 AM
Replies To: Login to server
Re: Login to server
Posted 13 August 2007 - 03:00 AM
You can specify the user name and password in the connection string in the following manner. Just replace MyDbUserName and MyDbPassword, with your user name and password.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server1\Testing.mdb;User Id=MyDbUserName;Password=MyDbPassword;
Page 1 of 1