Last post Nov 20, 2006 02:06 PM by Brilyana
Nov 02, 2006 02:50 PM|Brilyana|LINK
I have now deployed the application, thanks to the help I got on here. :) However, once I figured out how to get the default webpage to use the aspx file, it won't connect to the supplied database anymore. I double-checked the spelling, location, security
restrictions, and everything else I could think of in the coding. The application will connect to the database on the dev computer, but not on the server.
VS .NET 2003, Windows Server 2003, MS Access database
Dim conn As
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Inetpub\wwwroot\mdb\userID.mdb"
Dim userDA As OleDb.OleDbDataAdapter =
Dim selectCMD As OleDb.OleDbCommand =
New OleDb.OleDbCommand("SELECT * FROM userID", conn)
selectCMD.CommandTimeout = 30
userDA.SelectCommand = selectCMD
I would prefer not to have to switch to the odbc connection string as I've heard this can be buggy and not allow as many users. Thanks in advance for any help! :)
Nov 02, 2006 04:37 PM|budugu|LINK
I guess problem is in this line
the application is ponting source to a local DB, are sure the acess files are on server local drives?
Nov 02, 2006 08:40 PM|Brilyana|LINK
Nov 03, 2006 10:31 AM|budugu|LINK
Are you getting any error? post the error message her.
It may be due to access issues of ASP.NET processor for that folder.
check the security settings for mdb folder...Just in case [Angel]
Nov 20, 2006 02:06 PM|Brilyana|LINK