AltME: Databases


Shouldn't that rather be HOST instead of TARGET?
>> con: [scheme: 'odbc host: "mydsn"]
Only if the target is a DSN with no other settings specified. Otherwise, use target.
con: [scheme: 'odbc target: "dsn=mydsn"]
For instance, this is a common connection I use at work (server name changed):
conn: [scheme: 'odbc target: "driver=SQL Server Native Client 10.0;server=SERVER1;database=db1;Trusted_Connection=Yes;"]

I've just updated the R3 ODBC Extension to work with more SQL types and, with the support of BrianH, fixed and improved the boot code OPEN and COPY actors.
The extension is available over at Github in both source form as well as a DLL compiled for windows, see

dll compiled means use from R2?
It's an R3 extension. You could load it in R2, but you'd have to program the interface to the extension yourself

Is anyone using Doc's MySql protocol (v4.1 1.3.0) with MySql 5.5.24-cll, protocol v10?
I have a client migrating to a new host. We've been using 1.2.1 against mysql 5.0.95, but 5.5 triggers the client auth error. Moving to Doc's 4.1 version solved that, but a simple test query returns an empty block.
Can't rule out a data migration error yet, as things just moved and getting connected was the frist step. Just curious if someone is known to have this combo working.
Nevermind. I was able to test another query which works, so all is well there. Thanks Doc, once again!
The failing query was a data migration issue, just FYI.
I just upgraded local ubutu and I made the rebol work with ia32-libs again, now rebol mysql client is givin me auth error
Gregg: what did you say you did to make it work? what did you move to 4.1 the mysql server or something else?
Janko: if you're using a newer MySQL version, you need my 4.1 driver.
aha, I hoped he meant that :) , but I only found 1.2.1 on your website
I am looking at this page (google doesn't find me any ohter, I think)
It's not an official release yet...I wish I had time to finish it...:-/
IIRC, it was missing some minor feature support from the protocol and good new test cases...
well if it works for what I need it it's ok with me (I just use mysql for user db so it's rather simple). I found mention of it here now is this the latest version you have?
Yes, the link from the blog entry is the right one too.
thanks! I will try it ... otherwise I will reinstall mysq 5.1

Last message posted 95 weeks ago.