Posted: Wed Mar 22, 2006 11:30 am Post subject: FoxPro database Connectivity from MB
Apprentice
Joined: 30 Jun 2005 Posts: 37
Hi,
I have a requirement in which I need to connect to FoxPro database in Windows environment from Message Broker V6.0.
Does any body ever connected to FoxPro database which is in windows environment.I want to know whether it is possible to connect.i.e.,are there any ODBC drivers available.
You can look into using a Type 4 JDBC driver (if you can find one) from a Java compute node. _________________ I am *not* the model of the modern major general.
Is your broker running on Windows? Have you tried the delivered Microsoft Visual FoxPro ODBC Diver? Although not supported, it just may work.
If running your broker on Windows is not an option, then I would look into connecting through a linked server through SQLServer or its equivalent in DB2 or Oracle. Or you could do JDBC as Jeff pointed out.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum