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/
