ADO.NET ODBC MS-Access connection with UGNX

[SteveAG]

Greetings,

I have moderate experience using journaling and VB.net in the UGNX environment - so please excuse any noobie transgressions.

I am just trying to establish an ODBC connection between a UGNX journaling session and MS-Access (via ODBC and ADO.NET) . I am familiar with database principals but have not used an ODBC connection or ADO.NET before. I have a few questions.

------------

For test purposes I have set up:

In the MS-Windows ODBC Data Source Administator dialog, using the User DSN Tab I have an entry "MS Acccess Database" which points to C:\...\My Documents\ugtest.mdb

------------

What I want to do now is establish an ADO.net/ODBC connection to the MS-Access file from the UG session.

I believe that I need:

Imports System.Data
Imports System.Data.Odbc

When I run a journal file with these Imports statements I receive error messages like:

Line 5: Namespace or type 'Data' for the Imports 'System.Data' cannot be found.

----

I have used other Imports statements successfully (Imports System, Imports NXOpen, etc.)

Questions:

1a. Do I need to include the System.Data and System.Data.Odbc Imports to establish a connection via ADO.NET and/or ODBC?

1b. If 1a is Yes, what am I doing wrong to receive the error messages?

2. What are the general steps to establish a connection between UGNX and MS-Access via ADO.Net and ODBC?

---

Thanks for any help.

Best Regards,
Steve