| odbc and dsn [message #102237] |
Tue, 02 April 2002 20:35  |
Radhika
Messages: 12
Registered: June 2001
|
Junior Member |
|
|
Hi all
I would like to know the difference between the user dsn and system dsn. For a www application which is needed.
Please let me know the detailed difference between them.
Also, the technical difference between the oracle odbc and microsoft odbc for oracle dsn apart from the make/propreitaryship difference.
Thanks in advance..
I appreciate
|
|
|
|
| Re: odbc and dsn [message #102245 is a reply to message #102237] |
Wed, 03 April 2002 05:59  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
A user DSN is seen only by the user who created it. A system DSN will/can be used by all users who log into that client.
Microsoft Oracle ODBC is installed with Microsoft Data Access Components (MDAC). It can be used instead of Oracle's client ODBC. Microsoft's ODBC does not support all Oracle data types. When using Oracle's ODBC doing linked tables in Access it will recognize primary keys/indexes and use them. Windows does not. There are more diffs but you get the picture.
|
|
|
|
| Re: odbc and dsn [message #102436 is a reply to message #102237] |
Tue, 04 June 2002 23:13 |
ShankarNarayana
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hi,
There isn't much difference between the User DSN and System DSN. System DSN's and User DSN's differ only in who can access them on the system. For ur application System DSN is required.
Regards
shankar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
