Urgent: Need help from Vb and Paradox

Hi all

I am trying to connect to Paradox3.x from VB. I created a DSN(pepsi) and used ADODB. I am able to connect to it but if I make this as a dll and try to connect from ASP it give an error

"Operation must use an updateable Query"
Error No: 80004005


This is the code I am using

Dim conn As New ADODB.Connection
Private Sub Command1_Click()
Set conn = New ADODB.Connection
conn.ConnectionString = "DSN=pepsi"
conn.Open
'This is the line where I am getting error
conn.Execute "Insert into comtest values ('c010','venky',24,'12/12/76')"
End Sub

Note: This code fails only if I use Insert or Update commands and works fine with Select statement

Thanks in advance
Venky

Hello,


First Check your recordset cursor type, that can be forward only, if yes then change it to dynamic.
also check the date format in your paradox system and correlate date format with your DML (Insert statement).

Best of Luck

Vivek Singh

reply me if your problem will not get solved by this i'll send u some other way to do this task.

reply me at my email address:
[email protected]

Venky,

I'm having the same problem; can you please let me know how you got it to work?

Thanks. Jorge.

Can anyone else help me with problem?

Thanks.

Sorry I just didn't looked into that afterwards.

By the way I feel this is a problem in the ODBC drivers versions on different machines. Just make sure to have the ODBC drivers which supports the correct Paradox version.

I was having a version 4.0 drivers which are not supporting my paradox 3.0.
It was working fine for me on version 3.0/3.5 drivers. (I am using Paradox 3.0)

Hopes this helps.

Please reply me back if it works or u find some other solution for this.

Venky
[email protected]

It is all good now! I loaded the odbc driver that come with Paradox 9 and it works fine now.

Thanks for your help.

Jorge.

URW

Venky