Ok new development I found the perfect tool that does almost everything for you. check out http://www.mysqlfront.de a very nice MySQL front end I might add ;)
JC --- JC <[EMAIL PROTECTED]> wrote: > It seems as though I have found kind of an answer to > this problem. “ISS ODBC LOGGING” > Here is a synopsis of the situation: I want ISS > Internet Scanner version 6.21.2001.320 to log to a > MySQL server. I have a ODBC connection to this MySQL > server that I have setup and I have verified that it > works. > When I launch ISS click on Tools > Database > Administration > New DSN > Then either select and > existing ODBC data source only shows the .mdb data > source files not the MySQL one. If you do a create > new > data source I don't have the opportunity to specify > the login, password, database, hostname, port # in > which to use to configure ISS to use MySQL. > > I stopped looking around the iss.net site, and > started > to look for a solution that would allow me to go > from > Access to MySQL. I found out that you can do this > from > within Access, but you have to do this table by > table. > Click on the table that you want to export and then > click File > export from the export window scroll to > the bottom of the list and select ODBC data another > window will pop up that will ask you the table in > which you want to export to, then click on the user > or > system DSN that you created and click ok. This will > export the table to the database that you setup in > the > ODBC properties. Do note however that I have found > this to be a one-way street if the table is already > defined the export fails, so if the table has not > been > defined then it will create the table for you > > I hope that this little tid bit will possibly help > any > of you wishing to accomplish something similar. > > JC > > --- William Holmberg <[EMAIL PROTECTED]> > wrote: > > Interesting! I'll pass this on to our guy and see > if > > he has more for > > you, but it sounds like you found a "soft spot"... > > Best of Luck, > > Bill > > > > -----Original Message----- > > From: JC [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, December 18, 2001 4:44 PM > > To: William Holmberg; > > [EMAIL PROTECTED]; > > [EMAIL PROTECTED] > > Subject: RE: ODBC logging via ISS Internet Scanner > > > > > > > Hi Again, > > > > Thanks for the info, but I already did that. I > have > > a > > DSN called mysql that points to my linux mysql > > server. > > I have a perl script that I wrote that I've used > to > > verify that the DSN is working and I do have > access > > and sufficient rights to do insert,select and the > > like. > > > > I am using ISS Internet Scanner 6.21.2001.320. > When > > I > > launch ISS click on Tools > Database > Administration > > > > > New DSN > Then either select and existing ODBC > data > > source only shows the .mdb data source files not > the > > MySQL one. If you do a create new datasource I > don't > > have the opportunity to specify the login, > password, > > database, hostname, port # in which to use to > > configure ISS to use MySQL. > > > > I want to log to a single MySQL server through an > > ODBC > > connection that I have already established and > > verified that works. I understand that I may be > > required to duplicate the schema on the MySQL > server > > I > > have no problem with that. I'm not looking for a > > product that has all of these fancy bells and > > whistles > > that my company would have to pay for. > > > > There was a mention of a utility that can output > to > > a > > .csv file where I would need to do a bulk copy > into > > MySQL that's fine too. Since I don't have the > > installation CD I've looked for db2u and I didn't > > find > > it on the local system or on the web (google > wasn't > > good to me this time). > > > > > > > > Thanks again > > > > JC > > > > __________________________________________________ > > Do You Yahoo!? > > Check out Yahoo! Shopping and Yahoo! Auctions for > > all of > > your unique holiday gifts! Buy at > > http://shopping.yahoo.com > > or bid at http://auctions.yahoo.com > > > __________________________________________________ > Do You Yahoo!? > Check out Yahoo! Shopping and Yahoo! Auctions for > all of > your unique holiday gifts! Buy at > http://shopping.yahoo.com > or bid at http://auctions.yahoo.com > __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com
