ODBC Connector
Posted: Thu Sep 08, 2005 1:51 am
Just some knowledge sharing here (though ALL of you may have already known this!).
I have been working with setting up web views of Capital SOH using ASP pages.
It is a corporate\fortress installation of Capital, so I am using the advantage ODBC driver.
I could not get the pages to work due to a table type error.
After a couple of days of searching the internet, I finally got the answer from an advantage newsgroup (not a lot out there on this subject...no one but me appears to have had the problem...or has publicly declared it).
Be careful when defining your ODBC connector to change the table type from 'Advantage' to 'FoxPro'. I just assumed that when I 1st created the ODBC that since I was using an Advantage ODBC driver that the table type should be 'Advantage' as well...sometimes we learn the hard way I guess.
I have been working with setting up web views of Capital SOH using ASP pages.
It is a corporate\fortress installation of Capital, so I am using the advantage ODBC driver.
I could not get the pages to work due to a table type error.
After a couple of days of searching the internet, I finally got the answer from an advantage newsgroup (not a lot out there on this subject...no one but me appears to have had the problem...or has publicly declared it).
Be careful when defining your ODBC connector to change the table type from 'Advantage' to 'FoxPro'. I just assumed that when I 1st created the ODBC that since I was using an Advantage ODBC driver that the table type should be 'Advantage' as well...sometimes we learn the hard way I guess.