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.OL EDB.4.0; Ole DB Services=-4; Data Source=C:\custsupport\data base\data. mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbCon nection(co nnectionSt ring)
When I upload to the webserver I change the connection - .....Data Source=custsupport/databas e/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\inets rv\custsup port\datab ase\data.m db' 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
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.OL
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbCon
When I upload to the webserver I change the connection - .....Data Source=custsupport/databas
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\inets
Can anyone help me as I really dont know where to go from here
Regards
KevNet
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Something I will def not forget how to do!