CODEWITHSUNDEEP
sql-serverodbccognos
Victor
Victor

Reputation: 17107

Why do we need to define odbc connection to connect to sql server(but not always)

When i open up sql server management studio and make a connection to an sql server database, it connects fine. But when i try to define a connection to the same sql server in cognos administration, andthen try to test the connection through the local framework manager, it says connection failed. And I need to define an odbc connection in my control panel for it to work. So my question is..why sql server management studio does not need odbc connection, but cognos needs it? I have also heard that ms access needs it.

Upvotes: 2

Views: 532

Answers (1)

chsh
chsh

Reputation: 2414

It depends on the type of Data Source you're creating in Cognos Administration. If you select ODBC as the data source type, it will attempt to use ODBC to connect. You probably want to select the appropriate SQL Server data source type.

Upvotes: 1

Related Questions