Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
romy
Starting Member
6 Posts |
 Posted - 2007-04-25 : 12:04:26
|
| Hi, I am new to SQL Server. I want to connet to SQL Server database and fetch records. SQL Server will be present in some other server. For connecting to SQL Server is it necessary to create DSN. Is it possibel to connect to SQL Server with out DSNI want following parameters are enough for opening connetion are not:MyConnObj.Open _ "Provider = sqloledb;" & _ "Data Source=172.16.1.60;" & _ "Initial Catalog=TESTATV;" & _ "User ID=sa;" & _ "Password=p@ssW0rd;" As per my assumptionData Source is your server nameInitial Catalog is your database nameplease clarify me on this.thanks |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-25 : 12:06:37
|
| Yes that should be fine. DSN is not necessary.Check out: [url]http://www.connectionstrings.com/?carrier=sqlserver[/url] for different examples of connection strings.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
romy
Starting Member
6 Posts |
Posted - 2007-04-25 : 21:17:18
|
| Hi,Thanks for your reply.I need one more clarification. My SQL database does not reisdes in my system it resides in some other system is any other parameter I have to send like via TCP/IP. please clarify me on this.Thanks |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-26 : 00:06:35
|
| No. Specifying network protocols is not part of connection string. You can configure it through Server Network Utility.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 12:00:31
|
| You mean client network utility? Should be ok as long as sql port is open between two machines. |
|
|
|
|
|
|
Sql Server connectivity - parameters