topic Test connection failed because of an error in initializing provider in QlikView

Test connection failed because of an error in initializing provider

Thu, 29 Apr 2010 01:22:04 GMT

I am trying to connect Oracle DB in the script page

OLE DB --> Connect

In Data Link Properties Window

Provider Tab -->Oracle Provider for OLE DB

Connections page --> Datasource, Username & pwd

Then following error is populating

"Test Connection is failed because of an error in initializing provider. ORA-12154 TNS:could not resolve the connect identifier specified"

what could be the reason for this error? and how to resolve it?

Thanks in advance

Test connection failed because of an error in initializing provider

Thu, 29 Apr 2010 04:52:03 GMT

Hi qlikviewgoer,

I think this could be one of two problems.

1.By default, when you test a connection Oracle uses a dummy username and password to connect to a data source so it could be that the test tried to pass through an invalid username/password combination. To fix this look for a box that says something like change login details.

2. The error could be because your Oracle service is not set up properly i.e. you need to either copy over the tnsnames.ora and sqlnet.ora files from a valid installation or recreate the services on your machine using the client tools. Use the Oracle client tools to ensure that the service is configured properly.

I hope this helps.

Rod

Test connection failed because of an error in initializing provider

Thu, 29 Apr 2010 14:52:32 GMT

Thanks, its working...