Anybody know how to solve the Same Problem in Access 2K ?
Cheers
Chris
>===== Original Message From Frank Hacker <[EMAIL PROTECTED]> =====
>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.
>
>
>---------------------------------------------------------------------
>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.
This message is sent in confidence for the addressee only. It may contain
privileged information. The contents are not to be disclosed to anyone other
than the addressee. Unauthorised recipients are requested to preserve this
confidentiality and to advise us of any errors in transmission. Thank you.
Thank you.
---------------------------------------------------------------------
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
