Hi!
How do I keep the MyODBC driver window (labeled "TDX mysql Driver connect")
from being displayed when I connect to MySQL via ODBC?
This behaviour makes it impossible to automate the task of updating a MySQL
Database from an Access 97 Database via ODBC using a Macro in Access, since
the window pops up and waits for someone to press the OK button before the
macro can continue. I have checked the option for "don't prompt on
connect" without success. I have also tried to pass "OPTION=16" along with
the DSN-connect string, also without success.
Is there any way to do this?
Our setup: NT 4.0 SP5, mysql-3.23.35-win, myodbc-2.50.36-nt, MS-DAC 2.5,
Access 97 SP2
We have an Access database that contains all the info to our technical
drawings, which I would like to extract and display on a web-page in our
intranet (LAMP) - I wasn't able to get ODBC under Linux to work, so I
installed MySQL under NT and exported the Access tables to MySQL. These
tables change constantly, so the export also must be performed at least
daily, and most important, automatically at night.
For this purpose I wrote a batch file like this:
net stop mysql
delete old mysql tables
net start mysql
call access with parameter /x macro-name
The Access-macro has exactly 3 commands and looks like this (in German,
since its German NT and Access -- hope that's not a problem :-))
Aktion: TransferDatenbank
Transfertyp: Exportieren
Datenbankformat: ODBC-Datenbank
Datenbankname:
ODBC;DSN=Zeichnungen;DB=Zeichnungen;SERVER=edv;PORT=;OPTION=16;STMT=;;TA
BLE=documents
Objekttyp: Tabelle
Quelle: documents
Ziel: documents
Nur Struktur: Nein
Aktion: TransferDatenbank
Transfertyp: Exportieren
Datenbankformat: ODBC-Datenbank
Datenbankname:
ODBC;DSN=Zeichnungen;DB=Zeichnungen;SERVER=edv;PORT=;OPTION=16;STMT=;;TA
BLE=files
Objekttyp: Tabelle
Quelle: files
Ziel: files
Nur Struktur: Nein
Aktion: Verlassen
Optionen: Beenden
Everything actually works surprisingly well, except for this problem with
the popup window... it would be really great if there was a solution for
this...
Thanks in advance!
Ciau...
--
Frank Hacker ([EMAIL PROTECTED])
EDV Abteilung / IT Dept.
Gebr. Reinfurt Wuerzburg
Miniaturkugellager
Gneisenaustr. 10-11
97074 Wuerzburg
Germany
Tel.: +49 (0) 931 7952 354
Fax: +49 (0) 931 7952 300
Internet: www.grw.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
