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 |
|
iminore
Posting Yak Master
141 Posts |
 Posted - 2006-10-24 : 05:11:16
|
| We run SQL 2000 on one server and Exchange 2003 on another. I want to create a linked server in SQL 2000 that will give me the mail data from Exchange. I've read BOL re Exchange. I don't want to create SQL Mail.Any info or pointers would be appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-24 : 05:21:08
|
| oConn.Provider = "EXOLEDB.DataSource"oConn.Open = "http://myServerName/myVirtualRootName"Peter LarssonHelsingborg, Sweden |
 |
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2006-10-24 : 06:34:29
|
| I don't think I've got the provider installed.How would I find the value for 'myVirtualRootName'? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-24 : 06:37:36
|
| You ask your exchange administrator.Another exampleconn.open "http://servername/mypublicstore"Peter LarssonHelsingborg, Sweden |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Linked server to Exchange 2003
blog thingie: http://weblogs.sqlteam.com/mladenp