Issues opening VB Form that uses database to load Form

Submitted by fathmi on Mon, 11/25/2019 - 11:50
Forums: 
Journaling / NXOpen API

I am errors loading a VB form that access a database to load the information in datagridview and treeview. I can't load the load the form because of all these errors that are not recognizing the windows database terms. Is there any Reference I can add that would help recognizing the windows database terms?

NXJournaling - Mon, 11/25/2019 - 12:42

Perhaps System.Data would help. It depends on what objects you need to use; do a websearch on your object types to see what .net framework namespace you need.

fathmi - Tue, 11/26/2019 - 12:45

Yes Import System.data worked....

But with no errors in the code I ran the VB file and having this error as the image link below:

https://drive.google.com/file/d/1NNgZ6zhKC2jhYGkLnyIOhx735BHezti0/view

I am guessing it is failing to connect the Access database I am using to pull the data. With just Visual studio the form and the data was loading fine. Not just from NX. Any idea why it would do so?

Regards,
MFJ

NXJournaling - Tue, 11/26/2019 - 13:11

A number of years ago (NX 8 time frame) I had a journal that interfaced with an Access database. It worked great until NX 9 came out. It turns out that the provider program that interfaced with the database only worked with 32 bit programs (NX 9 was the first 64 bit only version of NX). I'm not sure that this is the same issue that you are experiencing, but you might try a different database interface protocol. I'm no database expert, so I'm not sure that is even the right terminology. A websearch based on the error text would be a great place to start.

One site that I've found useful over the years in connectionstrings.com, below is the link to various connection strings for Access databases.

https://www.connectionstrings.com/access/

fathmi - Wed, 11/27/2019 - 05:43

As I have checked, NX is 64 bit and Access is running 32 bit system..

With some research I found people installing Access database engine and solving this issue... but I am not sure if this will help or work from other users computer. First, it is not even working in my computer even after installing the database engine as they've shown..

Regards,
MFJ

fathmi - Wed, 11/27/2019 - 11:13

I transferred the database from Access to SQL and it worked ! Just wanted to keep you in the loop. Thanks!

Regards,
MFJ