Access Provider Error in Vista and Windows 7
Posted: Mon 21 Sep 2009 17:11
On Vista 32bit and Windows 7 I get the following error using the AccessProvider trying to open the access database file.
"[Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length"
To recreate the problem do the following while running Vista 32 bit or Windows 7 RTM 32 bit.
UniConnection1.ProviderName:= 'ACCESS';
UniConnection1.Database:= 'C:\myapp\mydatabase.mdb';
UniConnection1.Connect;
This was testing with a clean VM of Windows 7 RTM. This same code works on Windows XP Pro SP3.
"[Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length"
To recreate the problem do the following while running Vista 32 bit or Windows 7 RTM 32 bit.
UniConnection1.ProviderName:= 'ACCESS';
UniConnection1.Database:= 'C:\myapp\mydatabase.mdb';
UniConnection1.Connect;
This was testing with a clean VM of Windows 7 RTM. This same code works on Windows XP Pro SP3.