Windows 7 and Data Connections

[TheUsed]

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.

[JugglingReferee]

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?

[TheUsed]

yeah, Im assuming there is a different method to database connections. perhaps it doesn't use JET

[nmadd]

I'm guessing you are running the 64-bit version of Windows 7?

http://en.wikipedia.org/wiki/Microso...atabase_Engine

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.

Does this help? http://www.telerik.com/support/kb/as...l-machine.aspx

[TheUsed]

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?

[TheUsed]

I can not find any solutions to connecting to a database from windows 7 64-bit

[nmadd]

How about one of these?
http://reazulk.wordpress.com/2009/05...rating-with-c/
http://www.vb-tips.com/64bitAccess.aspx

[JugglingReferee]

I can not find any solutions to connecting to a database from windows 7 64-bit

What version of Visual Basic are you using? If you're using a non-Express Edition:

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.

[TheUsed]

dang.. im using 2008 express... I have 2008 professional at home i'll just compile it there.

[TheUsed]

How can this be done programmatically?

[JugglingReferee]

How can this be done programmatically?

How can what be done programatically? I'm guessing you want something like this:

If Environment.Version = "Professional Edition" Then
   TargetCPU = "x86"
End If

???

[TheUsed]

correct. however that wont work.. will it? what is TargetCPU declared as?

[JugglingReferee]

No, I do not believe it will work.