Re: How to detect a running SQL Server from Access?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vincent Verheul (Email_at_nospam.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 05:31:31 +0100

Hello Dan,

Thanks a lot! The advantage of the link that you provided is that it's not
using the SQLDMO library that usually is not present on the machine of user.
I'll have to get to the office to test it since I do not have access to the
domain right now.

Vincent

"Dan Artuso" <dartuso@NSpagepearls.com> wrote in message
news:eYAX9dX4EHA.1204@TK2MSFTNGP10.phx.gbl...
> Hi,
> My advice to you is to google on this:
> "visual basic" list available sql servers
>
> You'll get tons of hits. Most code will use the SQLDMO library
> but here is a link to VB sample program which uses NetServerEnum
> but wrapped up in a class. I don't know your coding level but it may help.
>
> http://www.codeproject.com/useritems/listsqlservers.asp
>
> --
> HTH
> Dan Artuso, Access MVP
>
>
> "Vincent Verheul" <Email@nospam.com> wrote in message
news:cpkjft$9pc$1@reader08.wxs.nl...
> > Hi!
> >
> > I have an Access Front-End that can both use an Access Back-End as well
as a
> > SQL Server database. I use VBA with the DAO library. To connect to the
SQL
> > Server I use a ODBC connection.
> >
> > I'm looking for VBA logic to detect any running SQL Server instances
that a
> > user can select. This is to avoid a long 'hang-up' period that occurs
when a
> > SQL Server is specified that does not exist or is off-line.
> >
> > I tried the ODBCtimeout property of a QueryDef but that does not seem to
> > help when the SQL Server is off line.
> >
> > Any ideas?
> >
> > Thanks,
> > Vincent
> >
> >
>
>

Relevant Pages

  • RE: SQL Server 2005 faulure when updating to SP1
    ... The exact version of the SQL server 2005. ... Microsoft Online Partner Support ... Good Morning Vincent, ... Configuring ACL: ...
    (microsoft.public.sqlserver.setup)
  • Re: Silly question
    ... Matjaz Ladava, MCSE (NT4 & 2000) ... "Vincent" wrote in message ... > encrypt it before sending the information to SQL Server? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: WSS 3.0 Search Error
    ... \par Are these two server (WSS and SQL server) in different domain? ... Or there is some proxy/gateway/firewall between them? ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: I have lost the SA password
    ... > I need the SA password to access a SQL Server. ... > Is there a way to retrieve it (freeware, script,...) ... > Thanking you in advance ...
    (microsoft.public.sqlserver.security)
  • Re: function as criteria for a query
    ... Write the value to a table with a single record in SQL Server. ... > I have created a public variable called "userId" it stores the user id ... > Public Function fnUserId() ... >> MS Access MVP ...
    (microsoft.public.access.queries)