Running clsql on Windows with Mysql

Brian Sorg <[email protected]> Thu, 15 Feb 2018 16:33:43 -0500
Newsgroups gmane.lisp.clsql.general
Message-ID <CAC29X8fUY3-3VFkmp=hGJJcmxHaGgg30sBvPPkLy4k2hBoZ87g@mail.gmail.com>
--===============9044926734216900112==
Content-Type: multipart/alternative; boundary="94eb2c043b68715cbe056546fb26"

--94eb2c043b68715cbe056546fb26
Content-Type: text/plain; charset="UTF-8"

Afternoon -

I am trying to use clsql with Lispworks 7.1 32 bit to connect to the Mysql
5.5.57 community server on Windows, and in doing so I keep running into the
following error:

The following error has occured: Foreign function
MYSQL:CLSQL-MYSQL-FIELD-FLAGS trying to call to unresolved external
function "clsql_mysql_field_flags".

I have double checked that the clsql_mysql.dll file is in the right
location to be loaded and tried manually loading it using the
(uffi:load-foreign-library ..) function, and I am still getting the same
error. So I am thinking that there is a problem with the dll included in
the package.

I then tried to recreate the dll using cygwin with the make file included
but that resulted in an error message when running, and I tried to use the
cygwin gcc command line options to manually recreate it but that is also
giving me errors when trying to create the dll file.

Does anyone have a current version of the clsql_mysql.dll that is working
for them or could put me on the right path to re-creating it?

I not sure if it matters or not, but the foreign-function call is
referenced in the mysql-sql.lisp file in the function
make-type-list-for-auto.

I am using the clsql version "clsql-20160208-git" that quicklisp retrieves.

Thanks,

-- 
Brian Sorg
Director and Founder Liberating Insight LLC
[email protected]
Office: 260.918.0490
Mobile: 260.602.1086
www.liberatinginsight.com

--94eb2c043b68715cbe056546fb26
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div>Afternoon - <br><br></div>I am trying to us=
e clsql with Lispworks 7.1 32 bit to connect to the Mysql 5.5.57 community =
server on Windows, and in doing so I keep running into the following error:=
 <br><br>
The following error has occured: Foreign function=20
MYSQL:CLSQL-MYSQL-FIELD-FLAGS trying to call to unresolved external=20
function &quot;clsql_mysql_field_flags&quot;.

<br><br></div>I have double checked that the clsql_mysql.dll file is in the=
 right location to be loaded and tried manually loading it using the (uffi:=
load-foreign-library ..) function, and I am still getting the same error. S=
o I am thinking that there is a problem with the dll included in the packag=
e.<br><br>I then tried to recreate the dll using cygwin with the make file =
included but that resulted in an error message when running, and I tried to=
 use the cygwin gcc command line options to manually recreate it but that i=
s also giving me errors when trying to create the dll file. <br><br></div><=
div>Does anyone have a current version of the clsql_mysql.dll that is worki=
ng for them or could put me on the right path to re-creating it? <br><br></=
div><div>I not sure if it matters or not, but the foreign-function call is =
referenced in the mysql-sql.lisp file in the function make-type-list-for-au=
to. <br><br></div><div>I am using the clsql version &quot;clsql-20160208-gi=
t&quot; that quicklisp retrieves. <br></div><div><br></div><div>Thanks, <br=
 clear=3D"all"><div><div><div><br>-- <br><div class=3D"gmail_signature">Bri=
an Sorg <br>Director and Founder Liberating Insight LLC<br><a href=3D"mailt=
o:[email protected]" target=3D"_blank">brian.sorg@liberating=
insight.com</a><br>Office: 260.918.0490<br>Mobile: 260.602.1086<br><a href=
=3D"http://www.liberatinginsight.com" target=3D"_blank">www.liberatinginsig=
ht.com</a></div>
</div></div></div></div></div>

--94eb2c043b68715cbe056546fb26--

--===============9044926734216900112==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KQ0xTUUwgbWFp
bGluZyBsaXN0CkNMU1FMQGxpc3RzLmtwZS5pbwpodHRwOi8vbGlzdHMua3BlLmlvL2NnaS1iaW4v
bWFpbG1hbi9saXN0aW5mby9jbHNxbAo=

--===============9044926734216900112==--