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
