Multiple Apps on System DSN on Server from One PC

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?

> 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@clubknowledge.com> wrote in message
news:1134740489.464374.245040@g44g2000cwa.googlegroups.com...
> 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?
>