Hello,

I am trying to connect to paradox database for the purpose of updating
the record(s) in DTS ActiveX Script Task.

I used the following connection string. But I get an error while
connection. I have "UMTest.db" and "UMTest.px" files in the
"C:\MYDBPath" in my local drive.

Set objRs = CreateObject("ADODB.RecordSet"*)

DB_STRING = "Provider=Microsoft.Jet.OLEDB.*4.0;Data
Source=C:\MYDBPath;Extended Properties=Paradox 5.x;"

strSQL = " UPDATE UMTest SET Field1 = 1.222 WHERE Col1ID = '" & Value1
& "' AND Col2 = '" & Value2 & "'"

objRs.Open strSQL, DB_STRING

I get the following error.

Error Source: Microsoft Jet Database engine.
Error Description: No Value given for one or more required parameters.

Connection string looks alright to me. I don't know what is other
reason which is causing this error to happen.

Thanks.

Yunus's Group,

You have to use connection object instead:

Set objConn = CreateObject("ADODB.Connection"*)

DB_STRING = "Provider=Microsoft.Jet.OLEDB.*4.0;Data
Source=C:\MYDBPath;Extended Properties=Paradox 5.x;"

strSQL = " UPDATE UMTest SET Field1 = 1.222 WHERE Col1ID = '" & Value1 & "'
AND Col2 = '" & Value2 & "'"

objConn.ConnectionString = DB_STRING
objConn.Open
objConn.Execute strSQL
objConn.Close
Set objConn = Nothing

Ilya

"Yunus's Group" <yunusasmath (AT) gmail (DOT) com> wrote

Hello,

I am trying to connect to paradox database for the purpose of updating
the record(s) in DTS ActiveX Script Task.

I used the following connection string. But I get an error while
connection. I have "UMTest.db" and "UMTest.px" files in the
"C:\MYDBPath" in my local drive.

Set objRs = CreateObject("ADODB.RecordSet"*)

DB_STRING = "Provider=Microsoft.Jet.OLEDB.*4.0;Data
Source=C:\MYDBPath;Extended Properties=Paradox 5.x;"

strSQL = " UPDATE UMTest SET Field1 = 1.222 WHERE Col1ID = '" & Value1
& "' AND Col2 = '" & Value2 & "'"

objRs.Open strSQL, DB_STRING

I get the following error.

Error Source: Microsoft Jet Database engine.
Error Description: No Value given for one or more required parameters.

Connection string looks alright to me. I don't know what is other
reason which is causing this error to happen.

Thanks.