Invalid Login Information

Printable View

September 11th, 2013, 02:31 AM
Bijoynarayanan

Invalid Login Information

Hi Gurus,
We have developed a program in VB6 using Oracle 10g as database. It was working fine in Windows XP. But now we have upgraded to Windows7 and when I try to run the program I am getting Invalid Login information error message.
I have used following code to connect to Oracle 10g. I have installed 10g client in my system. We are using ADODB.

.ConnectionString = "Provider=MSDAORA.1;Password= <password>; User ID=<ID>;Data Source=<Data Source>;Persist Security Info=False"

Please guide me to proceed further.

Regards,
Bijoy
September 15th, 2013, 01:19 AM
Bijoynarayanan

Re: Invalid Login Information

Quote:

Originally Posted by Bijoynarayanan

Hi Gurus,
We have developed a program in VB6 using Oracle 10g as database. It was working fine in Windows XP. But now we have upgraded to Windows7 and when I try to run the program I am getting Invalid Login information error message.
I have used following code to connect to Oracle 10g. I have installed 10g client in my system. We are using ADODB.

.ConnectionString = "Provider=MSDAORA.1;Password= <password>; User ID=<ID>;Data Source=<Data Source>;Persist Security Info=False"

Please guide me to proceed further.

Regards,
Bijoy

Hi Gurus,
Please help me to resolve this issue.

Regards,
Bijoy
September 16th, 2013, 12:19 AM
jggtz

Re: Invalid Login Information

Is windows 7 / 64 bits ?
September 16th, 2013, 01:38 AM
Bijoynarayanan

Re: Invalid Login Information

Yes, we have installed 64 bit windows 7 in our system.

Regards,
Bijoy
September 16th, 2013, 12:37 PM
jggtz

Re: Invalid Login Information

Be aware that if the applications you are using to connect to oracle are 32 bit you will need to install the 32 bit oracle client instead.
September 16th, 2013, 02:22 PM
Bijoynarayanan

Re: Invalid Login Information

Earlier we have installed oracle 10g in windows 7 and was getting same error. Later we installed oracle 11g client with 64 bit and the result is same. Do we need to change the coding for connection string in vb6 program?

Regards,
Bijoy
September 16th, 2013, 03:59 PM
dglienna

Re: Invalid Login Information

Yes. It should be on Oracle's site.
September 16th, 2013, 06:55 PM
jggtz

Re: Invalid Login Information

And the possible connection strings syntax are here http://www.connectionstrings.com/mysql/
September 17th, 2013, 03:10 AM
Bijoynarayanan

Re: Invalid Login Information

Hi All,
The ODBC we are using is 32 bit. I have installed both 10g client and 11g with 64 bit in my windows 7 laptop and checked the code. Now also I receives same error message number 64 while connecting to Oracle data base. How to resolve this error?

Regards,
Bijoy