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/
