Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 7 of 7 total |
asp.net odbc problem |
Thu, May 18 2006 8:05 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |