Pass-Through, Default DSN?

From: Gerard (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 10:02:58 -0700

Les,
    When you right click on the query and go to
Properties, it only brings up a tab for "General"
properties, is there something I'm missing?

Gerard - GMS

>-----Original Message-----
>In the properties of the pass-thru query, you can set the
>dsn information.
>
>ODBC;DATABASE=yourdatabase;UID=yourid;PWD=yourpwd;DSN=DSNn
a
>me
>>-----Original Message-----
>>Hey all,
>> I am running Access 2k on Win 2k with SQL Server
2k.
>>I am converting my companies Access database to SQL
>>Server. In the meantime while I develop the VB
>>application, we are using the Access database
application
>>as a front end to connect to SQL Server. I made a Pass-
>>Through query so it connects to the ODBC to run the
>query,
>>instead of running it against the MSJet. This method is
>>much faster with one small exception. Every time the
>>query runs, a dialog pops up asking what DSN to connect
>>to. I want to eliminate that dialog. Is there a way to
>>specify a default DSN or something similar, so this
>dialog
>>doesn't pop up every time. As always, I appreciate all
>>the help in advance.
>>
>>Gerard - GMS
>>Programmer / Processor
>>
>>P.S. I have a box of recycled bits for the best post ;)
>>.
>>
>.
>

Relevant Pages

  • re: Stop me before I use DSN again!
    ... >site to my home server that has no such DSN defined. ... >from a query that uses a linked table, ... Set cnNwind= Server.CreateObject ...
    (microsoft.public.frontpage.client)
  • Re: Word 2003 MailMerge with SQL Server 2000 problem
    ... I have always found that the OLEDB provider seems to be more picky ... Personally I wouldn't use the 1=1 workaround on the grounds that the query ... SQL Server does but I once did this with Oracle to get around some problem ... Dim dsn As String ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2003 MailMerge with SQL Server 2000 problem
    ... Okay, I switched the way I was connecting, and started using a DSN ... If I could either create a DSN-less connection string for Mail Merge, ... Personally I wouldn't use the 1=1 workaround on the grounds that the query ... SQL Server does but I once did this with Oracle to get around some problem ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Running ODBC query through Access on multiple databases
    ... do was take out the <libname>, define the libname in the DSN definition and ... Now, I think I still need to define 50 DSN definitions, one ... You do not have to link to tables you are using in a Pass-Thru query. ... I appreciate the weblinks on connection strings. ...
    (microsoft.public.access.queries)
  • Re: Stop me before I use DSN again!
    ... > home server that has no such DSN defined. ... > tables, etc., and the fact that it's drawn from a query that uses a ... > the drw is finished). ...
    (microsoft.public.frontpage.client)