Creating a DSN(Data Source Name) in ODBC? How?

[Philip_Courtois]

Hi Robot,

The string constant can be directly connected to the "table" connection of "DB Tools Drop Table.vi" as long as you remove the connection to the existing string control. If you are experiencing broken wires, use the Ctrl+B shortcut to clean up broken wires - then reconnect disconnected objects.

The "DB ToolsList Tables.vi" works fine. I used it before and after the table drop and the list DID show the "Physical_Coordinates" table to exist in the "tables before" indicator while it was not showing in the "tables after" indicator, because it had been dropped. Here's how my code looks like:



Please let me know if you have further questions, thanks.

Have Fun!

Message Edited by Philip C. on 09-22-2005 12:08 AM

[roboticstudent]

Hello,

Now that I am beginning to understand, I am having fun.

Although no errors show on the code, the Front panel did not show the "Physical_Coordinates" table to exist in the "tables before" indicator.

Thanks for your help and patience.  It is appreciated.

[Philip_Courtois]

Hi Robomaster,

Great! We want people to have fun programming...

You say that you can't see the "Physical_Coordinates" table being created. Well, that's odd, because I see it fine:



If you remove the "DB Tools Drop Table.vi" (of course keeping the "connection reference" and "error cluster" connected between the remaining VIs), do you then see the "Physical_Coordinates" table being created? When opening Access, do you see the table in there?

Please keep me updated, thanks...

Message Edited by Philip C. on 09-23-2005 01:55 PM

[roboticstudent]

Hello,

Thank you. It worked. Appreciate all your help.

Another question.

Do you know how someone can enter data to the table from the front panel and it go into Access instead of having always to do it from the code?

Thanks again for any insight.

[Philip_Courtois]

Hi Robomaster,

I'm glad you got it working. Now to the next question; if you are asking how to convert the table data from an array constant to a control, then all you have to do is right click on the array constant and select "Change to Control".

The difference between controls, indicators and constants is essential to understanding how LabVIEW works, so I recommend that you go through some of the getting started courses offered for free from this site:

How Can I Learn LabVIEW?

I would recommend that you start with the 3-hour or 6-hour course and then determine if you need further information. Remember that we also offer great instructor led training classes all over the world.

Have fun!

[roboticstudent]

Hello,

Thanks for your patience with my questions. I will review the material you have suggested and learn from it.

Yet, I understand the fundamentals of controls, indicators, arrays, etc.

When I tried it before, changing the indicator on "table before" and/or "table after" an error occured.

Thanks for all your help again.