I use direct ms sql calls so much that I forgot to consider the odbc
catalog functions (thanks for pointing that out).
If anyone needs this functionality, I will make the changes needed so that
ExtractUsers will work with any ODBC 1.0 complient DB.
Chris
----------------------------------------------
Original Message
From: "Joseph Mann"<[EMAIL PROTECTED]>
Subject: [IMail Forum] IMail DB -> mysql
Date: Mon, 15 Jan 2001 14:07:55 -0500
>
>SQLTables() is an ODBC Catalog function. You would use SQLConnect()
>with the System DSN information then call SQLTables() to determine
>what tables are available in the target data source. You must use
>SQLFetch() to work it's way through the returned information.
>The way it sounds is that you are bypassing ODBC in your app.
>
>--
>Best regards,
>Joe M.
>
>
>Monday, January 15, 2001, 1:13:10 PM, you wrote:
>
>CT> SQLTables() is not a valid MS SQL function. If I can verify that this
will
>CT> work with other db's, I can query the ODBC driver and use that function
>CT> accordingly.
>
>CT> Thanks,
>CT> Chris
>CT> ----------------------------------------------
>CT> Original Message
>CT> From: "S�bastien Riccio"<[EMAIL PROTECTED]>
>CT> Subject: Re: [IMail Forum] IMail DB -> mysql
>CT> 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
>CT> 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
>CT> 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
>CT> 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/
>>>
>
>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/
>
_____________________________________________
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/
