VB.Net 2010 Express and Access database on 64 bit vista

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
I posted this as a bug on MS Connect and am wondering if anybody else can verify the problem:
I been beating my head against the wall for about 3 days and I dont think it is my problem.
Desktop computer - Vista 64 bit<br/>
Portable Computer - Vista 32 bit
vb.net 2010 express on both of them
I can not establish a connection to an Access db (either .mdb OR .accdb) on the 64 bit computer. When I try I keep getting a message that says "Format at the initialization string does not conform to specification starting at index 0." (this was typed
not copied). (There are screen shots over on Connect).
I can establish a connection to a "Microsoft SQL Server Compact Edition" (.sdf) database on the 64 bit computer.
I can estabish a connection to all 3 types on the 32 bit computer (.sdf, .mdb, .accdb).
The funny thing is that if I establish the connection on the 32 bit and copy the program directory over to the 64 bit, the prorgam loads and seems to run fine. But the %$# _(%* Wizard will not run on the 64 bit machine. Runs fine on the 32
bit but not on the 64 bit. Of course I make sure that the dbs are in the location where the program expects them to be when I run the program on the 64 bit machine.
One final thing, when I am in the progam created on the 32 bit and running on the 64 bit and I try Data->Add New Data Source->Database->Dataset only two of the three connections show up while all 3 show up on the 32 bit machine. Also the connection
string is incorrect for the non-sdf connection. It should include .....Jet.... info.
Brian


View the full article
 
Back
Top