From: Date: March 22 2001 11:06am
Subject: AW: MyODBC driver window keeps popping up...
List-Archive: http://lists.mysql.com/mysql/69173
Message-Id: <01C0B2C0.360954A0.hacker@grw.de>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=_IS_MIME_Boundary"

--=_IS_MIME_Boundary
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.: +49 (0) 931 7952 354
Fax: +49 (0) 931 7952 300
Internet: www.grw.de

> -----Urspr=FCngliche Nachricht-----
> Von:	Hof, Gert van 't [SMTP:hof@stripped]
> Gesendet am:	Donnerstag, 22. M=E4rz 2001 08:26
> An:	'Frank Hacker'; 'mysql@stripped'
> Cc:	'myodbc@stripped'
> Betreff:	RE: MyODBC driver window keeps popping up...
>=20
> Hi
>=20
> 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.
>=20
> Regards
> Gert
>=20
>=20
> > -----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...
> >=20
> > Hi!
> >=20
> > How do I keep the MyODBC driver window (labeled "TDX mysql Driver
> > connect")=20
> > from being displayed when I connect to MySQL via ODBC?
> >=20
> > This behaviour makes it impossible to automate the task of updating =
a
> > MySQL=20
> > Database from an Access 97 Database via ODBC using a Macro in =
Access,
> > since=20
> > the window pops up and waits for someone to press the OK button =
before the
> >=20
> > macro can continue.  I have checked the option for "don't prompt on=20
> > connect" without success.  I have also tried to pass "OPTION=3D16" =
along
> > with=20
> > the DSN-connect string, also without success.
> >=20
> > Is there any way to do this?
> >=20
> > Our setup:  NT 4.0 SP5, mysql-3.23.35-win, myodbc-2.50.36-nt, MS-DAC =
2.5,=20
> > Access 97 SP2
> >=20
> > We have an Access database that contains all the info to our =
technical=20
> > drawings, which I would like to extract and display on a web-page in =
our=20
> > intranet (LAMP) - I wasn't able to get ODBC under Linux to work, so =
I=20
> > installed MySQL under NT and exported the Access tables to MySQL.  =
These=20
> > tables change constantly, so the export also must be performed at =
least=20
> > daily, and most important, automatically at night.
> >=20
> > For this purpose I wrote a batch file like this:
> >=20
> > net stop mysql
> > delete old mysql tables
> > net start mysql
> > call access with parameter /x macro-name
> >=20
> > The Access-macro has exactly 3 commands and looks like this (in =
German,=20
> > since its German NT and Access -- hope that's not a problem :-))
> >=20
> > 	         Aktion: TransferDatenbank
> > 	    Transfertyp: Exportieren
> > 	Datenbankformat: ODBC-Datenbank
> >         Datenbankname:=20
> > =
ODBC;DSN=3DZeichnungen;DB=3DZeichnungen;SERVER=3Dedv;PORT=3D;OPTION=3D16;=
STMT=3D;;TA =20
> > BLE=3Ddocuments
> > 	      Objekttyp: Tabelle
> > 	         Quelle: documents
> > 	           Ziel: documents
> > 	   Nur Struktur: Nein
> >=20
> > 	         Aktion: TransferDatenbank
> > 	    Transfertyp: Exportieren
> > 	Datenbankformat: ODBC-Datenbank
> >         Datenbankname:=20
> > =
ODBC;DSN=3DZeichnungen;DB=3DZeichnungen;SERVER=3Dedv;PORT=3D;OPTION=3D16;=
STMT=3D;;TA =20
> > BLE=3Dfiles
> > 	      Objekttyp: Tabelle
> > 	         Quelle: files
> > 	           Ziel: files
> > 	   Nur Struktur: Nein
> >=20
> > 	         Aktion: Verlassen
> > 	       Optionen: Beenden
> >=20
> > Everything actually works surprisingly well, except for this problem =
with=20
> > the popup window... it would be really great if there was a solution =
for=20
> > this...
> >=20
> > Thanks in advance!
> >=20
> > 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
> >=20
> >=20
> > =
---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" =
before
> > posting. To request this thread, e-mail =
myodbc-thread2959@stripped
> >=20
> > 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.
--=_IS_MIME_Boundary--