List:General Discussion« Previous MessageNext Message »
From:Frank Hacker Date:March 22 2001 7:17am
Subject:MyODBC driver window keeps popping up...
View as plain text  
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 (hacker@stripped)
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
Thread
• MyODBC driver window keeps popping up...Frank Hacker22 Mar