create web service accessing paradox

[Eugen Walcher]

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.ExecuteCommandTextErrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPA
RAMS dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior
behavior, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(Comm
andBehavior behavior) at
System.Data.Common.DbDataAdapter.FillFromCommand(Object 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.cs: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.

 

[Stephany Young]

First of all, check your Paradox documentation for the meaning of error
11265. That will probably point you in the right direction.


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.ExecuteCommandTextErrorHandling(Int32 hr) at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object 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.cs: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.

 

[John Timney \(ASP.NET MVP\)]

I dont know how paradox works but If its working through a console app, its usually an access permissions problem to where your paradox db resides.

You might get some tips here on other important information:
http://carlprothman.net/Default.aspx?tabid=90#ODBCDriverForParadox

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

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.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object 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.cs: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.

 

[Eugen Walcher]

Thanks for the quick reply.



Error 11265 relates to 'Network initialization failed'. My IIS->Default
Web Site is using Guest Account IUSR_<machine_name>. I've shared the
data directory where my paradox data resides to everyone and
IUSR_<machine name> account Full Access. Are there any other permission
settings to change?



_____

From: John Timney (ASP.NET MVP) [mailto:[email protected]]
Posted At: Monday, 18 April 2005 4:47 PM
Posted To: microsoft.public.dotnet.languages.csharp
Conversation: create web service accessing paradox
Subject: Re: create web service accessing paradox


I dont know how paradox works but If its working through a console app,
its usually an access permissions problem to where your paradox db
resides.



You might get some tips here on other important information:

http://carlprothman.net/Default.aspx?tabid=90#ODBCDriverForParadox


Regards



John Timney
ASP.NET MVP
Microsoft Regional Director


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.ExecuteCommandTextErrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPA
RAMS dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior
behavior, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(Comm
andBehavior behavior) at
System.Data.Common.DbDataAdapter.FillFromCommand(Object 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.cs: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.

 

[Richard Blewett [DevelopMentor]]

The web service is running under asp.net. On IIS5 (win2000 or xp) this means that by default it will run under the ASPNET account and on IIS6 (Win2003) it will run by default under the NetworkService account. So unless you have changed something in the ASP.NET configuration the webservice will not be running under the IUSR_<machine_name>

Regards

Richard Blewett - DevelopMentor
http://www.dotnetconsult.co.uk/weblog
http://www.dotnetconsult.co.uk

v\:* { BEHAVIOR: url(#default#VML) } o\:* { BEHAVIOR: url(#default#VML) } w\:* { BEHAVIOR: url(#default#VML) } .shape { BEHAVIOR: url(#default#VML) } Thanks for the quick reply.



Error 11265 relates to &lsquo;Network initialization failed'. My IIS->Default Web Site is using Guest Account IUSR_<machine_name>. I've shared the data directory where my paradox data resides to everyone and IUSR_<machine name> account Full Access. Are there any other permission settings to change?