AW: MyODBC driver window keeps popping up...

[Frank Hacker]

Hi Gert!

Thanks for the very, very excellent tip - worked just great!

Now I can start on the PHP coding :-))

Bye!

Frank Hacker (hacker@stripped)
EDV Abteilung / IT Dept.
Gebr. Reinfurt Wuerzburg
Miniaturkugellager
Gneisenaustr. 10-11
97074 Wuerzburg
Germany
Tel.: [phone]
Fax: [phone]
Internet: www.grw.de

> -----Ursprüngliche Nachricht-----
> Von:	Hof, Gert van 't [SMTP:hof@stripped]
> Gesendet am:	Donnerstag, 22. März 2001 08:26
> An:	'Frank Hacker'; 'mysql@stripped'
> Cc:	'myodbc@stripped'
> 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:hacker@stripped]
> > Sent:	Thursday, March 22, 2001 8:17 AM
> > To:	'mysql@stripped'
> > Cc:	'myodbc@stripped'
> > 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 (hacker@stripped)
> > EDV Abteilung / IT Dept.
> > Gebr. Reinfurt Wuerzburg
> > Miniaturkugellager
> > Gneisenaustr. 10-11
> > 97074 Wuerzburg
> > Germany
> > Tel.: [phone]
> > Fax: [phone]
> > Internet: www.grw.de
> > 
> > 
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail myodbc-thread2959@stripped
> > 
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail myodbc-unsubscribe@stripped instead.