Windows Forum

Ask something
Discussion Locked

ODBC Source in server

0 helpful
3 replies

by bes7252

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to create an ODBC source that is available network wide. I've created system ones on W2K Professional. I cannot figure out how to create a network on in professional. I'm assuming it's not possible.

Can server do it? Or am I making a wrongassumption about ODBC sources somewhere?

Thanks.
Brian

3 replies

by sergey kovzik

From beginning... ODBC - Open Database Connectivity, this is API. You connect to databases using ODBC drivers. Drivers uses Data Sources to connect to actual Databases. Data Source is compilation of information how to connect to particular database.Three types of DSN: local (for user only), system - for computer, and file - for usage by different users if they have ODBC drivers installed. You need file DSN. This is text file with .dsn extension and you provide it name in ODBC connection. Thereis more information in MSDN or at microsoft.com/odbc

Sincerely, Sergey
Brainbench MVP for Win89 Administration

by bes7252

I really needed to know whether an ODBC source can be made available to more than just users of the PC it's created on. Through more research I'm thinking this must be possible through using a domain (since the user's of the domain are actual users of the server.)

This discussion is closed to new replies.