ODBC uses ip address to connect to database and it does connect. -----Original Message----- From: Döhr, Markus ICC-H [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 2:03 PM To: Scott Miller; maxdb@lists.mysql.com Subject: RE: MaxDB and Access
> One current issue is this. Using Access as the front end and > ODBC it takes a long time to open an attached MaxDB table and > a table with only 5 records in it takes minutes to delete one > record. Is this an ODBC problem a MaxDB problem. What can I > do to fix this. I want to continue to use the application I > have with an Access 2003 front end. It can be on either > client machines or the 2003 server. In either case it must > link to the MaxDB tables and work with acceptable speed. [...] Is you name resolution work in both directions? Means, can the server reverse lookup the name of the IP address that is connecting? Check on your local system (with Access): # nslookup <ip address of server> This should give you the servers name. Try the same thing on the server for the IP-Addresse of your machine. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.6/286 - Release Date: 3/20/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.6/286 - Release Date: 3/20/2006 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]