I am trying to make an Access Database connections on a web server. 
I've developing an ASP.NET application that will need to access data
that will reside on a web server.  I currently have service with
nexpoint.net and am trying to make a connection with OleDbAdapter
wizard in Visual Studio.NET.

My .NET enabled web server info:

Login ID: bcsgroupnet
password: JGB420
Virtual Domain Name: bcsgroup.net
Server IP Address: 128.121.4.17

So far I'm stumped.  Any help would be appreciated.

Mike

Hi mikeg,
Here is a detailed document from Microsoft about how to create a
connection using OleDbAdapter wizard and they have also given a sample
code for this.
Check this out[http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office12062001.asp]
to get the info.

Check out this related page.
http://dotnet247.com/247reference/msgs/16/80046.aspx

There is a solution given on this page for a similar problem. 
http://dotnet247.com/247reference/msgs/1/9446.aspx

There is also a solution given for a DSN-less connection to access
records in an
Access database using ASP.NET
http://dotnet247.com/247reference/msgs/13/65886.aspx

I hope this will give you enough to resolve your problem.

Regards,
netcrazy

Unless you set up a DSN for you access database, your going to have a
hard time using the OleDbAdapter wizard. Try setting up your
connection object manually in the code, such as this:

  dim conntemp,DSNtemp
  set conntemp=server.createobject("adodb.connection")
  DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
  DSNtemp=dsntemp & "DBQ=" & server.mappath("nwind.mdb")
  conntemp.Open DSNtemp

hope that helps

Alex
-- alexp@halogenstudios.com

Hi,
You would need to use the System.Data namespace of the BCL to get this
done,
recently Microsoft released the ODBC.NET managed provider which can be
used to make managed ODBC connection to a backend database.
This code below uses the OLEDB provider to open a connection with a MS
access database.
Private c As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data
source=c:\demo\google.mdb")
c.open()

For more information visit my website http://www.dotnetextreme.com

Ps. Please never let out ur server password :)

regards,
Manish Mehta
[.NET MVP]
Founder
DotNeteXtreme.com