Jim Klocksin
asked on
How to connect PowerBuilder 12.1 to MS Access 2010 database?
I've never worked with Access before so this is all new to me (over 20 years working with SQL Server). I've got a new project that needs to utilize MS Access as the database and I'm trying to learn by using an existing application that I actually converted from Access to SQL Server. My specific problem is a "Database Connect Error" (I'll attach the exact error message being returned. My connection parameters I'm trying to use are as follows:
sqloledb_connectstring = "PROVIDER='Microsoft.ACE.O LEDB.12.0' ,DATASOURC E='D:\DBFi les\PM-JP. accdb',"
sqloledb_connectstring = sqloledb_connectstring + "ACE OLEDB:System Database='D:\DBFiles\Secur ity.mdw',"
sqloledb_connectstring = sqloledb_connectstring + "MODE='DB_MODE_READWRITE'"
SQLCA.DBParm = sqloledb_connectstring
I'm not really familiar with workgroup information files, but I followed the wizard in MS Access 2010 to generate the "Security.mdw" file.
Any help would be greatly appreciated, Jim Klocksin
sqloledb_connectstring = "PROVIDER='Microsoft.ACE.O
sqloledb_connectstring = sqloledb_connectstring + "ACE OLEDB:System Database='D:\DBFiles\Secur
sqloledb_connectstring = sqloledb_connectstring + "MODE='DB_MODE_READWRITE'"
SQLCA.DBParm = sqloledb_connectstring
I'm not really familiar with workgroup information files, but I followed the wizard in MS Access 2010 to generate the "Security.mdw" file.
Any help would be greatly appreciated, Jim Klocksin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER