Connecting to pre-2007 Access database from Vista
-
I have an ASP.NET application that I'm upgrading, and my new development box is Windows Vista and VS.NET 2008. It's well documented that Jet is not installed in Vista, and will not run on it. Does anybody know what the connection string is that I should be using, and what provider needs to be installed? I checked http://www.connectionstrings.com[^], but couldn't quite find what I was looking for. I figure SOMEONE has already been down this road, and thought I'd ask. Thanks in advance.
Jamie Nordmeyer
Portland, Oregon, USA
http://www.feralcodemonkies.com -
I have an ASP.NET application that I'm upgrading, and my new development box is Windows Vista and VS.NET 2008. It's well documented that Jet is not installed in Vista, and will not run on it. Does anybody know what the connection string is that I should be using, and what provider needs to be installed? I checked http://www.connectionstrings.com[^], but couldn't quite find what I was looking for. I figure SOMEONE has already been down this road, and thought I'd ask. Thanks in advance.
Jamie Nordmeyer
Portland, Oregon, USA
http://www.feralcodemonkies.comHi, I'm using Access on Vista with OLEDB
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+file+";User Id=XXX;Password=YYY;";Every constr you ever needed[^] is here. :)Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
-
Hi, I'm using Access on Vista with OLEDB
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+file+";User Id=XXX;Password=YYY;";Every constr you ever needed[^] is here. :)Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
That's what I was using when I migrated the project to my new development box, but it says that it can't find the Jet provider. Research on Google says that you can't use Jet in Vista; the installer won't even install it. How did you set it up?
Jamie Nordmeyer
Portland, Oregon, USA
http://www.feralcodemonkies.com -
That's what I was using when I migrated the project to my new development box, but it says that it can't find the Jet provider. Research on Google says that you can't use Jet in Vista; the installer won't even install it. How did you set it up?
Jamie Nordmeyer
Portland, Oregon, USA
http://www.feralcodemonkies.comI don't recall there being any issue. I installed Access2003, Visual Studio, and lots of other stuff on a Vista Home Premium machine. Then created a C# app that works on an existing mdb file. What installer is complaining? and what is its message? :confused:
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.