| Author |
Topic |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-02-19 : 18:58:58
|
| Actually i have linked server in SQL 2000 with Provider:Microsoft OLEDB for ODBC which is working perfectly fine. I don't know the password for this linked server too.Now i want to create same linked server with same provider in SQL server 2005 for Microsoft oledb for ODBC but they don't have this provider in 2005. How can i make it to work.ANy expert who knows this.and how to use same password in linkedserver in 2005 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 22:33:47
|
| Does the server have proper mdac installed? My sql2k5 servers have that provider. For password, you can reset it if you have sysadmin rights. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-19 : 22:39:55
|
| Thanks rmaio.In linker server properties in 2005: i don't see provider: microsoft oledb for ODBC. so i should install MDAC. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-19 : 22:42:51
|
| ok .I see now. How can i know old password used in SQL server 2000 linked server bcoz of application issues(it uses sql login and password) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 22:46:36
|
| Only way is asking around. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-20 : 16:03:01
|
| I don't see Provider: Microsoft oledb for ODBC in linked server in 64-bit SQL server in 64-bit OS. What should i do? I have 4-5 servers ODBC to be linked. Please help |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-20 : 23:08:17
|
| What's target data source? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-20 : 23:54:55
|
| ODBC drivers |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 15:30:19
|
| For access? Or excel? Or Oracle? Or .... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-21 : 16:18:54
|
| its Microsoft oledb for ODBC drivers |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 16:24:12
|
| I know that, but what does odbc dsn point to? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-21 : 16:38:16
|
| Tandem. Its old mainframe system from HP. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 17:48:31
|
| Does it have 64-bit odbc driver? |
|
|
|
|
ODBC problems in linked server in SQL server 2005