From: Döhr, Markus ICC-H (Markus.Doehrsiegenia-aubi.com)
Date: Fri Mar 24 2006 - 16:03:05 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

> 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: markus.doehrsiegenia-aubi.com
Internet: http://www.siegenia-aubi.com
  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]