[AccessD] Harnessing SQL Server with runtime

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

On 3/21/2011 11:51 AM, Robert wrote:
> There is a property in the design view, ODBC Connect String.
>
> My local development copy looks something like this:
> ODBC;DRIVER=SQL Server;SERVER=tg9078;UID=sa;PWD=monkey;DATABASE=WWCI_Master_Data
>
> Once that is filled in, you should not get any more hits asking you for that info.
>
> At 09:27 AM 3/19/2011, you wrote:
>> Date: Fri, 18 Mar 2011 08:18:20 -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: <4D834D8C.4040806 at colbyconsulting.com>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> Robert,
>>
>> What specific things have to be done to use the pass-through query?
>>
>> I took a regular query using a table linked to SQL Server and made it pass-through by changing the
>> sql specific to pass through. It immediately asked me for a dsn, and when I gave it one it asked me
>> for the user name / password. But it keeps asking me for the dsn / user name / password any time I
>> do anything with that query or the form that is bound to that query.
>>
>> Am I missing something?
>>
>> John W. Colby
>> www.ColbyConsulting.com