Microsoft SQL Server forum - Multiple Apps on System DSN on Server from One PC

Author

Multiple Apps on System DSN on Server from One PC

walt@clubknowledge.com

2005-12-16, 9:23 am

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?

Dan Guzman

2005-12-17, 3:23 am

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

Sponsored Links