Posted by Dan Guzman on 12/17/05 05:44

> 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?
>

[Back to original message]