Solved

How to connect PowerBuilder 12.1 to MS Access 2010 database?

Posted on 2015-01-31
2
449 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now