no foreign keys in Visio

[Marco Laponder]

Hi All,

I have the following problem. We have developed our own DBMS and out
own ODBC driver.

I am using that driver to acces our DBMS within Visio. Tables and
columns are displayed as expected. But there are no foreign keys
displayed. I checked the ODBC client and it is returning SQLForeign
keys information correctly. Also other tools display foreign keys on
our database.

Can anybody give me a hint what the problem might be ?

Kind regards,
Marco Laponder
(e-mail address removed)

 

[Anthony Bloesch [MSFT]]

This should work if you are using the database solution's generic ODBC
driver. Without looking at it in a debugger it is hard to work out what is
going on. In general, the generic driver tries to be fault tolerant and
deal with all sorts of issues we have found over the years (e.g. columns
being returns more than once).

If I had to guess an exception may be being thrown (ODBC drivers should
never throw exceptions but many do) and so the list of FKs is being ignored.

Anthony