Author Topic: how to connect ms sql server database use cognos in linux  (Read 1051 times)

Offline tome_che

  • Associate
  • **
  • Join Date: Apr 2017
  • Posts: 4
  • Forum Citizenship: +0/-0
Hello everyone:

How to  connect  ms sql server database use  cognos  in linux, when I finish  copy jdbc driver , it report an error like :http://www-01.ibm.com/support/docview.wss?uid=swg21497810 ,     my  "microsoft sql server ole db" driver can not work ,  is ole db has a dirver in
linux, thank you!

Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,740
  • Forum Citizenship: +586/-9
  • Cognos Software Muppet
Re: how to connect ms sql server database use cognos in linux
« Reply #1 on: 11 Apr 2017 02:47:27 am »
Hello everyone:

How to  connect  ms sql server database use  cognos  in linux, when I finish  copy jdbc driver , it report an error like :http://www-01.ibm.com/support/docview.wss?uid=swg21497810 ,     my  "microsoft sql server ole db" driver can not work ,  is ole db has a dirver in
linux, thank you!

Hi,

Can you explain how you are trying to connect to SQL Server? You mentioned in your post that you have copied the jdbc driver, but the page you link to for the error shows a message from UDA (Compatible Query Mode) not XQE (Dynamic Query Mode). All JDBC data source connections are Dynamic Query Mode, so it looks to me like you're trying to set up a connection that uses the SQL Server Native Client to connect, rather than JDBC?  Can you detail how you have set up your connection?

MF.
Meep!

Offline tome_che

  • Associate
  • **
  • Join Date: Apr 2017
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: how to connect ms sql server database use cognos in linux
« Reply #2 on: 19 Apr 2017 08:45:03 pm »

 I just copy  64  bit ojdbc4.jar to c10_location\webapps\p2pd\Web-Inf\lib directory ,my client is 32 bit ,is that any provlem ? Thank you!

Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,740
  • Forum Citizenship: +586/-9
  • Cognos Software Muppet
Re: how to connect ms sql server database use cognos in linux
« Reply #3 on: 20 Apr 2017 02:50:29 am »
I just copy  64  bit ojdbc4.jar to c10_location\webapps\p2pd\Web-Inf\lib directory ,my client is 32 bit ,is that any provlem ? Thank you!

The important question is how exactly you are trying to configure your data source connection in the Cognos Administration console. Can you detail the steps you took? I suspect you are using the wrong connection type?

MF.
Meep!

 


       
Twittear