SQLTables() is not a valid MS SQL function. If I can verify that this will
work with other db's, I can query the ODBC driver and use that function
accordingly.
Thanks,
Chris
----------------------------------------------
Original Message
From: "S�bastien Riccio"<[EMAIL PROTECTED]>
Subject: Re: [IMail Forum] IMail DB -> mysql
Date: Tue, 11 Apr 2000 02:59:51 +0200
>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/
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.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/
