Link to home
Start Free TrialLog in
Avatar of KevNet
KevNet

asked on

aspx pages trying to connect to Access MDB Database

HI

Im trying to connect to an access MDB using an aspx page and VB.NET

The application works on my local machine but it wont work once I upload to the webserver

The database connection code is as follows at present

Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\custsupport\database\data.mdb"
        Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)

When I upload to the webserver I change the connection - .....Data Source=custsupport/database/data.mdb

So this fits in with the domain layout = http://www.mydomain.co.uk/custsupport/database/data.mdb

however I keep getting errors from the server as it cant find the file in the path

Error =

'c:\windows\system32\inetsrv\custsupport\database\data.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Can anyone help me as I really dont know where to go from here

Regards

KevNet
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KevNet
KevNet

ASKER

Cool - thanks for the help all working now!

Something I will def not forget how to do!