Dear friends,

       I m facing a strange problem but it's like an old problem.
The problem is I m Installing my application on XP systems. My specification are

Product Developed in : Visual Basic 6.0

Database : Oracle 9i(Running on Windows 2000 server)

when i developed my product i used MDAC supplied bydeafault with VB. Now it has been upgraded to MDAC2.7 which would be installed with XP OS.

When i m trying to access my database from an XP system i m getting an error.

My code is

dim Cn as new Adodb.Connection
Cn.open "Proider=MSDASQL;DSN=MYDSN;UID=MYUSER;PWD=MYPA SS"

I tried another way also

Cn.open "Proider=MSDAORA;Data Source=MYDSN;User name=MYUSER;Password=MYPASS"


But I m prompted with the following error

[Microsoft][ODBC For Oracle][Oracle]

This the error.and i created System DSN.

Some XP systems are working fine with the above code,
And some systems are not able to connect.

If any body can help me on this problem.It would be a great help to me.

Thanking you all in advance.

Veerendrakumar


B.V.Kumar

__________________
B.V.Kumar

You can use
cn.open "DSN=mydsn;"
When you create a DSN, it includes everything like provider, database etc. You can also use like that
cn.open "DSN=mydsn;uid=sa;pwd=sa-password;"

Cheers,

-Ned

Hi

I encountered similar problem as bveerendrakumar, and i'm already using "DSN=mydsn;uid=sa;pwd=sa-password;" as the connection string.

The strangest thing is that it works fine on some xp machines and not in some. Can this be somekind of security level which causes this ODBC - call fail problem?