Re: Multiple Apps on System DSN on Server from One PC

> Should I use the same Active-X server for the same in a MS SQL Server
> DSN connection or is it ok to have multiple apps from the same pc using
> the DSN?

You don't need the ActiveX work-around for SQL Server. Unlike Access (Jet),
SQL Server is a true multi-user DBMS designed for many concurrent users.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<walt@xxxxxxxxxxxxxxxxx> wrote in message
news:1134740489.464374.245040@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> A few years ago I wrote an active-X server to maintain a single
> connection to a file .mdb from multiple apps on same PC because I was
> having to many database curptions.
>
> Should I use the same Active-X server for the same in a MS SQL Server
> DSN connection or is it ok to have multiple apps from the same pc using
> the DSN?
>


.

Relevant Pages

  • GUID not allowed in Find Method
    ... We are currently are using Access 2003 and going to start using SQL Server ... DSN connection The connection seems to work fine and for the most part the ... ' Find the record that matches the control. ... The value of me!has the correct guid information ...
    (microsoft.public.access.adp.sqlserver)
  • Ole connection not open sql server
    ... i am using CR 8.0 and vb 6.0 and data base is sql server 2000 my application ... work fine with DSN connection and with ole connection the report is not ...
    (microsoft.public.vb.crystal)
  • DSN connection fails when Basic authentication turned on
    ... When I switch on Basic Authentication, ... that pull information from the SQL server fail to make the ... DSN connection with the following message:- ...
    (microsoft.public.inetserver.iis.security)
  • Re: How to set the network protocol using dsnless connection to SQL Se
    ... If you check the string value of a DSN connection with SQLGETPROP(lnConn, ... with MS SQL Server. ... When I'm using ODBC System DSN, ...
    (microsoft.public.fox.helpwanted)
  • Multiple Apps on System DSN on Server from One PC
    ... Should I use the same Active-X server for the same in a MS SQL Server ... DSN connection or is it ok to have multiple apps from the same pc using ...
    (comp.databases.ms-sqlserver)
Loading