Afternoon all,
We have been using the PostgreSQL with 6.4 and the WIN ODBC drivers for a number of years. The ODBC is a link to reporting writting and mostly enables MS Access & Crystal Reports users access to an applications database. My problem is that we have literally Hundreds of queries and reports written and none of them now work. The reason is that when we did the upgrade to PostgreSQL 7.3 recently and now when we link to the DB/Tables they all come back as public_nnnnnnnnn and therefore, none of the existing references work.
I am sure someone else must have worked through this by now, although I have only seen limited references to this issue in my searches which is the reason for my post. I really do not want to rebuild all of these tools !!
TIA,
JMS...
Jeffrey Silberberg
CompuDesigns, Inc.
Atlanta, GA. 30350