Hello all, I've tried posting this same question on other newsgroups
with no luck. This group seems to have a lot more activity so I
apologize if you have seen it before.
I'm trying to create a web service in c# using paradox data. The data
is stored locally on my development machine with IIS also installed.
Web services are working to the point where I can return strings and
ints using Access2000 data but whenever I try and access paradox I get
an unspecified error 11265.
System.Data.OleDb.OleDbException: Unexpected error from external
database driver (11265). at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPA
RAMS dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(Comm
andBehavior behavior) at
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at
JobMaintenance.JobView.GetCustomerName(String id) in c:\mycode\retail
systems projects\application\web
services\calllogging\jobmaintenance\jobview.asmx.c s:line 74
I can access the same paradox data through a console application but the
web service is giving me no joy. I'm using standard OleDbConnection
objects. Any help would be appreciated.