tdbc::mysql and activeTcl 8.6b2

[AlanG]

[Apologies. I know that posting via Google broke threads last time I
looked. I vaguely recall someone mentioning an "old interface" that
was accessible, and which preserved threads. If you can point me to
instructions, I'll happily post that way.]

This morning, I attempted to use tdbc::mysql on Windoze using
activeTcl8.6b1 (I think). When I did package require tdbc::mysql I got
an error about TclOO not being present. I vaguely recalled seeing this
before and working around it, but couldn't recall any details.

I took a look at the ActiveState site and saw that it now offered
ActiveTcl8.6b2, which I downloaded and updated via teacup update.

Now, when I run up tkcon and type package require tdbc::myslq, I get
the error "couldn't load library "libmysql.dll": this library or a
dependent library could not be found in library path". I vaguely
recall seeing and working around this one too, but can't recall any
details.

Errr... Help!

Many thanks,
Alan

[AlanG]

Following up my own post, with a change of subject in a shameless
attempt to boost the thread.

Help, please, pretty please.

Alan

[Georgios Petasis]

It's me that I complain about the bug of load under windows... :D

Try this: (it works under my system);

package req tdbc
load [file native
c:/tclapps/tcl/lib/teapot/package/win32-ix86/lib/tdbc_mysql1.0b15/tdbcmysql10b15.dll]
tdbcmysql
package req tdbc::mysql

Load under windows fails to load files specified in unix notation.

George

[AlanG]

George,

On Nov 2, 11:46 am, Georgios Petasis <peta...@iit.demokritos.gr>
wrote:

Thank you for the suggestion. I tried the above but it gave an error
that tdbc::mysql::connection wasn't an object.

I then had a look at what package require tdbc::mysql did, and found
that it sources a file before doing the load, so I tried that first
and got a different error, that the interpreter couldn't find
libmysql.dll. I searched around on my hard drive and managed to track
down a copy but then spent half an hour adding that directory to
TCLLIBPATH which doesn't work.

At this point I twigged that it was Windows trying to load the file,
not Tcl and added the directory containing libmsql.dll to PATH. That
worked.

For the benefit of posterity, the required sequence of Tcl instuctions
was

(My Documents) 49 % package ifneeded tdbc::mysql [package versions
tdbc::mysql]
source c:/tcl86/lib/teapot/package/win32-ix86/lib/tdbc_mysql1.0b15/
tdbcmysql.tcl; load c:/tcl86/lib/teapot/package/win32-ix86/lib/
tdbc_mysql1.0b15/tdbcmysql10b15.dll tdbcmysql
(My Documents) 50 % package require tdbc
1.0b16
(My Documents) 51 % source c:/tcl86/lib/teapot/package/win32-ix86/lib/
tdbc_mysql1.0b15/tdbcmysql.tcl
::tdbc::mysql::resultset
(My Documents) 52 % load [file nativename c:/tcl86/lib/teapot/package/
win32-ix86/lib/tdbc_mysql1.0b15/tdbcmysql10b15.dll] tdbcmysql

Your mileage WILL vary according to how and where you've installed
Tcl.

Many thanks George for pointing me in the right drection. I've located
and modified the relevant pkgIndex.tcl so it all works automatically
and beautifully.

A couple of followups to someone from AS:

i) Any chance of getting the [file nativename ...] added to
pkgIndex.tcl in the distribution?
ii) What about libmysql.dll? Shouldn't that be part of the
distribution, or would that cause licensing problems?

Thanks again George
--
Alan

[Georgios Petasis]

To say the truth, I would suggest re-installing ActiveTcl from scratch:

1) Uninstall ActiveTcl
2) Delete the lib/teapot repository
3) Delete the Teapot directory in Users/<user-name>

4) Install ActiveTcl 8.6b6
5) run: teacup update-self
6) run: teacup update (will take some time)

In my installation, the mysql driver does not seem to depend on another
dll of mysql. I am not sure if I have such a dll in my system :-)
Of course, you will need the hack with "file nativename"...

George