>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?
Use SQLStringConnect() to connect to source, then SQLTables() to get the list of tablenames available.
FAQ #8039 might help.
Cetin