Link tables in two different odbc databases

[JDPglenman]

Hi,

I am trying through vb.net to link a table in a Paradox 7 database (via odbc) to a table in a PSQL database (also via odbc). I don't know how to set up the connections nor how to set up the SELECT statements

Any advise would be welcome

Regards

Jeremy

 

[chrissie1]

What have you tried so far and what are your specific problems?



Christiaan Baes
Belgium

"In a system where you can define a factor as part of a third factor, you need another layer to check the main layer in case the second layer is not the base unit." - jrbarnett

 

[JDPglenman]

Christiaan,

Thank you for your quick response.

I have not tried anything yet. This problem was posed to me only on Friday and I have to admit I haven't a clue as to how to start.

We have a company-wide PSQL database with a table called 'staff' and the HR department want to purchase a Paradox 7 system with a table called 'Personnel' . Obviously, I don't want to have to duplicate information the whole time, so I want to link our existing 'staff' table to the Paradox 7 'Personnel' table thus retaining all the information in our PSQL database while gaining the functionality of the new HR system.

do I need two odbc connections?
what would the SELECT statement look like?
am I missing the point entirely?

I appreciate your assistance

Regards

Jeremy

 

[chrissie1]

> do I need two odbc connections?
Yes

> what would the SELECT statement look like?
Hard to say without knowing the details and without knowing the fieldtypes.

> am I missing the point entirely?
Most likely. But since I know either of the two systems it will be difficult to give any more advice.

BTW I think you will find that the people on this forum will help you with specific problems and can't help you with general questions. The answer to the question "Is this possible" will always be yes. The answer to the question "Is this easy and doable?" depends on your experience and willingness. Do research and try something then when you have a specific question come back and we will try to help. But both of the databases in question are not very common to say the least so I expect help to be minimal.

Christiaan Baes
Belgium

"In a system where you can define a factor as part of a third factor, you need another layer to check the main layer in case the second layer is not the base unit." - jrbarnett

 

[JDPglenman]

Ok,

Thanks for your advise

Regards

Jeremy