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.Ole Db.OleDbExcepti on: Unexpected error from external
database driver (11265). at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr)
at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPA
RAMS dbParams, Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult)
at System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r
behavior, Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) at
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
at
System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Execut eReader(Comm
andBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) at
JobMaintenance. JobView.GetCust omerName(String id) in c:\mycode\retai l
systems projects\applic ation\web
services\calllo gging\jobmainte nance\jobview.a smx.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.
"Eugen Walcher" <eu***@westnet. com.au> wrote in message
news:42******** @quokka.wn.com. au...
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.Ole Db.OleDbExcepti on: Unexpected error from external database
driver (11265). at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S
dbParams, Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r behavior,
Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) at
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior) at
System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Execut eReader(Command Behavior
behavior) at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at System.Data.Com mon.DbDataAdapt er.Fill(DataSet
dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) at
JobMaintenance. JobView.GetCust omerName(String id) in c:\mycode\retai l
systems projects\applic ation\web
services\calllo gging\jobmainte nance\jobview.a smx.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...iverForParadox

Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Eugen Walcher" <eu***@westnet. com.au> wrote in message news:42******** @quokka.wn.com. au...
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.Ole Db.OleDbExcepti on: Unexpected error from external database driver (11265). at System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr) at System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S dbParams, Object& executeResult) at System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult) at System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r behavior, Object& executeResult) at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior behavior, String method) at System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior) at System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Execut eReader(Command Behavior behavior) at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) at JobMaintenance. JobView.GetCust omerName(String id) in c:\mycode\retai l systems projects\applic ation\web services\calllo gging\jobmainte nance\jobview.a smx.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_n ame>. 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:ti*****@ despammed.com]
Posted At: Monday, 18 April 2005 4:47 PM
Posted To: microsoft.publi c.dotnet.langua ges.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...iverForParadox
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Eugen Walcher" <eu***@westnet. com.au> wrote in message
news:42******** @quokka.wn.com. au...

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.Ole Db.OleDbExcepti on: Unexpected error from external
database driver (11265). at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr)
at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPA
RAMS dbParams, Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult)
at System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r
behavior, Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) at
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
at
System.Data.Ole Db.OleDbCommand .System.Data.ID bCommand.Execut eReader(Comm
andBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) at
JobMaintenance. JobView.GetCust omerName(String id) in c:\mycode\retai l
systems projects\applic ation\web
services\calllo gging\jobmainte nance\jobview.a smx.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_n ame>

Regards

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

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

Error 11265 relates to &lsquo;Netwo rk initialization failed'. My IIS->Default Web Site is using Guest Account IUSR_<machine_n ame>. 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?