Accessing Database in Built Application

[bfarley]

Database access works fine on development machine (compiled and from the LV environment) with LV 8 and MS Office Pro installed.  When I run the compiled application on another machine, I get errors when accessing the database.  Best I can tell from the documentation on the Database Toolkit is the only req is to have MDAC installed.  I confirmed the machine has this installed (MDAC 2.8).

What do I need?

TIA,

Bill F

[RavensFan]

Where is the database located?  Are you using the path of the VI in any way in your program to determin how to access the database?  There are numerous messages about the path to a VI in a built application is different than that in the development environment.  Basically the name of the .exe file becomes a part of the path to the VI.  So if you are using the VI path and strip or add path functions to access another location such as where the database may be located, the functions might not work because the path of the VI will have changed.

[falkpl]

Yes check paths.  Relative paths alwary get screwed when compliling since it requires an extra strip path to get above the exe level.

[RandyR]

I just ran into this problem... In my case, I was getting an error message about "unlicensed use" or something or other. I installed Access onto the machine and everything then worked.

Randy

[RavensFan]

In a message thread where the person has a similar problem, Parthabe posts a VI to handle paths whether you are in development environment or compiled .exe.

http://forums.ni.com/ni/board/message?board.id=170&message.id=273859

Message Edited by Ravens Fan on 09-25-2007 12:02 AM