ORA-01005: null password given; logon denied

Question

I have created a SSAS Database pro grammatically using SQL Server AMO namespaces. It has create successfully. But When I'm going to explore the data using BIDS of the Data source It is prompting an error like this,

ORA-01005: null password given; logon denied

My Connection String is

    @"Provider=OraOLEDB.Oracle.1;Data Source=//cmbtrndb02/hector;Password=trnint16;User ID=trnint16;Intergrated Security=yes";

I have used the ConnectionStringSecurity Property as "unchanged" but it gives the same error.

ds.ConnectionStringSecurity = ConnectionStringSecurity.Unchanged;

What could be the problem for this.

Solution 1

Old post but maybe this helps someone out (like it helped me):

If you're using "System.Data.Entity.Infrastructure" on your project (maybe you are casting the DbContext to an ObjectContext for some reason?) you will be getting this error (ORA-01005).

As I finally found out, you can easily avoid it just by adding "Persist Security Info=true" on your "Oracle.ManagedDataAccess.Client"'s string connection.

Solution 2

If for some reason you really need to obtain the connection string from other connection, like user2306318 refers, you need to add the option "Persist Security Info=True" to your connection string.

Solution 3

You just need to include the password in the connectionstring as follows: if your user name is carl and your password is bullet56 then:

connectionString="Data Source=LocalHost;User ID=carl;Unicode=True;Password=bullet56"

Hope it will be helpful.