Re: Open DB using OLE DB

From: Stefan Berglund (keepit_at_in.thegroups)
Date: 05/08/04


Date: Sat, 08 May 2004 15:05:13 -0700

On Mon, 3 May 2004 15:34:56 -0400, "Jeff Johnson [MVP: VB]"
<i.get@enough.spam> wrote:
 in <#Dgk4WUMEHA.1340@TK2MSFTNGP12.phx.gbl>

>
>"Fie Fie Niles" <fniles@wincitesystems.com> wrote in message
>news:%237Yu7oTMEHA.2592@tk2msftngp13.phx.gbl...
>
>> If I am using DSN-less (NO g_adoConn.Properties("Prompt") =
>> adPromptComplete) , is there a way of the user to select the SQL Server
>> database ? Because I will need to assign the Initial Catalog, User ID, and
>> Password for
>
>Make your own form and prompt the user for these values on first run. I'm
>making the assumption that your users are savvy enough to be able to make
>the correct choices when faced with such a request.
>
>I also HIGHLY recommend getting away from user IDs and passwords and using
>Windows Authentication instead, unless Oracle doesn't support it.
>

Jeff-

Have you tried using Windows Authentication with MSDE installed
on XP Home? Just curious as I've only been able to make it work
using mixed mode on XP Home.

---
Stefan Berglund
first shift-minus last a t m s n d o t c o m


Relevant Pages

  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: cannot open database requested in login
    ... Is the connection object using Windows Authentication? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I have a DTS replication which truncates the destination> of one database and copies all the rows from the source> table of another database of same serverin> first step. ...
    (microsoft.public.sqlserver.dts)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... Authentication" or mix both when I install SQL Server 2005? ... for DBA to login to do dabase management in future? ... database to backend and then link all table from front Access database to ... Each user they required Windows Authentication when they open they won ...
    (microsoft.public.sqlserver.security)
  • Re: Trouble connecting to SQL Server express over Peer to Peer network
    ... I have a program that accesses an SQL Server Express database. ... Configuration and I connect using Windows Authentication. ... that have never been connected to the domain, I have an issue connecting. ...
    (microsoft.public.vb.general.discussion)