Re: Error ORA-01031

On 20 Sep 2006 00:33:09 -0700, "calms" <calmsqurill_at_gmail.com> wrote:

>Hi Morgan,
>
>Thanks for your reply!
>1. As this is a Instant Client Installation,and as you may know that
>there is no Sql Plus installed in the Client. In order to avoid the
>space oracle just provide the instant client dll's.
>2. I used the native driver "Oracle in InstantClient10_1" and the test
>Succeed but while connecting through the application, im getting the
>above error.
>
>
>thks a lot for helping me....
>
>Prasad.N.M

Hi N.M.

I assume it is because you are evidently Asian, you are acting so rude - you address someone by his last name only, which is considered not done in almost all civilized countries.
- you top post.

Apart from that you still provide insufficient information to address your question

1 In a normal Instant Client installation there is sql*plus. To leave out sql*plus because of space reasons is just plain stupid. 2 You are using an ODBC driver. Powerbuilder comes with a native driver. The ODBC driver is just an extra redundant layer which slows everything down.
3 Apparently you are using SYS or some other privileged account (an account requiring SYSDBA privilege) to connect, and either the connect string is wrong, or you are a victim of the normal reasons why you are getting ora-1031. As those reasons have been posted at least a 1000 times here, any reason why you can't search the Usenet archives, N.M, when you don't want to provide sufficient information to address the issue?

--
Sybrand Bakker, Senior Oracle DBA