INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

ADO.NET ODBC Connection to MS_Access

ADO.NET ODBC Connection to MS_Access

(OP)
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. without the error messages)

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 my VBA.net appication session and MS-Access via ADO.Net and ODBC? I can read the MS help documentation - but since they are written to cover a myriad of options - I'm looking for some more direct help from someone whos connected their application vie VBA.net to MS-Access using ODBC connectivity.

---

Thanks for any help.

Best Regards,
Steve  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close