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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Important Question

Author  Topic 

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-30 : 15:28:25
I am given to install ODBC drivers in two servers and main thing is they are clustered . SO do i have to install in both servers or CLuster will configure that. Urgent help please . Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-30 : 15:31:30
The cluster will not handle this. But are you sure you need to install it on the nodes? Usually these get installed on the client machines or application servers.

What exactly is going to use the ODBC data sources?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-30 : 15:35:19
Its a two node clustered node. I am installing in one node.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-30 : 15:41:15
You haven't answered my questions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-30 : 15:41:54
ODBC for openlink Tara
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-30 : 15:43:52
That doesn't answer the question as to what is going to be using the data source. You've only told us what the ODBC driver is, but not what is calling it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-30 : 15:45:23
Only i want to know is whether i have to install in one or both.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-30 : 16:12:14
Once you answer my question, I'll be able to tell you what you need to do. As you can see from your recent threads, providing bare minimum information is not helping us help you.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-11-30 : 16:17:11
Tara is right. Tell us/her what is going to be using the ODBC connection. Most likely it doesn't need to be installed on the SQL Server. If an app is using the ODBC connection, then the ODBC driver(s) need to be on the web server or client machines since they use the ODBC driver to connect to the database from the app. The app itself should not reside on the SQL Server correct? So tell us what is using the ODBC connection and where it's calling the ODBC connection from.
Go to Top of Page
   

- Advertisement -