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
