Pass-Through, Default DSN?
From: Les (anonymous_at_discussions.microsoft.com)
Date: 04/29/04
- Next message: Donna: "dec2hex"
- Previous message: Allen Browne: "Re: dec2hex"
- In reply to: Gerard: "Pass-Through, Default DSN?"
- Next in thread: Gerard: "Pass-Through, Default DSN?"
- Reply: Gerard: "Pass-Through, Default DSN?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 09:48:27 -0700
In the properties of the pass-thru query, you can set the
dsn information.
ODBC;DATABASE=yourdatabase;UID=yourid;PWD=yourpwd;DSN=DSNna
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 ;)
>.
>
- Next message: Donna: "dec2hex"
- Previous message: Allen Browne: "Re: dec2hex"
- In reply to: Gerard: "Pass-Through, Default DSN?"
- Next in thread: Gerard: "Pass-Through, Default DSN?"
- Reply: Gerard: "Pass-Through, Default DSN?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
