Login to server

User name and password prevend connection to server

Page 1 of 1

1 Replies - 3605 Views - Last Post: 13 August 2007 - 03:00 AM Rate Topic: -----

#1 cherosoullis  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 8
  • Joined: 24-May 07

Login to server

Post icon  Posted 13 August 2007 - 02:16 AM

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.

Is This A Good Question/Topic? 0
  • +

Replies To: Login to server

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

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;

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1