Connection to Paradox

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.I don't do Paradox but to do any DML through Jet, you'd want to make sure
the table has a primary key defined. Also, you might want post this to a
paradox group.
http://www.thedbcommunity.com
-oj
"Yunus's Group" <yunusasmath@.gmail.com> wrote in message
news:1123266062.918633.324570@.g14g2000cwa.googlegroups.com...
> 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.
>|||First, are you sure that's it's bombing out on your connection? If
you've verified this (try setting your strSQL to "SELECT 1" and see if
it still bombs out), then you may need to update your Paradox driver.
I've had to interface with a Paradox db before, and nothing worked
until we got a new driver for it installed on the SQL Server.
Since we were simply extracting data from Paradox during a batch
process, we ultimately ended up buying a copy of Paradox, and doing a
limited install on the SQL Server (basically drivers only).
HTH,
Stu

connection to miltiple server

i want to open query with server1 = 'server1.datasource'

in this query i want to connect to 'server2.datasource '

for copy record between the servers .

can i do it with sql server management studio?

You will want to define a Linked Server

http://msdn2.microsoft.com/en-us/library/ms190479.aspx

Or use OPENDATASOURCE

http://msdn2.microsoft.com/en-us/library/ms179856.aspx

Using the Linked Server you can then reference tables with the four-part name (server.database.schema.table)

|||

gabriel_333 wrote:

can i do it with sql server management studio?

I hope you can use the OPENROWSET.

See more on Books Online regarding OPENROWSET.

|||

I HAVE AN OLE DB SYSTEM DSN = SQLDATCON

WHEN I RUN :

SELECT *

FROM OPENDATASOURCE('SQLDATCON',

'Data Source=SQLDAT;USER ID = ?;PASSWORD =?')

.DBNAME.dbo.TB_ACID

I GET MESSAGE :

Msg 7403, Level 16, State 1, Line 6

The OLE DB provider "SQLDATCON" has not been registered.

|||

Try:

SELECT *

FROM

OPENDATASOURCE('SQLOLEDB', 'dsn=SQLDATCON;USER ID = ?;PASSWORD =?').DBNAME.dbo.TB_ACID

|||

thanks a lot!

i got possitive rspond from the server :' hd hook must have administrator permission '

this is the first life signal

when i need this query i will ask administrater to enable the surface area opendatasource

connection to miltiple server

i want to open query with server1 = 'server1.datasource'

in this query i want to connect to 'server2.datasource '

for copy record between the servers .

can i do it with sql server management studio?

You will want to define a Linked Server

http://msdn2.microsoft.com/en-us/library/ms190479.aspx

Or use OPENDATASOURCE

http://msdn2.microsoft.com/en-us/library/ms179856.aspx

Using the Linked Server you can then reference tables with the four-part name (server.database.schema.table)

|||

gabriel_333 wrote:

can i do it with sql server management studio?

I hope you can use the OPENROWSET.

See more on Books Online regarding OPENROWSET.

|||

I HAVE AN OLE DB SYSTEM DSN = SQLDATCON

WHEN I RUN :

SELECT*

FROMOPENDATASOURCE('SQLDATCON',

'Data Source=SQLDAT;USER ID = ?;PASSWORD =?')

.DBNAME.dbo.TB_ACID

I GET MESSAGE :

Msg 7403, Level 16, State 1, Line 6

The OLE DB provider "SQLDATCON" has not been registered.

|||

Try:

SELECT*

FROM

OPENDATASOURCE('SQLOLEDB', 'dsn=SQLDATCON;USER ID = ?;PASSWORD =?').DBNAME.dbo.TB_ACID

|||

thanks a lot!

i got possitive rspond from the server :' hd hook must have administrator permission '

this is the first life signal

when i need this query i will ask administrater to enable the surface area opendatasource