Solved

How to connect PowerBuilder 12.1 to MS Access 2010 database?

Posted on 2015-01-31
2
514 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

726 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