Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread asp.net odbc problem
Thu, May 18 2006 8:05 PMPermanent Link

Jaweed Saleem
Hi,

I'm just testing the ODBC driver using System.Data.Odbc. When I use it
during a winforms application, it works fine but when I try and use it
in an Asp.Net website, it tell me "System Error ..." whenever I try to
update or insert a record. The sql is fine, but I'm wondering if this is
some sort of permissions problem with the IIS user? I'm using Delphi
2006 and DBISAM 3.30.

Thanks
Fri, May 19 2006 5:40 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jaweed,

<< I'm just testing the ODBC driver using System.Data.Odbc. When I use it
during a winforms application, it works fine but when I try and use it in an
Asp.Net website, it tell me "System Error ..." whenever I try to update or
insert a record. The sql is fine, but I'm wondering if this is some sort of
permissions problem with the IIS user? I'm using Delphi 2006 and DBISAM
3.30. >>

Could you please post the exact error message that you're seeing along with
the code that you're using in the ASP app that is causing the error ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, May 23 2006 9:26 PMPermanent Link

Jaweed Saleem
Tim Young [Elevate Software] wrote:
> Jaweed,
>
> << I'm just testing the ODBC driver using System.Data.Odbc. When I use it
> during a winforms application, it works fine but when I try and use it in an
> Asp.Net website, it tell me "System Error ..." whenever I try to update or
> insert a record. The sql is fine, but I'm wondering if this is some sort of
> permissions problem with the IIS user? I'm using Delphi 2006 and DBISAM
> 3.30. >>
>
> Could you please post the exact error message that you're seeing along with
> the code that you're using in the ASP app that is causing the error ?
>
> Thanks,
>

Hi Tim,

I've attached it, it's a delphi 2006 asp.net project. Basically the
TFavourDataConnection class looks in the web.config file and grabs the
dsn then hooks up an ODBC connection to the 3.30 database. The TEmployee
class then retrieves a list of employees and has a method for saving the
surname and/or given names fields. The Main.aspx file just puts these
two methods together on one page.

When running the program, just have an ODBC connection to a database
with one table, "Nurse" and have three fields called "Employee_No",
"Surname", "Given_Name1", they can all be varchar(50) for this test.

The error message is "System Error...". Not very helpful. But like I
said, If I use the same code in a WinForms app, it works fine.

Thanks,



Attachments: Asp.Net Website.rar
Wed, May 24 2006 3:35 PMPermanent Link

Aage Johansen
Jaweed Saleem wrote:
> Tim Young [Elevate Software] wrote:
>> Jaweed,
>>...
>
> Hi Tim,
>
> I've attached it, ... ...


ISTR that at some point in time there was a separate group for posting
attachments.  Isn't it used anymore?

--
Aage J.
Wed, May 24 2006 5:28 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jaweed,

<< I've attached it, it's a delphi 2006 asp.net project. Basically the
TFavourDataConnection class looks in the web.config file and grabs the dsn
then hooks up an ODBC connection to the 3.30 database. The TEmployee class
then retrieves a list of employees and has a method for saving the surname
and/or given names fields. The Main.aspx file just puts these two methods
together on one page. >>

Are you using the trial version of the driver ?  If so, then that is the
problem.  Email me privately if you need a non-nag dialog version for
testing.

Also, please post attachments in the Binaries newsgroup.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, May 24 2006 8:51 PMPermanent Link

Jaweed Saleem
Tim Young [Elevate Software] wrote:
> Jaweed,
>
> << I've attached it, it's a delphi 2006 asp.net project. Basically the
> TFavourDataConnection class looks in the web.config file and grabs the dsn
> then hooks up an ODBC connection to the 3.30 database. The TEmployee class
> then retrieves a list of employees and has a method for saving the surname
> and/or given names fields. The Main.aspx file just puts these two methods
> together on one page. >>
>
> Are you using the trial version of the driver ?  If so, then that is the
> problem.  Email me privately if you need a non-nag dialog version for
> testing.
>
> Also, please post attachments in the Binaries newsgroup.
>

We are using the full version of the driver. I'll post future
attachments in the binaries group. Did you have any luck running the
program?
Thu, May 25 2006 7:11 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jaweed,

<< We are using the full version of the driver. I'll post future attachments
in the binaries group. Did you have any luck running the program? >>

I didn't try it yet, no (I don't have IIS set up - we use our own web
server).  Can you actually SELECT from the Nurse table, or can you not
access the table at all ?  If it is the latter, then most likely the issue
is a permissions problem with the IIS web user account.  You need to make
sure that you have read/write/delete capabilities for the database directory
set up for the IIS web user account.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image