I am very confused about how to create connections in code to ODBC connections.

I can manually create a remote view either in code or thru the wizards and retrieve the information that I am wishing.

The problem comes in when using Primavera Project Planner (P3).

They are using the Pervasive Software ODBC Interface. When I create a remote view using the wizard I can select from any of the tables are on the list.

How do I connect to them via Code? I will know the name of the table but fisrt 4 characters of the table name can change. For instance the first 4 characters of XXXXACT will change but the table structure is always the same.

I am assuming that I should be using the Create Connection or my preferred method of Create SQL View Connection, but how in code do I select the table inside of the ODBC connection to connect to?