Solved

How to connect PowerBuilder 12.1 to MS Access 2010 database?

Posted on 2015-01-31
2
465 Views
Last Modified: 2015-01-31
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.OLEDB.12.0',DATASOURCE='D:\DBFiles\PM-JP.accdb',"
sqloledb_connectstring = sqloledb_connectstring      + "ACE OLEDB:System Database='D:\DBFiles\Security.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 KlocksinAccessConnectionErrorMsg.jpg
0
Comment
Question by:Jim Klocksin
  • 2
2 Comments
 

Accepted Solution

by:
Jim Klocksin earned 0 total points
ID: 40581752
Never mind.....I realized that I had a parameter defined for SQL Server that should NOT have been set in order to access MS Access databases.  So this "question" is closed from my perspective.  Since I'm new to Access, I may have other questions before I complete this project, as of now, everything is OK!   Sorry about that!
0
 

Author Closing Comment

by:Jim Klocksin
ID: 40581755
Over-reaction on my part since I have no real experience with MS Access.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question