Microsoft.Jet.OLEDB.4.0 on 64 bit windows server 2008 r2

Posted Date: 12 Jul 2012 Posted By:: atlachar Member Level: Silver Member Rank: 1624 Points: 5 Responses: 2

Hi,
I have a web site with lots of aspx pages and I am using IIS 7 server.we just migrated the servers from old windows 2003 32 bit OS to new windows 2008 64 bit OS.I deployed this aspx files in IIS 7 on new server its working fine.when i come to the data i mean connection string .

We have a sniffer file which sits on one machine (desktop) daily my team member is used to run this sniffer file it checks fo rthe files and data and loads into a specific folder

So for that he just maps this sniffer file from his local desktop to the server either new or old
where i created my web site eg:v:\webs\Cons\test.aspx
so in that cons project i have a folder called database with ADF.mdb file

and my sniffer file connection string is
cnnDB = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=v:\database\APM.mdb;") which he maps from his local desktop to old server 32 bit OS

Now i am using new server how can i use this provider on my new server 64 bit will it work if i keep as it is and just map this sniffer file to my new project location.

Any help that could be appreciated!!

Responses

#680111 Author: Nathaniel Nellas Sumaya Member Level: Silver Member Rank: 1260 Date: 12/Jul/2012 Rating: Points: 1
Yes it will work. There no difference in connectionstring be it on 32 bit or 64 bit OS.

#680120 Author: Anil Kumar Pandey Member Level: Platinum Member Rank: 1 Date: 12/Jul/2012 Rating: Points: 3
If you are using Windows 7 and IIS6 and if the Office suit is 2007 or greater then in that case your connection string will not work. `Provider=Microsoft.Jet.OLEDB.4.0; Data Source=v:\database\APM.mdb;"` for this you need to use the connection string as `Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;` Thanks & Regards Anil Kumar Pandey Microsoft MVP, DNS MVM

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : I have one doubt in authentication and authorization
	Previous : Word document (dot file) open issue in deployment server
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages