We have an end user that has installed our application on a Mac we use the ElevateDB ODBC driver.  It runs fine on the MAC.  When I try to connect a "client" using the odbc.dll file it gives the error message

Their exact error message is Column Not Found Acc_Recid
The io file says something along the lines of: error #1100 Socket error. A connection to (IPAddress) could not connect because it actively refused it.


We've checked all the usual connectivity suspects, i.e. firewall.  We've done everything we usually do on a Windows Server.  Is there any other reason we would get this error when trying to use Windows OS for our "clients" and the MAC for our server?

<< Their exact error message is Column Not Found Acc_Recid
The io file says something along the lines of: error #1100 Socket error. A
connection to (IPAddress) could not connect because it actively refused it.

We've checked all the usual connectivity suspects, i.e. firewall.  We've
done everything we usually do on a Windows Server.  Is there any other
reason we would get this error when trying to use Windows OS for our
"clients" and the MAC for our server? >>

Okay, so is the Mac running the *client* application, or the EDB Server ?
If the former, then where is the EDB Server located, or is it being used at
all ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

The Mac is using the EDB Srvr and we have just installed it to C:\Program Files (x86)\Company Name\Application Name\svr\

all the clients are running a Microsoft Windows OS and they get the #1100 error.

> Is there any other reason we would get this error when trying to use
> Windows OS for our "clients" and the MAC for our server?

Are you trying to connect using a hostname or a IP address?  If using a
hostname, ping the hostname from the Windows client and compare it against
the IP address of the system with the server.

We've had a fair number of situations where the DNS lookup on one system is
returning a IP address that is completely different than the actual IP
address of the server.  So when the client attempts to connect using the
hostname it fails because it's ending up at the wrong place.

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com
---------------------------------------

<< The Mac is using the EDB Srvr and we have just installed it to C:\Program
Files (x86)\Company Name\Application Name\svr\

all the clients are running a Microsoft Windows OS and they get the #1100
error. >>

Thanks.  My advice would be the same as Terry's - you need to make sure that
you're:

1) Connecting to the correct IP address for the ElevateDB Server.
2) That the OS/machine hosting the ElevateDB Server is not blocking requests
via a firewall, etc.

Can you connect via 127.0.0.1 from your application running under Parallels
on the same Mac machine as the ElevateDB Server ?

Tim Young
Elevate Software
www.elevatesoft.com