I was wondering if anyone has created a MapBasic script to automate an ODBC
connection
and .tab file creation from a SQL Server database table? I'm looking to
accomplish the following:
- select a previously created .dsn file for a SQL 2000 database
- establish an ODBC connection with the database
- select specific tables (complete table or partial table)
- convert specific tables into .tab files
Basically, it would automate the available DBMS wizard in MapInfo to work on
pre-defined database tables. We would be running the script several times a
day and it would save time having to use the wizard each time.
If anyone has a script that could be modified/tweaked for our own uses,
could you please contact me. Any assistance would be great (I'm a novice
with MapBasic).
Thanks,
Nathan
Nathan J. Badger, VP Technology
eReal Estate Integration
(t) 805.492.2853
(e) [EMAIL PROTECTED]
