<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">I should have asked “Is it possible that nobody that uses Cuis Smalltalk in macOS accesses relational databases?”<div><br><div dir="ltr">---<div>R. Mark Volkmann<div>Object Computing, Inc.</div></div></div><div dir="ltr"><br><blockquote type="cite">On Oct 20, 2024, at 6:26 AM, Mark Volkmann <r.mark.volkmann@gmail.com> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><meta http-equiv="content-type" content="text/html; charset=utf-8">Yikes! Sounds complicated. Can you point me to any documentation that describes how I could reference a lib path in the Open Smalltalk VM?<div><br></div><div>Is it possible that nobody that uses Cuis Smalltalk accesses relational databases?</div><div><br id="lineBreakAtBeginningOfSignature"><div dir="ltr">---<div>R. Mark Volkmann<div>Object Computing, Inc.</div></div></div><div dir="ltr"><br><blockquote type="cite">On Oct 19, 2024, at 9:46 PM, Jon Raiford via Cuis-dev <cuis-dev@lists.cuis.st> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr">
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<div>
<div dir="ltr">
<div dir="ltr">I assume you are on a Mac. You are running into Apple “courage“ like when they removed headphone jacks. They stop applications from using library paths that weren’t explicitly allowed when the application was compiled. In the old days you could
add to the library path in your bash profile but the only way to make it work now is to add to the library path in a launch script. One potential option is to explicitly reference the homebrew lib paths in the Open Smalltalk vm and recompile it, assuming you
installed the drivers using homebrew. <span></span></div>
<div dir="ltr"><br>
</div>
<div dir="ltr">Jon </div>
</div>
</div>
<div id="ms-outlook-mobile-signature">
<div></div>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Cuis-dev <cuis-dev-bounces@lists.cuis.st> on behalf of Mark Volkmann via Cuis-dev <cuis-dev@lists.cuis.st><br>
<b>Sent:</b> Saturday, October 19, 2024 7:20:15 PM<br>
<b>To:</b> Discussion of Cuis Smalltalk <cuis-dev@lists.cuis.st><br>
<b>Cc:</b> Mark Volkmann <r.mark.volkmann@gmail.com><br>
<b>Subject:</b> [Cuis-dev] ODBC error</font>
<div> </div>
</div>
<div>
<div dir="ltr">I really want to learn how to access relational databases like SQLite and Postgres from Cuis Smalltalk so I can do that as part of an HTTP endpoint implemented using the WebClient package. I have the Cuis ODBC package installed and have registered
a DSN for my database which is "TodoDSN". I tested it by entering `isql TodoDSN` which supposedly verifies that it can be accessed using ODBC. That works great. I can enter "select * from todos;" and I see the records I expect. Then I tried this in a Workspace:
<div><br>
</div>
<div> conn := ODBCConnection dsn: dsn user: user password: password.<br>
<div>
<div><br>
</div>
<div>That gives "Error: External module not found" which comes from this code in the class ODBCLibrary:</div>
<div><br>
</div>
<div><font face="monospace">sqlAllocEnv: environmentHandle <br>
"SQLRETURN SQLAllocEnv(SQLHENV *EnvironmentHandle);"<br>
<cdecl: int16 'SQLAllocEnv' (SQLHENV*)><br>
^ self externalCallFailed</font><br>
</div>
<div><br>
</div>
<div>Can anyone explain what this is doing and what "module" it is looking for?</div>
<div><br>
</div>
<span class="x_gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="x_gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div><font face="arial, helvetica, sans-serif">R. Mark Volkmann</font></div>
<div><span style="font-size:12.8000001907349px"><font face="arial, helvetica, sans-serif">Object Computing, Inc.</font></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<span>-- </span><br><span>Cuis-dev mailing list</span><br><span>Cuis-dev@lists.cuis.st</span><br><span>https://lists.cuis.st/mailman/listinfo/cuis-dev</span><br></div></blockquote></div></div></blockquote></div></body></html>