• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

Packaging MS Access driver in an MSI.. do i need to?

Hi,
I'm trying to work out what should be quite a simple question:

Information
-------------
1) I am creating an powerbuilder application that connects to MS Access. Currently this is done using an ODBC connection
2) I have Installshield X which i am trying to create a MSI Script for users to run to install
3) The end-users who will be installing this application have very little computer experience so i want the whole installation process to be very simple.
4) Using Powerbuilder 10

Questions
------------
1) Does MS Access Drivers get automatically installed as part of a standard build of a PC (XP and VISTA)
2) If it doesn't then what do i need to get installed on the machine so i can create the ODBC connection in the DSN
3) Can Powerbuilder talk to MS Accesswithout the ODBC Connection being installed? If so do you have an example of the connection string?

I really appreciate any help

thanks




0
Follette
Asked:
Follette
  • 3
1 Solution
 
souseranCommented:
1. No. MS Access is part of Microsoft Office, not Microsoft Windows.

2. At the minimum, a Microsoft Access runtime for the version of your choice. You can get that here:

http://search.microsoft.com/results.aspx?q=access+runtime&qsc0=0&SearchBtn0=Search&mkt=en-us&FORM=SSME

3. A question for another expert to answer as programming isn't my area of expertise.
0
 
Vadim RappCommented:
> 1) Does MS Access Drivers get automatically installed as part of a standard build of a PC (XP and VISTA)

yes.

2) If it doesn't then what do i need to get installed on the machine so i can create the ODBC connection in the DSN

because of (1) you don't need it, but if you did, it would be what's called MDAC .

Hopefully someone in Powerbuilder area will answer (3).

0
 
Vadim RappCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now