read from a access database

blarre · Post by **blarre** » Mon Jul 08, 2002 10:01 pm

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

stdragon · Post by **stdragon** » Mon Jul 08, 2002 11:53 pm

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.

Petersen · Post by **Petersen** » Tue Jul 09, 2002 4:48 am

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.

ppslim · Post by **ppslim** » Tue Jul 09, 2002 5:01 am

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.

blarre · Post by **blarre** » Tue Jul 09, 2002 5:56 am

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??

ppslim · Post by **ppslim** » Tue Jul 09, 2002 6:16 am

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.

blarre · Post by **blarre** » Tue Jul 09, 2002 6:46 am

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