[AccessD] Harnessing SQL Server with runtime

John,

If you are using the IP address, you might try adding a comma and 
1433 at the end of the IP address.
That is the port SQL Server. listens on by default.  Change the 1433 
to the port if you have changed the
default.

We found on some connections that we needed to do that before it 
would connect properly. We also
saw that when using the name for the server on some 
connections.  There was no real consistency to
it.

Robert

At 10:29 AM 3/22/2011, you wrote:
>Date: Mon, 21 Mar 2011 12:55:24 -0400
>From: jwcolby <jwcolby at colbyconsulting.com>
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Harnessing SQL Server with runtime
>Message-ID: <4D8782FC.1000300 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>I tried using that (a week or so ago) and it failed, but I am trying 
>to connect to an IP address
>over Hamachi and that failed.  Just changing the server name from an 
>English name to an IP address
>failed.  OTOH I could open a recordset using the IP address and that worked.
>
>There is more to this than meets the eye.
>
>John W. Colby
>www.ColbyConsulting.com