Hi Gert! Thanks for the very, very excellent tip - worked just great! Now I can start on the PHP coding :-)) Bye! 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 > -----Ursprüngliche Nachricht----- > Von: Hof, Gert van 't [SMTP:[EMAIL PROTECTED]] > Gesendet am: Donnerstag, 22. März 2001 08:26 > An: 'Frank Hacker'; '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > Betreff: RE: MyODBC driver window keeps popping up... > > Hi > > When i create a ODBC-DSN, there are fields where i can fill in a user name > and password. When i filled these in, excel (and Delphi) don't ask for > usernames/passwords. > > Regards > Gert > > > > -----Original Message----- > > From: Frank Hacker [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, March 22, 2001 8:17 AM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject: MyODBC driver window keeps popping up... > > > > 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 > > > > > > --------------------------------------------------------------------- > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before > > posting. To request this thread, e-mail [EMAIL PROTECTED] > > > > To unsubscribe, send a message to the address shown in the > > List-Unsubscribe header of this message. If you cannot see it, > > e-mail [EMAIL PROTECTED] instead.
--------------------------------------------------------------------- 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