-
July 29th, 2011, 11:27 AM
#1
porting standalone vb.net app on x64 (Windows 7)
Hello All,
I've developed an application, that uses ACE OLEDB to access .accdb file. It works ok on XP (32 bit). When I try to put that on Windows 7 (64 bit) it fails to get the data from the database.
If I use Select * , It works on Windows 7 but if I use Select fieldname, it fails. I installed Access Redistributables for x64 but no help. This code works in 32 bit but fails on 64 bit. In complile option, I've set it to "Any Cpu".
Any help is greatly appreciated.
sOleDbConnectionString = "Provider=MSDataShape;Data Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " & oAppConfig.GetMetaFileNamePath & " ;"
strSQL = "SELECT field_name from EE_DDICT"
If MetafileConn Is Nothing Then
MetafileConn = New OleDbConnection(sOleDbConnectionString)
End If
Dim MetafileDA As OleDbDataAdapter = New OleDbDataAdapter(strSQL, MetafileConn)
MetafileDA.Fill(FieldsDS, "DataDict")
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|