Posted by vijay on 09/18/07 10:17

On Sep 18, 10:07 am, pradeep <pwprad...@gmail.com> wrote:
> Hello,
>
> How to create system DSN (ODBC) on windows 2003 for SQL Server located
> on remote machine ?
>
> Please, guide me.
>
> Bye.

Go to control panel-->Click administrative tools --> click data
sources(odbc)

select system DSN tab
1) Click Add
2)provide a name using which you will be refering in name
3) in server column,select or type server name you want to connect
4)provide security details in next page
5)select default database name if you want
6)in next page click Finish
7) you get test screen ,now click Test data source to test the
connection ..if success you are in or else you need to check details

Thanks
VS

• Next in forum: Re: MS SQL compare columns to generate display name
• Prev in forum: Re: MS SQL compare columns to generate display name
• Thread view: Re: ODBC & Remote SQL Server

[Reply to this message]