I am able to connect using the ODBC drivers in Access (sometimes, other times I will get authorization failed). But when I try to setup a linked server in Enterprise Manager (SQL Server), I always get errors.
My Settings are as follows:
System ODBC DSN:
DSN: Progress
Description: Vantage...
I have inherited the job of re-creating a report from the old report builder and moving it to access. I was able to create the odbc connection but the report itself is very complex. If I could just pull the SQL statement(s) out of the report it would make my life much easier. I see where to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.