[Cuis-dev] ODBC error

[Jon Raiford]

What exactly do you mean by not working? Is it not able to open the shared library? Or it is not able to connect to a database? The first thing that happens is allocating the environment by either calling SQLAllocHandle() (current versions of ODBC) or SQLAllocEnv() (old versions of ODBC).

I don’t have an easy way to test that old ODBC code at the moment, but it should be easy enough to find the library class. It is a subclass of ExternalLibrary. From there you can find the alloc call and walk back through senders to figure out how it is called. From there you can see the order things are called.

One annoying thing to note is that you cannot use the debugger to step through an FFI call. It will always say there is an invalid module or something like that. I’ve spoken to Eliot about this and we should be able to get it fixed at some point. But for now just put a self halt after the call and then look at the return code.

Arranging a call would be difficult at the moment. I’m already burning the candle at both ends so not much time unfortunately.

Jon

From: Mark Volkmann <r.mark.volkmann at gmail.com>
Date: Tuesday, October 22, 2024 at 4:37 PM
To: Jon Raiford <raiford at labware.com>
Cc: Discussion of Cuis Smalltalk <cuis-dev at lists.cuis.st>
Subject: Re: [Cuis-dev] ODBC error
The change to the launch script you suggested was not enough to get it working for me. I'd love to pair with you over a screenshare on this if you're willing to do that.

On Tue, Oct 22, 2024 at 1:15 PM Jon Raiford <raiford at labware.com<mailto:raiford at labware.com>> wrote:
Is it not working now? Did the launch script change not work? I helped get the old ODBC package working last year and had to use a similar trick to get the library loaded. There is quite a bit of change coming for ODBC but it won’t be made available for a while. Probably months away.

Jon

From: Cuis-dev <cuis-dev-bounces at lists.cuis.st<mailto:cuis-dev-bounces at lists.cuis.st>> on behalf of Mark Volkmann via Cuis-dev <cuis-dev at lists.cuis.st<mailto:cuis-dev at lists.cuis.st>>
Date: Tuesday, October 22, 2024 at 1:34 PM
To: Discussion of Cuis Smalltalk <cuis-dev at lists.cuis.st<mailto:cuis-dev at lists.cuis.st>>
Cc: Mark Volkmann <r.mark.volkmann at gmail.com<mailto:r.mark.volkmann at gmail.com>>
Subject: Re: [Cuis-dev] ODBC error
I do plan to keep going, trying to learn how I can use ODBC from Cuis Smalltalk to access relational databases. And if I figure it out, I will document it so others don't have to go through as much effort. My main concern is that I could never convince web developers that are currently using languages (like JavaScript or Python) to use Smalltalk instead if so much effort is required just to access a database. I really want to fix that.

On Tue, Oct 22, 2024 at 12:17 PM Hilaire Fernandes via Cuis-dev <cuis-dev at lists.cuis.st<mailto:cuis-dev at lists.cuis.st>> wrote:

You just have to keep going when you remain interested by the topic. Learning phase can be frustrating sometime, but I suspect you have a thick skin.

I have some distant interest on using SQLite for the dybo project.

--

http://mamot.fr/@drgeo<http://mamot.fr/@drgeo>
--
Cuis-dev mailing list
Cuis-dev at lists.cuis.st<mailto:Cuis-dev at lists.cuis.st>
https://lists.cuis.st/mailman/listinfo/cuis-dev<https://lists.cuis.st/mailman/listinfo/cuis-dev>


--
R. Mark Volkmann
Object Computing, Inc.


--
R. Mark Volkmann
Object Computing, Inc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.cuis.st/mailman/archives/cuis-dev/attachments/20241022/312736d9/attachment-0001.htm>