egghelp/eggheads community

read from a access database

2002-07-09T06:46:43-04:00

ok, thanks thene...
trying to do the script

Statistics: Posted by blarre — Tue Jul 09, 2002 6:46 am

read from a access database

2002-07-09T06:16:11-04:00

After downloading and installing the MySQL server, you will have to setup the DB and tables.

This is all trivial, and unrelated to the Tcl.

However, to get Tcl to comunicate with the MySQL server, there are a few more steps to take.

First, you will need to download a package or addon module for Tcl, that can be used to talk with the MySQL server.

Look at the MySQL site for information on these.

Once downloaded and compiled, you should read the instructions that come with the package, as these will provie you with all the commands required.

Statistics: Posted by ppslim — Tue Jul 09, 2002 6:16 am

read from a access database

2002-07-09T05:56:58-04:00

thanks for the help, now i have installed mySQl on the linux machine...

but now i think i need some expert help

how do i write the script??

i have some command to use like

-host hostname
-user user
-password password

anyone whant to help me??

Statistics: Posted by blarre — Tue Jul 09, 2002 5:56 am

read from a access database

2002-07-09T05:01:02-04:00

The DDE Tcl module is rather flaky.

I used the DDE module to return information to mIRC, when processing complex scripts (that mIRC could not handle). I now use a DLL to call the script, and use the STDOUT + STDERR information to view returned data.

I found it would crash the oposite DDE party, rather than itself.

No, this was not a issue with mIRC, or any other DDE aware software. mIRC DDE interfaces with IE/netscape allmost all the time (to gain information on the currently viewed web-page).

I also have a few VB programs that interface with mIRC using DDE, without issue.

A ODBC module would do better.

Another option would be to create a exit macro in access (or module), that would export a CVS version of the table. This can be easily read by plain Tcl.

A import macro could do the same thing for startup.

Statistics: Posted by ppslim — Tue Jul 09, 2002 5:01 am

read from a access database

2002-07-09T04:48:21-04:00

possibly an easier way would be to write a dde module and run the eggdrop on a windows box. it does have the downside of meaning that you'll have to have access running, but on the plus side it means that eggdrop would have direct access to most of access's features.

Statistics: Posted by Petersen — Tue Jul 09, 2002 4:48 am

read from a access database

2002-07-08T23:53:00-04:00

well, I've never done it before (been a while since I was really involved with windows), but I think you have set up an odbc data source using the access database and then compile an odbc module for tcl. Then you should be able to access the data. Good luck.

Statistics: Posted by stdragon — Mon Jul 08, 2002 11:53 pm

read from a access database

2002-07-08T22:01:34-04:00

hi, i wonder if its possible to take information from a MS access database...

if i have a database whit name asobiba

and a table whit name members

how can i then take information from members?

then if a person write !find name then the scripts search in the database after the word i write...

thanks

Statistics: Posted by blarre — Mon Jul 08, 2002 10:01 pm