Could not delete from specified tables

Hi,

The following message appears when running the code below on Windows 98. On
Win2K it works fine:

-2147467259: [Microsoft][ODBC dBase Driver] Could not delete from specified
tables

VB Code:
=======
Dim sConnectionString As String
Dim oConn As New ADODB.Connection
Dim oCommand As New ADODB.Command
Dim sSql As String

sConnectionString = "Driver={Microsoft dBASE Driver
(*.dbf)};DriverID=533;Dbq=c:\mydir"
oConn.ConnectionString = sConnectionString
oConn.Open

Set oCommand.ActiveConnection = oConn
oCommand.CommandType = adCmdText
oCommand.CommandTimeout = 0

sSql = "delete from pos_dox"
oCommand.CommandText = sSql
oCommand.Execute
===========
End of VB code

Any help would be appreciated

If your dBase database reside on a server which happens to be the Win2K
machine, then Win 98 is looking for a database on its own C drive in
C:\MyDir. Your dbq probably should reflect a \\servername\myDir so that it
looks at the correct database location on the correct computer.

Hope that helps or shed some light to what you need to do.

"Benny Halperin" <bhalperin.DeleteThis@cdisys.com> wrote in message
news:%23XApJLorDHA.2340@TK2MSFTNGP12.phx.gbl...
 > Hi,
 >
 > The following message appears when running the code below on Windows 98.
On
 > Win2K it works fine:
 >
 > -2147467259: [Microsoft][ODBC dBase Driver] Could not delete from
specified
 > tables
 >
 > VB Code:
 > =======
 > Dim sConnectionString As String
 > Dim oConn As New ADODB.Connection
 > Dim oCommand As New ADODB.Command
 > Dim sSql As String
 >
 > sConnectionString = "Driver={Microsoft dBASE Driver
 > (*.dbf)};DriverID=533;Dbq=c:\mydir"
 > oConn.ConnectionString = sConnectionString
 > oConn.Open
 >
 > Set oCommand.ActiveConnection = oConn
 > oCommand.CommandType = adCmdText
 > oCommand.CommandTimeout = 0
 >
 > sSql = "delete from pos_dox"
 > oCommand.CommandText = sSql
 > oCommand.Execute
 > ===========
 > End of VB code
 >
 > Any help would be appreciated
 >
 ><!-- ~MESSAGE_AFTER~ -->