Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > inetserver asp db > november 2004 > threads for november 8 - 14, 2004

Filter by week: 1 2 3 4 5

Multiple db connections on NTFS
Posted by a new guy at 11/14/2004 5:03:43 PM
I've just migrated my web development from Windows 2000 Pro to Windows 2000 Server. The file format on the W2K Pro was FAT32, while the W2K Server is NTFS. Using IIS for the web server for both. I'm now having trouble with multiple simultaneous connections to the ACCESS database, using the JE...more >>


asp.net dsn less connection to ms access
Posted by wasim javed at 11/14/2004 9:30:42 AM
Hi Guys, Since long time i am unable to connect my ms access database to my asp.net page, i have already uploaded my database to my server my asp.net page also but i am unable to connect it, i tried it with server.mappath way and in different ways but result is nothing sometime it does not gi...more >>

ASP/MS Access paging through large recordset
Posted by Scotter at 11/13/2004 6:47:21 PM
I have a 7000 record set in MS Access on a fast server. Broadband connection. Takes quite a bit of time to pull the recordset down to a browser. Makes sense. So... I set up paging and it still seems like it is reading the entire recordset just to display page 1 or page 2 or whatever. I've tri...more >>

Looking for a Windows Forum System
Posted by Scotter at 11/12/2004 11:38:27 PM
I'm looking for a forum system I can run on my Windows2003 Server that uses SQL Server 2000 as it's backend database. A couple weeks ago I found one and I need to refind it. The thing that stood out with that system was: You install it once on your server and it has a control panel that you ca...more >>

Migrating Access Database to use ASP
Posted by A P at 11/12/2004 3:24:00 PM
Hi! I'm having problem in doing this. I have fields on my table that has a question mark (e.i. Cleared?) and when I try to include this on a SELECT statement on ASP. it gives an error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Dri...more >>

Proper Syntax Passing Multi Variables to Function
Posted by Gz at 11/11/2004 10:52:47 PM
Hello. I am trying to write a function that will insert data into a table. The function will accept the field names as inputs of which there are eight. I keep getting a compilation error Function InsertLifeLine( Stepdate-, STep-, PN-, SN-, SO-, Pass-, Fail-, DrNumber- ) ------------------------...more >>

searched integer column
Posted by ben h at 11/11/2004 5:09:08 PM
I have a basic page that returns a resultset of widgets (using an integer identity field amongst others) that i want to provide a better search for. currently i allow the user to seach on description: where widget_desc like '%text%' i also want to allow search on the exact widget_id if th...more >>

Timeouts (80040E31) on AddNew
Posted by salty at 11/11/2004 9:35:08 AM
I'm trying to add a new record to a recordset, but I get the above error every time. The error comes immediately, rather than waiting the 30 seconds or 300 seconds I have the CommandTimeout set for. It occurs for every combination of LockType, CursorType and CursorLocation (and believe me, I'v...more >>



Stored procedure transactions on delete??
Posted by Mike D at 11/11/2004 6:44:06 AM
I have a stored procedure that receives an id from an asp page and deletes the records from three different tables. Do I need to handle errors in this with transactions? If I tried to delete from a table where there was no record it doesn't throw an error does it? I have removed a record fr...more >>

ASP with Global.asa file
Posted by Craig at 11/9/2004 12:13:08 PM
I am having one problem that I have researched and cannot figure out. The following is my scenario. I have part of a website located in the non-secure HTTP folder and the shopping cart part located in the secure HTTPS area. I have a database located in the secure HTTPS area. I am using th...more >>

SQL Permission Errors
Posted by Drew at 11/9/2004 9:06:24 AM
Is it possible to show a generic error page when a user doesn't have access to the SQL Server? As it is now, if a user doesn't have permission to a DB on the SQL Server, and navigates to a page or app that uses that DB, it gives them a "Page cannot be found" error, with more abotu the error b...more >>

Strange ASP MS Access Problem
Posted by Jack Wayne at 11/8/2004 5:29:35 PM
Hi, I have in my possession a large web application which I would like to port to another machine, the application will be set up with the same directory structure for the application but the databases connecting to the applications will reside in different directories. Now the problem is whe...more >>

Displaying Status from Stored Procedure
Posted by Shahid Juma at 11/8/2004 2:27:14 PM
Hi, I am wondering if this is possible. I have an ASP page that calls a stored procedure (MSSQL). I want to display the status on the ASP page as each process is executed on the Stored Procedure and ASP page. For example, when I connect to the database, show the user that a connection has been...more >>

recordcount = -1 ??
Posted by Mich at 11/8/2004 9:45:08 AM
Hi, I defined a query (name = myquery) in Access like this: SELECT IIf([wwk]='Maandag',[maandag],IIf([wwk]='Dinsdag',[dinsdag],IIf([wwk]='Woens dag',[woensdag],IIf([wwk]='Donderdag',[donderdag],[vrijdag])))) FROM daguur; When executing in Access and filling e.g. 'maandag' as parameter, it wo...more >>

Access DB unable to open
Posted by westernnord NO[at]SPAM webtv.net at 11/8/2004 7:48:09 AM
I am using Windows XP with IIS and Access 2000 DB. I receive the following ASP error: Error Type: Provider (0x80004005) Unspecified error /TEST3/sds-test/default.asp, line 9 The code at line 9 is the Con.Open "accessDSN" statement in the following code: <!-- #INCLUDE FILE="adovbs.inc...more >>


DevelopmentNow Blog