|
Post by Carl Gundel on Aug 12, 2019 16:22:23 GMT -5
I only tested the new ODBC support using an ODBC to SQLite driver.
So, anyone had a chance to try it yet with SQL Server or other database?
|
|
|
Post by Chris Iverson on Aug 12, 2019 23:42:16 GMT -5
Haven't had much time to play with it, but haven't had much success, either.
I found a SQLite -> ODBC driver, and set it up, and pointed it at the callers.db file, but I get an error about the sys.tables table not being found.
Not sure if I'm using the same driver you are.
|
|
|
Post by meerkat on Aug 13, 2019 4:39:41 GMT -5
Gave it a quick try. Haven't had time to give it justice yet. I downloaded odbc driver and installed from here: www.microsoft.com/en-us/download/details.aspx?id=36434Not even sure that is the correct download?? Got a error, but never had time to see what the problem was.. Maybe I can get to it today..
|
|
|
Post by Carl Gundel on Aug 13, 2019 6:33:55 GMT -5
Haven't had much time to play with it, but haven't had much success, either. I found a SQLite -> ODBC driver, and set it up, and pointed it at the callers.db file, but I get an error about the sys.tables table not being found. Not sure if I'm using the same driver you are. Oh, looks like a provided the wrong version of the BAS file, which was originally written for SQL Server. I rewrote it for SQLite but apparently provided the wrong one.
|
|
|
Post by Carl Gundel on Aug 13, 2019 6:46:54 GMT -5
The createTable routine really should look like this.
sub createTable call connect #db execute("SELECT * FROM sqlite_master WHERE name = 'calls' and type='table'") if #db hasanswer() = 0 then #db execute("create table calls(CALLERSNAME text, PERSONCALLED text, DATEOFCALL text, TIMEOFCALL text, PURPOSEOFCALL text, CALLERSPHONE text)") end if call disconnect end sub
|
|
|
Post by Chris Iverson on Aug 13, 2019 10:36:42 GMT -5
Yep, looks like that change has fixed it. It's working for me, now.
Going to attempt to setup SQL Server Express on my computer, and then also test to see if I can get it to work through Excel and Access files, using their ODBC accessors.
|
|
|
Post by Chris Iverson on Aug 13, 2019 23:39:48 GMT -5
Ok, tested connections with Access, Excel, and SQL Server, all successful.
I did have to make adjustments for all three, and I don't actually recommend using ODBC for Excel, and not doing table management with Access, as they're not really made for that.
Still, I was able to add and retrieve data from each one.
|
|