Hi,
I've got a Paradox 3.X database, exported by Access or as a variant
exported per DTS with a MS-SQL-Server.

I am able to access the database and display all records with ASP with
the following code:

conn.Open "FILEDSN=\para.dsn"

set obj=Server.CreateObject("ADODB.Recordset")
SQL="select * from KST"
obj.open SQL, conn

%>
<table border=1><tr><td>GDI_LFDNR</td><td>KSTNR</td><td>BEZ</td></tr>
<%
do while not obj.eof
response.write "<tr><td>" & obj("GDI_LFDNR") & "</td><td>" &
obj("KSTNR") & "</td><td>" & obj("BEZ") & "</td></tr>"
obj.movenext
loop

%>
</table>
<%
obj.close
set obj=Nothing

conn.close
set conn=Nothing

In para.dsn there is:
[ODBC]
DRIVER=Microsoft Paradox-Treiber (*.db )
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ParadoxUserName=admin
ParadoxNetStyle=3.x
ParadoxNetPath=C:\WINNT\system32
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=Paradox 3.X
DriverId=26
DefaultDir=C:\
DBQ=C:\
CollatingSequence=ASCII

But when I try to send UPDATE, INSERT, DELETE etc. to the database, I
get the error (in German):
Operation muß eine aktualisierbare Anfrage enthalten.

This means that I have only the right to read, but not to modify the
database.
How can I change this? Which is the standard User and PWD to do this?

Thank you for tips, Bernd


--
BM Computer-Services, Bergmannstr. 66, 10961 Berlin
Webdesign, Internet, Layout und Grafik
Tel.: 030/20649400, mobil 0175/7419517, Fax: 030/20649401
Web: http://www.bmservices.de, eMail: kontakt@bmservices.de

[quoted text, click to view]

¤ Hi,
¤ I've got a Paradox 3.X database, exported by Access or as a variant
¤ exported per DTS with a MS-SQL-Server.
¤
¤ I am able to access the database and display all records with ASP with
¤ the following code:
¤
¤ conn.Open "FILEDSN=\para.dsn"
¤
¤ set obj=Server.CreateObject("ADODB.Recordset")
¤ SQL="select * from KST"
¤ obj.open SQL, conn
¤
¤ %>
¤ <table border=1><tr><td>GDI_LFDNR</td><td>KSTNR</td><td>BEZ</td></tr>
¤ <%
¤ do while not obj.eof
¤ response.write "<tr><td>" & obj("GDI_LFDNR") & "</td><td>" &
¤ obj("KSTNR") & "</td><td>" & obj("BEZ") & "</td></tr>"
¤ obj.movenext
¤ loop
¤
¤ %>
¤ </table>
¤ <%
¤ obj.close
¤ set obj=Nothing
¤
¤ conn.close
¤ set conn=Nothing
¤
¤ In para.dsn there is:
¤ [ODBC]
¤ DRIVER=Microsoft Paradox-Treiber (*.db )
¤ UID=admin
¤ UserCommitSync=Yes
¤ Threads=3
¤ SafeTransactions=0
¤ ParadoxUserName=admin
¤ ParadoxNetStyle=3.x
¤ ParadoxNetPath=C:\WINNT\system32
¤ PageTimeout=5
¤ MaxScanRows=8
¤ MaxBufferSize=2048
¤ FIL=Paradox 3.X
¤ DriverId=26
¤ DefaultDir=C:\
¤ DBQ=C:\
¤ CollatingSequence=ASCII
¤
¤ But when I try to send UPDATE, INSERT, DELETE etc. to the database, I
¤ get the error (in German):
¤ Operation muß eine aktualisierbare Anfrage enthalten.
¤
¤ This means that I have only the right to read, but not to modify the
¤ database.
¤ How can I change this? Which is the standard User and PWD to do this?
¤

I don't typically use ODBC to work with Paradox but it may be related to the issue where Microsoft
removed update functionality from the drivers when Jet 4.0 was released. They have since put it
back. See if the following helps:

INFO: Non-BDE Paradox and dBase ISAM Drivers
http://support.microsoft.com/default.aspx?scid=kb;en-us;263561

Also, if this database is on a network share make certain that you have update permissions on the
file.


Paul ~~~ pclement@ameritech.net