Sharable DSN ?

P

Peter

When I select the DSN for running MS Query in Excel 97, I
find that for the same DS, there are sharable DSN and not
sharable DSN.

I would like to know
1) What is the difference between them ?
2) Which one should I use in the MS Query ?

Thanks
 
J

Jake Marx

Hi Peter,

I assume that you're referring to 2 different types of DSNs - one is a User
DSN, and the other a System DSN. System DSNs, once created on a computer,
are available to all users that log in to that computer. User DSNs are
available only to a user who has configured the DSN under his/her logon
account.

Which one you use depends on your situation - if it should be available only
to 1 user, then use a User DSN. If any user should be able to use the DSN,
use a System DSN.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
P

Peter

Dear Jake,

Thank you for your reply.

Do you mean that sharable DSN = System DSN and not
sharable DSN = User DSN ?

Thanks
-----Original Message-----
Hi Peter,

I assume that you're referring to 2 different types of DSNs - one is a User
DSN, and the other a System DSN. System DSNs, once created on a computer,
are available to all users that log in to that computer. User DSNs are
available only to a user who has configured the DSN under his/her logon
account.

Which one you use depends on your situation - if it should be available only
to 1 user, then use a User DSN. If any user should be able to use the DSN,
use a System DSN.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

When I select the DSN for running MS Query in Excel 97, I
find that for the same DS, there are sharable DSN and not
sharable DSN.

I would like to know
1) What is the difference between them ?
2) Which one should I use in the MS Query ?

Thanks

.
 
P

Peter

I find that if I uncheck the checkbox "Include Registry
DSNs in the list of available database", it only shows all
database (not sharable).

Thanks
-----Original Message-----
Hi Peter,

I assume that you're referring to 2 different types of DSNs - one is a User
DSN, and the other a System DSN. System DSNs, once created on a computer,
are available to all users that log in to that computer. User DSNs are
available only to a user who has configured the DSN under his/her logon
account.

Which one you use depends on your situation - if it should be available only
to 1 user, then use a User DSN. If any user should be able to use the DSN,
use a System DSN.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

When I select the DSN for running MS Query in Excel 97, I
find that for the same DS, there are sharable DSN and not
sharable DSN.

I would like to know
1) What is the difference between them ?
2) Which one should I use in the MS Query ?

Thanks

.
 
J

Jake Marx

Hi Peter,

That's what I would think, but I'm not 100% sure that is correct. I'm on XL
2002, so the dialogs are a bit different.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Dear Jake,

Thank you for your reply.

Do you mean that sharable DSN = System DSN and not
sharable DSN = User DSN ?

Thanks
-----Original Message-----
Hi Peter,

I assume that you're referring to 2 different types of DSNs - one is
a User DSN, and the other a System DSN. System DSNs, once created
on a computer, are available to all users that log in to that
computer. User DSNs are available only to a user who has configured
the DSN under his/her logon account.

Which one you use depends on your situation - if it should be
available only to 1 user, then use a User DSN. If any user should
be able to use the DSN, use a System DSN.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

When I select the DSN for running MS Query in Excel 97, I
find that for the same DS, there are sharable DSN and not
sharable DSN.

I would like to know
1) What is the difference between them ?
2) Which one should I use in the MS Query ?

Thanks

.
 
J

Jake Marx

Hi Peter,

I think User and System DSNs are both stored in the registry. File DSNs
would not be stored in the registry. Hence, if you uncheck "Include
Registry DSNs", you will be presented only with DSNs whose connection
strings are stored in the file system (file DSNs).

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

I find that if I uncheck the checkbox "Include Registry
DSNs in the list of available database", it only shows all
database (not sharable).

Thanks
-----Original Message-----
Hi Peter,

I assume that you're referring to 2 different types of DSNs - one is
a User DSN, and the other a System DSN. System DSNs, once created
on a computer, are available to all users that log in to that
computer. User DSNs are available only to a user who has configured
the DSN under his/her logon account.

Which one you use depends on your situation - if it should be
available only to 1 user, then use a User DSN. If any user should
be able to use the DSN, use a System DSN.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

When I select the DSN for running MS Query in Excel 97, I
find that for the same DS, there are sharable DSN and not
sharable DSN.

I would like to know
1) What is the difference between them ?
2) Which one should I use in the MS Query ?

Thanks

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top