i have install SQL Anywhere 10, with 32bit enable into a windows server 2008 64bit. when i try to create a ODBC using c:\windows\syswow64\odbcad32.exe to connect, it give me error "Found Server but communication error occured", but i try the same setting using c:\windows\system32\odbcad32.exe, test connection successful.

Is there a difference in the DBN parameter values in your first and second sample ("DBN=EPE WebTest" vs. "DBN=E PEWebTes")?

What are the values of the DSN "EPETest"? (Note, you can still supply the same connection string when using DBPING -m, it's not necessary to use a DSN parameter here.) It's difficult to check for differences in the connection process when the connection string paramters may not be identically...

Could you redo the tests with -m both in 64-bit and 32-bit with the added "LOG=..." connection parameter to show the debug output (as in your original posting)?

You need to specify the DSN that you want to test or supply the DRIVER=<driver_name> as part of the connection string. You have indicated previously that the DSN was EPETest so the -c option should look like

-c "DNS=EPETest;UID=EPE;PWD=epe"

assuming that the other parameters (DNC,ENG, etc) are already defined in the DSN.

thank you for the reply. i have tried to uninstall and reinstall SQLA many many times with all the different option. i do check on the 32-bit checkbox when i doing installation. but still the same result. maybe you can help me to give me a more detail step for me to troubleshoot? thanks

Well, according to your client log you have been connected to the database server for a while (see 13:04:14 - 13:06:15), so I'm not sure whether this is an setup issue or not. So you are trying to connect locally from the machine the database server is running on (Not sure why shared memory would not work then)?

Note: 10.0.1.3649 is quite an old v10 EBF, AFAIK the latest released one is 10.0.1.4310, so you might give that a try...