[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

[doofusboy]

This is connection string I use to work with Oracle databases:

Dim strConnection As String = _
"Provider=MSDAORA.1;User ID=MyID;Password=MyPassword;" _
& "Data Source =MyDatabaseService.MyDomain.com"

[spsingh]

will rs.recordCount will not work with oracle.if i use it return -1.There are records in my table.
I used it with access it work well

my source to open connection is

Open "Data Source=store2;" & _
"User Id=scott;" & _
"Password=tiger"

please help me to count records from oracle

[Mega_Man]

It looks to me like you haven't set your cursortype in your ADO connection.
By default it will use forward only which does not support recordcount.
Use either adOpenKeyset or adOpenStatic as the CursorType.

Mega.

[spsingh]

no i'm using cursor type adopenkeyset but still it return record count -1.
Please help me to count record from oracle

[spsingh]

I still not found any solution so please help.Is peet their

[brucevde]

The CursorLocation could be causing the problem. By default CursorLocation is adServerSide, which will always return a RecordCount of -1. Access does not support ServerSide cursors. If you need the record count use a client cursor. Just make sure you understand the implications of using one over the other.

RsUser.CursorLocation = adClientSide