Author Topic: Have to make multiple connections to ODBC  (Read 245 times)

Offline KeithHartley

  • Associate
  • **
  • Join Date: Oct 2018
  • Posts: 4
  • Forum Citizenship: +0/-0
Have to make multiple connections to ODBC
« on: 18 Oct 2018 06:28:33 am »
On my dev/test system (10.2.2? - Install 10.2.200.32 EN  Build EPANALYST 10.2.200.16) when I open a D-Link which contains a SQL query I am asked for user id and password and the system connects (I know this because I get a message regarding changing to US English), so far so reasonable. However before the D-Link appears I have to repeat the user id password combination and then if I wish to run the update I get asked again!

My current live system asks for the user id and password once for a session.

Any ideas why Analyst doesn't hold onto the connection?

Offline sdf

  • Statesman
  • ******
  • Join Date: Feb 2014
  • Posts: 476
  • Forum Citizenship: +3/-0
Re: Have to make multiple connections to ODBC
« Reply #1 on: 18 Oct 2018 07:33:08 am »
You might want to check your Cognos Planning Data source connection. Check if you created a signon that everyone group can use. Else it will need to authenticate the user for each session.

Offline KeithHartley

  • Associate
  • **
  • Join Date: Oct 2018
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: Have to make multiple connections to ODBC
« Reply #2 on: 31 Oct 2018 04:16:27 am »
First of all, thank you for your interest, I had problems when posting the question and I thought it had got onto this server.

Re your reply - Which part of the connection should I look at? I have looked at Cognos configuration and ODBC driver setup and cannot see any group everyone.

Is your suggestion to look at the driver files or am I missing something (I probably am).

Thanks again,
Keith

Offline KeithHartley

  • Associate
  • **
  • Join Date: Oct 2018
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: Have to make multiple connections to ODBC
« Reply #3 on: 31 Oct 2018 05:13:52 am »
Correction
I thought it had NOT got onto this server.

Offline KeithHartley

  • Associate
  • **
  • Join Date: Oct 2018
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: Have to make multiple connections to ODBC
« Reply #4 on: 31 Oct 2018 06:28:01 am »
Problem solved

And, as is often the case, it was a simple solution.
There were two sql drivers referenced in the d-Links so the system did not know which one to open.

When I set all the d-links to refer to one driver (sql connection) they all open without having to enter the user and password, I assume because the credentials built into the query don't change.

Amazing how explaining a problem to someone else helps you get the solution yourself!!

PS How do I change the title of the thread to include the word solved?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,411
  • Forum Citizenship: +627/-10
  • Cognos Software Muppet
Re: Have to make multiple connections to ODBC
« Reply #5 on: 31 Oct 2018 07:45:41 am »
PS How do I change the title of the thread to include the word solved?

Do you see a "Modify" link in the top right corner of your original post? If you do, click on that and you can change the title of the topic.

If not, let me know and I'll do it for you :)

Cheers!

MF.
Meep!

 


       
Twittear