Hey guys
I have a problem, I want to get live data from a DB to a remote user for use in a crystal reports viewer. ATM I have the remote server query the DB and return a dataset which the user saves as an XML file. Crystal can use XML files for it's reports BUT it needs (as far as I can find) an ODBC DSN to access it. As this will hopefully be a distrebuted app. I'd rather not use a DSN (at least not a system or user DSN). Any one have any ideas as how to get around this problem?
This is driving me nuts! Any help would be apreciated!
TPM
P.S. I don't want to directly access the DB for security reasons.
I have a problem, I want to get live data from a DB to a remote user for use in a crystal reports viewer. ATM I have the remote server query the DB and return a dataset which the user saves as an XML file. Crystal can use XML files for it's reports BUT it needs (as far as I can find) an ODBC DSN to access it. As this will hopefully be a distrebuted app. I'd rather not use a DSN (at least not a system or user DSN). Any one have any ideas as how to get around this problem?
This is driving me nuts! Any help would be apreciated!
TPM
P.S. I don't want to directly access the DB for security reasons.