[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: odbc slow on Win XP
From:       artem () w510 ! com ! ua
Date:       2004-07-23 20:17:18
Message-ID: 1090639313.22060 () w510 ! com ! ua
[Download RAW message or body]

Hello Max,

have also winxp slow problem - mostly slow opening of datagrids
i use ini file and on winxp machines set something like NoSetLocale=1
then in client program build special connection string

    Dim nNoSetLocale As Long
    nNoSetLocale = GetPrivateProfileInt("client", "NoSetLocale", 0, "c:\charter.ini")
    If nNoSetLocale > 0 Then
        m_sConnStr = "DRIVER={MySQL ODBC 3.51 Driver};" _
                & "SERVER=" & sMySQLServerIP & ";" _
                & "DATABASE=idb_test;" _
                & "UID=ccc;" _
                & "PWD=aaa;" _
                & "OPTION=" & 1 + 2 + 256
    Else
        m_sConnStr = "DRIVER={MySQL ODBC 3.51 Driver};" _
                & "SERVER=" & sMySQLServerIP & ";" _
                & "DATABASE=idb_test;" _
                & "UID=ccc;" _
                & "PWD=aaa;" _
                & "OPTION=" & 1 + 2
    End If



M> Hi,
M> I have mysql running on linux red hat + samba 2.0
M> I have also several clients, win98, 2000 and XP.
M> They all use an access database with mysql tables linked in it via odbc 2.5
M> (system dsn).
M> One XP client was very slow, so I suggested to copy access DB from samba
M> server to desktop and performance improved, even if I really don't know why.
M> The same thing on other XP client give me no result, so for istance, open a
M> form that show a long list, request about 30 sec (win2k and 98 request 3
M> sec!).

M> I also tried to change odbc driver to 3 with no result.
M> What else can I do?





-- 
Best regards,
 Artem                            mailto:artem@w510.com.ua







-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]