Re: ODBC and Sage Accounts
Hi, I tried to start a thread on this on 10th Dec. So far, 83 reads and no replies! My original need was simply to add some more seats to our original Alpha 5 v4.5 build 266, we don't have a british importer anymore so I downloaded v8 Pro and a 3user runtime. Any of which gives me my extra seats and runs all the code fine with one exception, we have some tables for supplier info and sales info and open transactions which are batch refreshed from a SageLine 100 v6.2 accounting system using the ODBC driver which works fine. I would like to update completely to v8 but can't until I can crack this connection. I tried with v8Pro, failed, read the small print, got v8 Enterprise, still failed, put a message on the board, since then I've tried every vendor option, got a table of what dumps me, what gives me an sql syntax error and sql state code. I've now got MySql and a really thick book to practice connecting to, since I obviously don't know enough about SQL. I'll get there oneday, but it is especially galling that v4.5 did it so easily and new improved v8 doesn't, I keep reminding myself I'm an engineer not a programmer. I could use some help, if anybody takes pity on me, I don't mind a reply on this thread, but it would be lovely to get my reply count up above zero on my 1st and only post.
Hi, I tried to start a thread on this on 10th Dec. So far, 83 reads and no replies! My original need was simply to add some more seats to our original Alpha 5 v4.5 build 266, we don't have a british importer anymore so I downloaded v8 Pro and a 3user runtime. Any of which gives me my extra seats and runs all the code fine with one exception, we have some tables for supplier info and sales info and open transactions which are batch refreshed from a SageLine 100 v6.2 accounting system using the ODBC driver which works fine. I would like to update completely to v8 but can't until I can crack this connection. I tried with v8Pro, failed, read the small print, got v8 Enterprise, still failed, put a message on the board, since then I've tried every vendor option, got a table of what dumps me, what gives me an sql syntax error and sql state code. I've now got MySql and a really thick book to practice connecting to, since I obviously don't know enough about SQL. I'll get there oneday, but it is especially galling that v4.5 did it so easily and new improved v8 doesn't, I keep reminding myself I'm an engineer not a programmer. I could use some help, if anybody takes pity on me, I don't mind a reply on this thread, but it would be lovely to get my reply count up above zero on my 1st and only post.
Comment