provider run-time error 
Author Message
 provider run-time error

Has anyone got an idea why I am getting this error:

Run-time error '3251': Object or provider is not capable of performing
requested operation.

I connect as follows:

 Set Oracon = CreateObject("ADODB.Connection")
 With Oracon
  .CursorLocation = adUseClient
  .ConnectionString = "Provider=OraOLEDB.Oracle;" & _
                          "Data Source=ora8i;" & _
                          "User ID=levi;" & _
                          "Password=levi;" & _
                          "PLSQLRSet=1;"
  .Open
 End With

My recordset:

 rs.LockType = adLockOptimistic
 rs.CursorType = adOpenDynamic

The error comes up when I call "rs.AddNew" in my data class.

LEvi Nkata



Wed, 22 Oct 2003 00:09:45 GMT  
 provider run-time error
I havent used Oracle in VB, but in the AS400 there is a section in the connection
string you have to add if you want the connection to be read/write vs read only.
Quote:
-----Original Message-----

Has anyone got an idea why I am getting this error:

Run-time error '3251': Object or provider is not capable of performing
requested operation.

I connect as follows:

 Set Oracon = CreateObject("ADODB.Connection")
 With Oracon
  .CursorLocation = adUseClient
  .ConnectionString = "Provider=OraOLEDB.Oracle;" & _
                          "Data Source=ora8i;" & _
                          "User ID=levi;" & _
                          "Password=levi;" & _
                          "PLSQLRSet=1;"
  .Open
 End With

My recordset:

 rs.LockType = adLockOptimistic
 rs.CursorType = adOpenDynamic

The error comes up when I call "rs.AddNew" in my data class.

LEvi Nkata

.



Sun, 26 Oct 2003 05:53:51 GMT  
 provider run-time error
only static cursors can be on the client side. Switch over the cursor
location to adUseServer and check if this helps (i always set the
cursorlocation for the recordset, however i guess it doesn't matter).

Also you haven't included the code to create an instance of the recordset
and set its activeconnection to the current connection object, so i trust
you on that.

If you want to return the recordset to the client, make sure you look up
"disconnected recordsets".

Cheers
Harbinder Gill


I havent used Oracle in VB, but in the AS400 there is a section in the
connection
string you have to add if you want the connection to be read/write vs read
only.

Quote:
-----Original Message-----

Has anyone got an idea why I am getting this error:

Run-time error '3251': Object or provider is not capable of performing
requested operation.

I connect as follows:

 Set Oracon = CreateObject("ADODB.Connection")
 With Oracon
  .CursorLocation = adUseClient
  .ConnectionString = "Provider=OraOLEDB.Oracle;" & _
                          "Data Source=ora8i;" & _
                          "User ID=levi;" & _
                          "Password=levi;" & _
                          "PLSQLRSet=1;"
  .Open
 End With

My recordset:

 rs.LockType = adLockOptimistic
 rs.CursorType = adOpenDynamic

The error comes up when I call "rs.AddNew" in my data class.

LEvi Nkata

.



Thu, 20 Nov 2003 02:04:22 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Microsoft Visual C++ Run time library Run time error R6025

2. Microsoft Visual C++ Run time library Run time error R6025

3. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

4. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

5. Run-Time Error 2486 - Can't Carry Out Operation at Present Time

6. "Provider cannot be found" runtime error

7. "Provider cannot be found" runtime error

8. Runtime error 3706 provider not found

9. An error was encountered while running this program ADO could not find the specific provider

10. Run-time error 3633 when run on a new machine

11. Run time error only when compiled runs

12. OLEDB Provider Error - Supplied Provider is different from the one already in use

 

 
Powered by phpBB® Forum Software