Yeah i think this may do the trick.
If I had sources of this useful tool I would try to play a little with this.
:-)
Best regards,
Sébastien Riccio
Omicron Web-Services
Place de la Gare 4
1003 Lausanne
Phone: +41-21-3453611
Fax: +41-21-3453611
http://www.web-services.com
----- Original Message -----
From: "Joseph Mann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 5:41 PM
Subject: [IMail Forum] IMail DB -> mysql
> Wouldn't SQLTables() work to gather the name of tables in the current
> catalog or schema. Followed up with SQLColumns() to gather the column
> names to make sure they match what IMail requires. I know that both
> of these functions are ODBC compliant and SHOULD work with access or
> MySQL.
>
>
> --
> Best regards,
> Joe M.
>
>
> Monday, January 15, 2001, 10:01:11 AM, you wrote:
>
> CT> Yea, it is coded for only MS SQL. The reason for that is because
> CT> ExtractUsers creates the db tables if they do not exist. To verify if
a
> CT> table exists, it uses the sysobjects table provided by MS SQL. This
table
> CT> is not present in either MySQL or in Access. If someone knows the
methods
> CT> for detecting the existence of a table in MySQL or Access, let me know
and
> CT> I can make the changes.
> CT> To help you out now, all you have to do is use ExtractUsers to create
> CT> fixed-width text files, then import those into MySQL.
>
> CT> Chris
> CT> ----------------------------------------------
> CT> Original Message
> CT> From: "Sébastien Riccio"<[EMAIL PROTECTED]>
> CT> Subject: [IMail Forum] IMail DB -> mysql
> CT> Date: Mon, 15 Jan 2001 14:37:19 +0100
>
> >>Hello,
> >>
> >>I would like to know if someone got a tool to export all users in Imail
> CT> registry to a MySql database.
> >>
> >>I tried without success the "ExtractUsers" tool listed on IPSwitch
> CT> support utilities, which seems to
> >>be coded only for MS Sql :-(
> >>
> >>HEEEELLLPP :-)
> >>
> >>Best regards,
> >>
> >>Sébastien Riccio
> >>
> >>Omicron Web-Services
> >>Place de la Gare 4
> >>1003 Lausanne
> >>
> >>Phone: +41-21-3453611
> >>Fax: +41-21-3453611
> >>http://www.web-services.com
> >>
> >>
> >>
> >>
>
> CT> _____________________________________________
> CT> Free email with personality! Over 200 domains!
> CT> http://www.MyOwnEmail.com
>
>
> CT> Please visit http://www.ipswitch.com/support/mailing-lists.html
> CT> to be removed from this list.
>
> CT> An Archive of this list is available at:
> CT> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>
>
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
> An Archive of this list is available at:
> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
