469,898 Members | 1,613 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

ODBC & Remote SQL Server

Hello,

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

Please, guide me.

Bye.

Sep 18 '07 #1
1 4440
On Sep 18, 10:07 am, pradeep <pwprad...@gmail.comwrote:
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

Sep 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mike Malter | last post: by
2 posts views Thread by Tor Inge Rislaa | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.