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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|