[No one help m] Oracle dsn problem..

[spsingh]

I'm firstly using Access as backend to my project, i connect to access using system Dsn.It woking fine.

Now i want to shift my database to oracle.So i created a System Dsn.I change only in my connection object, change its DSN to Oracle Dsn.Rest coding is same will it work

I'm connecting to oracle using DSN my connection is created but it cannot count record from database.There are records in my table.My coding for open database and to count recored as follow


code for connection opening

DIM CON AS NEW ADODB.CONNECTION

With Con
.Mode = adModeReadWrite
.Open "Provider=msdaora;" & _
"DSN=store2;" & _
"User Id=acme;" & _
"Password=acme"
END WITH


code to open recordset

RsUser.Open "select * from SUSER", Con, , , adCmdText

if RsUser.RecordCount=0 then
msgbox "No record"
end if


Can RecordSet.RecordCount will not work in oracle

Plase help me
Thanks lot