Finally, I have something new and maybe interesting to throw at y'all!
Got a potential client I'm doing some prelim work for to determine if we can establish an ODBC connection to a Progress Database. I'm just now trying to install all the ODBC drivers and extras the Progress client requires. However, I wondered if anyone on this group had ever connected Foxpro to Progress and if so, what pitfalls can you help me avoid? I'm told by the client that they use SQL Management Studio and then connect to the Progress database via Linked Databases which forces the use of an ODBC DSN. My goal would be to use this to browse the tables and build my test queries and then use SQL Pass-Through via a DSN-Less ODBC connection to query data in production.
I've accomplished similar processes by connecting Foxpro to SQL, MySQL, PostgreSQL, FirebirdSQL, Oracle, Sybase, SQLite and Access. I've ODBC'd my way into a bunch of databases, but I've never worked with Progress.
Any tips, suggestions or recommendations?
Thanks in advance!
Paul H. Tarver
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---