XOInstance (OpenInsight 32-bit)
At 05 OCT 2012 05:19:30PM Jim Vaughan wrote:
Using XOInstance to connect to an ODBC data source.
Customer had it working under 9.3.0
Just upgraded to 9.3.2 and it no longer works. User gets a dialog "Connect to Data Source" with what appears to be the correct information. 9.3.0 connected without this dialog. If he presses OK, he gets the message 'The ODBC Data source "xyz" has not been configured'
Any ideas? Did anything get changed in this area?
Jim R Vaughan
At 07 OCT 2012 03:37PM Jim Vaughan wrote:
Is anyone using XOInstance on 9.3.2?
Jim R Vaughan
At 08 OCT 2012 03:49AM Carl Pates wrote:
Hi Jim,
I actually used XOInstance a few weeks back when working with the SQL bond (just for testing purposes) and it worked fine for me. AFAIK there were no changes to the XO code recently (or in many years actually).
TBH the DSXO interface is getting a bit dated these days - the SQL bond is a much better alternative and there's OLE ADO programming (which is a well documented API) for direct access to SQL data that doesn't need DSN files on the client machine. What are you using the XOInstance for? Do you have windows bound to an SQL data source or are you using Data Warehousing?
World leaders in all things RevSoft
At 08 OCT 2012 01:47PM Jim Vaughan wrote:
Hmm I had made a few changes to this code, but they are so minor…
At this point I just want to get the customer up and running, but having said that I was already thinking of moving them to the SQL bond.
Let me look at my code first. It's hard for me to test because I don't have access to the customers SQL data.
Jim R Vaughan
At 08 OCT 2012 03:02PM Jim Vaughan wrote:
Got it working, error in my code.
I was reading SQL passwords etc from a new file. The name of the data connection was being converted to uppercase in the old code but not the new.
Jim R Vaughan