Re: Connect to SQL programatically

From: Norman Yuan (nobody_at_nowhere.no)
Date: 08/26/04


Date: Thu, 26 Aug 2004 07:35:38 -0700

Look at CurrentProject.OpenConnection() and CurrentProject.CloseConnection()
methods

"Mark" <anonymous@discussions.microsoft.com> wrote in message
news:054e01c48b32$85b565e0$a501280a@phx.gbl...
>
> I can't find documentation that explains the syntax for
> disconnecting from a SQL Server and connecting to another
> in an Access adp. Can someone let me know where I might
> find this or post an example.
>
> Thanks
>



Relevant Pages

  • Database connection
    ... Can somebody tell me what is the syntax for connecting to a MS SQL Server ... and how I can use the recordset to access the fields? ...
    (microsoft.public.scripting.jscript)
  • Connect to SQL programatically
    ... disconnecting from a SQL Server and connecting to another ... in an Access adp. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)

Quantcast