ODBC & Remote SQL Server

[pradeep]

Hello,

How to create system DSN (ODBC) on windows 2003 for SQL Server located
on remote machine ?

Please, guide me.

Bye.

[vijay]

On Sep 18, 10:07 am, pradeep <[e-mail]:

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