Last post Aug 01, 2011 03:37 AM by Topspy
Jul 30, 2011 08:24 PM|wessinit|LINK
Can anyone tell me why I cant access my access database on win 2008 server. It is stored in the app_data folder on my website. I could acces it on my computer and on shared hosting. When I put it on windows server 2008 r2 a virtual dedicated server.
None of the database calls are working anyone know why. I installed acces on the host. I installed sql server express. Do I have to change permissions. The server is running .Net 3.5 the code is in .Net 2.0. Everything points to the local database in
the app-data folder why would'nt the database be seen?
Jul 31, 2011 02:00 PM|Bryan Strader|LINK
There can be many different variables involved when migrating servers. Are you getting any specific error or exception? I would start with reviewing the connection string, but more information from the exception will help identify the issue.
Jul 31, 2011 02:32 PM|wessinit|LINK
I am not getting an error from the system. I programmed an exception if the site can't connect to the database to display the error. So the site can't connect. The database is in the app_folder its an access database here is a connections string
<add name="userssampledb" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="|DataDirectory|users.mdb""
So I had this running on server 2003 with .Net 2.0 and IIS 6.o
I now have on server 2008 r2 with .net 4.0 although its running .net 2.0 too and has IIS 7.0. It doesn't run on this system.
Everypage that requires authentication against database and cant be accessed because the database can't be accessed.
I have full read/write permissions on the folder. They are .aspx pages. Do you know of components to be activated on the new server for it to run. I also have it running on my computer so I know the CODING is right just accessing the database is my problem.
Jul 31, 2011 06:25 PM|wessinit|LINK
Solve the problem. The site was a 32 bit system on 64 bit. So I just went to advanced settings in IIS of my site. Changed it to run in 32 bit mode and worked!
Aug 01, 2011 03:37 AM|Topspy|LINK
Good to know, never though this could be problem for access database.