Scott allowed me to see first-hand the problem Scott is describing. He is not having connection difficulties at all. The problem is that a simple single-row delete query on a 5-row table with a primary key takes over a minute to complete when executed through Microsoft Access. There are no other users connected at the time, so this is not the result of the row being locked by another process. It simply takes that long to delete. The same query, when executed through SQLStudio, is nearly instantaneous.
For my part, I have never experienced this problem when executing queries through Access. The most significant difference I've noted between our environments is that our database runs on a 32-bit Linux server, whereas Scott's is 64-bit Windows. "Henrik Hempelmann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > On 25.03.2006, at 20:08, Scott Miller wrote: > >> ODBC uses ip address to connect to database and it does connect. > > > ... and? > How long does it take to get a negative answer for resolving the name of > this IP-address? > > Henrik > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
