Hello, I need help getting a connection to a database from within the windows 7 environment. The code currently works for windows XP flawlessly.
However in Windows 7 i get an error about a resource not being registered on the local computer.
Printable View
Hello, I need help getting a connection to a database from within the windows 7 environment. The code currently works for windows XP flawlessly.
However in Windows 7 i get an error about a resource not being registered on the local computer.
This is the same dialog box when I try to import an Excel file on Vista 64, where there is no 64-bit JET resource.
Could my situation and your situation be related?
yeah, Im assuming there is a different method to database connections. perhaps it doesn't use JET
I'm guessing you are running the 64-bit version of Windows 7?
http://en.wikipedia.org/wiki/Microso...atabase_Engine
Does this help? http://www.telerik.com/support/kb/as...l-machine.aspxQuote:
The Jet Database Engine will remain 32-bit for the foreseeable future. Microsoft has no plans to natively support Jet under 64-bit versions of Windows.
well this sure does look like the issue. If this is the case, which im 99% sure, then how can I connect to the database?
I can not find any solutions to connecting to a database from windows 7 64-bit
How about one of these?
http://reazulk.wordpress.com/2009/05...rating-with-c/
http://www.vb-tips.com/64bitAccess.aspx
What version of Visual Basic are you using? If you're using a non-Express Edition:Quote:
Originally Posted by TheUsed
On a VS2008 project, if you chance the Target CPU to x86, it will work. (I went through the same thing using Vista 64 + VS 2008.)
Go to your project's properties, and navigate to Compile > Advanced Compile Options > Target CPU. Change to x86.
dang.. im using 2008 express... I have 2008 professional at home i'll just compile it there.
How can this be done programmatically?
How can what be done programatically? I'm guessing you want something like this:Quote:
Originally Posted by TheUsed
Code:If Environment.Version = "Professional Edition" Then
TargetCPU = "x86"
End If
???
correct. however that wont work.. will it? what is TargetCPU declared as?
No, I do not believe it will work.