If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Have to make multiple connections to ODBC

Started by KeithHartley, 18 Oct 2018 06:28:33 AM

Previous topic - Next topic

KeithHartley

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?

sdf

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.

KeithHartley

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

KeithHartley

Correction
I thought it had NOT got onto this server.

KeithHartley

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?

MFGF

Quote from: KeithHartley on 31 Oct 2018 06:28:01 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!