trying to build a Pardox 3.0 database from SQL Server 7 using ADO

[kika]

connection used:

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='d:/avisos/'; Extended Properties=Paradox 3.x"

this successfuly generates a Paradox File (.db):
conn.Execute("CREATE TABLE aviso001.....&quot

but:
conn.Execute("INSERT INTO aviso001 (columns) values (values) fails with the message:

Operation must use an updateable query

Please Help

 

[footpad]

kika,

This is a question better suited to a forum dedicated to either VB, ADO, or ODBC--not one trying to provide help with Corel's Paradox for Windows end-user database software package.

Having said that, I would start by trying to create an ODBC DNS from your ODBC Administrator in Control Panel. If Control Panel doesn't show the ODBC Administrator, try searching your SYSTEM32\ directory for a file called odbccp32.cpl and launching that directly from Windows Explorer.

The idea here is to create a DSN that you can successfully use to connect to your Paradox table. Once you've done that, you should be able to use the settings from that to determine the ADO properties you'll need to use in your ADO Connection string.

FWIW, use care when selecting a Paradox ODBC driver. The one provided with MS Office is nortoriously, um, finicky and does not completely support the full capabilities of the file format. The Intersolv driver installed with Professional editions of Corel's Office Suite is far superior, imho.

Hope this helps...

-- Lance