Trying to access server with ADO.NET from XP machine

  • Thread starter Thread starter Mathew
  • Start date Start date
M

Mathew

I have an ACCESS database and want to access it with
VB.NET or VC.NET to create reports and to do error
checking with my forms. When I go into Data From Wizard
to set up my ADO connection, I go into the Data Links
Properties and try to connect to my server and get an
error saying "SQL server does not exist or access
denied." I could use some help from someone.
 
In Data Links Properties, click on Provider tab and select Microsoft Jet 4.0
OLE DB Provider (it is set to SQL by default).
 
Do I need ACCESS database opened when I do this?

I select the database and enter the login information to
log into the database(server login) and test the
connection and I get "Test connection failed because of
error in initializing providere. Cannot start your
application. Workgroup information file is missing or
opened exclusively by another user." I know that the
database is not opened on the server (Windows 2003).
 
¤ Do I need ACCESS database opened when I do this?
¤
¤ I select the database and enter the login information to
¤ log into the database(server login) and test the
¤ connection and I get "Test connection failed because of
¤ error in initializing providere. Cannot start your
¤ application. Workgroup information file is missing or
¤ opened exclusively by another user." I know that the
¤ database is not opened on the server (Windows 2003).
¤

Sounds like a permissions issue. Do you have full access to the folder where the database resides?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
As Paul stated, can you open the same database from within Access
application?

--
Miha Markic - DXSquad/RightHand .NET consulting & software development
miha at rthand com

Developer Express newsgroups are for peer-to-peer support.
For direct support from Developer Express, write to (e-mail address removed)
Bug reports should be directed to: (e-mail address removed)
Due to newsgroup guidelines, DX-Squad will not answer anonymous postings.
 
Yes I do have full access to the ACCESS folder.
-----Original Message-----
¤ Do I need ACCESS database opened when I do this?
¤
¤ I select the database and enter the login information to
¤ log into the database(server login) and test the
¤ connection and I get "Test connection failed because of
¤ error in initializing providere. Cannot start your
¤ application. Workgroup information file is missing or
¤ opened exclusively by another user." I know that the
¤ database is not opened on the server (Windows 2003).
¤

Sounds like a permissions issue. Do you have full access
Click to expand...
to the folder where the database resides?
Click to expand...
 
¤ Yes I do have full access to the ACCESS folder.
¤

Is your Access database set up for user level security? If so it may be looking for your system.mdw
file. Did you specify the path in the Jet OLEDB:System database property on the All tab of the Data
Link Properties dialog?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top