Service Provider Architecture
We're developing a hosted application that will be used by hundreds of
client companies, each with its own database. Our first release of this
product separated each customer into its own virtual directory with a copy of
the code (classic ASP/IIS 5). We want to design the next version so that
there is one virtual directory, one common copy of the code.
are we losing any application isolation by doing this?
Under IIS5 by separating each customer into a virtual dir, we created a
separate "application" that could be pooled or isolated. Under IIS 6, do we
have to do the same thing or is there a way to break a single "site" into
multiple application pools. It seems that the default is to have an
application pool per site.
View Replies
ADVERTISEMENT
I would like to know how many threads are there in asp.dll and which is the one that is handling my request.
View Replies
View Related
What I need to have is something like a "news site" whereby only the "X" most recent articles are displayed. I have thought of a number of ways to do this, but I don't know what is the "right way."
1) I can create a recordset for each article with value defined by a system value
2) I can create a query in Access that only has the "X" most recent articles in it and display each individually.
3) I can have a recordset of the whole set of articles and select the most recent. (based on date/time field)I'm sure there are other ways too.
How would you real programmers do this?
View Replies
View Related
Does anyone know where I can find something about ASP architecture, and how
it works with IIS
View Replies
View Related
can any one tell me the architecture of asp page. how the page is structured.
View Replies
View Related
Is it possible to design a 3-tier architecture in an ASP application. If yes then how & will it be better then 2-tier approach.
View Replies
View Related
when doing a dynamic site such as this, how does one handle the articles? is the whole article dropped into the db? or does it sit somewhere else and the db just references it?
i'm going to convert a large static site over to asp this summer and am starting to plan the architecture and i haven't really been able to find the answer.
View Replies
View Related
I have a potential client who has a Access-based DB which they use for
recording orders, customer details etc...
They want to provide some of this information online, eg. customer account
details and stock-levels etc, whilst retaining their existing functionality.
They also want to retain the Access front-end but want to migrate the DB to
SQL Server. Code:
View Replies
View Related
we want to create some documentation of the architecture in an existing
ASP application. Can anyone suggest some document types to use to make
it easy to understand the application?
This could be UML type documents or otherwise.
View Replies
View Related
My provider do not support AbsolutePage, PageCount, and PageSize properties.
Are there any alternative ways to break my page wih data received from my Access Database to show only 10 records per page?
View Replies
View Related
i get this error when i use other computer.but when i test the whole asp code adding data it works perfectly.but when tested with other pc this error shows up.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/DBarticles/addarticles.asp, line 50
line 50 is "adoconn.execute myquery"
how can i solve this problem?my guess is other pc's doesnt have a required driver to run this code?
View Replies
View Related
I'm getting this error on a bunch of my scripts. My company is moving our web applications from an older server to a Windows 2003 server, and a bunch of my ASP scripts are throwing errors.
The only one I can't understand is:
"Data provider or other service returned an E_FAIL status."
I understand that the problem is that we have dates that are 0000-00-00, but there's nothing we can do about that. Some of our applications store dates that are not required. If we were to store a random date, it would throw everything off.
Is there a way to remove this check so it continues execution? I would hate to think that the program would fail because of the format of the date.and we are using MySQL 4.1.11 as the DB.
View Replies
View Related
I keep getting this error
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E07)
Syntax error converting datetime from character string.
for the following
Code:
inserting="insert into rental (cust_num, item_sku,rental_date,return_date) VALUES ('"&session("cust_num")&"', '"&rs.fields("item_sku")&"','"&now()&"','"&now()+3&"') "
How can I solve it??
View Replies
View Related
The error occurs when I try to connect to the database (the last line in the code snippet). I am trying to connect to a system DSN named "DSN". It is an IBM DB2 database on a mainframe. I use a product called DB2 Connect to create the ODBC connection on the Windows 2000 server that allows me to access the database on the mainframe.
<%option explicit%>
<HTML>
<BODY>
<TABLE>
<%
Dim Conn, rs
set Conn = Server.CreateObject("adodb.connection")
Conn.Open "Provider=IBMDADB2;DSN=DSN;User Id=XX33XX;Password=XX33XX;"
The error I receive is the following...
"Provider Error '80004005' Unspecified Error"
View Replies
View Related
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/intranet/Connection.asp, line 7
i have the latest mdac installed as well as office, confused as to y this works on another machine and not ma 64bit
View Replies
View Related
Can you tell me what this error means? And maybe how to resolve it? Code:
SELECT * FROM mms_tbl_membershipType WHERE ID = 3
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/home/_register_2.asp, line 80
View Replies
View Related
I would like to send a Generic Email to 50 people,but condition is that user should see only his email address in the To Field. So I thought i will generate 50 emails, But Now the problem is I have a windows 2000 Professional Server, with Outlook Express and Visual basic, I can also use ASP or ASP.NET if that make's Easy. I have MSN as my ISP. So what is the Best Method to accomplish this Task?
View Replies
View Related
Can someone please tell why I am getting this error? I have the primary key field as text field, and allow zero length=yes, and when I try to submit the form, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e2f'
[Microsoft][ODBC Microsoft Access Driver] Index or primary key cannot contain a Null value.
Is it because the ODBC connection is not set properly? or the problem is in the database?
View Replies
View Related
I have tried to create a stored proc in SQl server.The query is like this: CREATE PROCEDURE sp_GetMemberList (@spstr_condn varChar(255)) AS SELECT * FROM tbl_member order by @spstr_condn . But an error was generated.
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.
View Replies
View Related
I have a vb iis application and some asp pages.
The logic is in the vb dll. Now I need to extent one asp page to do extra
step, but the similarly code is in the vb dll. I don¡¯t want to copy/paste
code (and beside don¡¯t know copy/paste will work). So I¡¯m thinking of open
a web service function in vb dll and the asp can http request? Is it other
options?
View Replies
View Related
I'm the co-developer for an ASP helpdesk system which has an in-built POP3 Email function. The idea of the function being that a member of staff logged into the helpdesk can monitor a specific support email address and convert emails into support tickets. Now one of the things our clients have asked for is a service that runs the POP3 Email function so that they don't need to be logged into the helpdesk. What is the easiest way to achieve this? Since users can potentially email the support address 24/7 the service therefore needs to run 24/7. I've read threads in this forum on running scheduled jobs that call an ASP script but I'm not sure if that is the correct solution for my needs. I also need to take into account the fact that some of our clients run the helpdesk application on a shared hosting server so they won't be able to create a Windows Scheduled Task.
View Replies
View Related
if anyone has come across a web service that does synonyms.I want the end user to type in a word and find synonyms on the same page w/out jumping to synonyms.com
View Replies
View Related
Can anyone point me to a very basic example of a project that takes an XML
stream from a web page and sends it to a ASP.NET Web Service that can then
be used to pull records from a SQL Server DB. Like I said I am green at
this, so the more basic it is the better. I am reading about having to
serialize, etc. but not sure about it all yet.
View Replies
View Related
How do I display a DataSet from a Web Service in asp? In order to read a singel line do I use
SET objSoapClient = Server.CreateObject("MSSOAP.SoapClient")
objSoapClient.ClientProperty("ServerHTTPRequest") = True
Call objSoapClient.mssoapinit("http://localhost/Service/products.asmx?wsdl",
"products")
Response.Write objSoapClient.getArticle("10445555")
But If I would like to return a DataSet how do I do then, is it possible in asp?
View Replies
View Related
I have this project where I am creating a ASP.NET Web service that's going to be consumed by an application on the Intranet. This Web service will access a SQL Server database, extract data from tables, create XML DOM that's going to be posted to 3rd party Internet Web service. Code:
View Replies
View Related
I am getting this error on the connection string. in the following code.
<code>
Dim objConn, objRS, strQ
Dim strConnection
Set objConn = Server.CreateObject("ADODB.Connection")
strConnection = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & server.mappath("datawudb.mdb") & ";"
objConn.Open strConnection <----- here is where the error is
strQ ="SELECT * FROM Comments WHERE PostIndex=True "
set objRS=objConn.Execute(strQ)
</code>
I haven't changed anything on this page it has been working fine till about an hour ago
Does anone have a clue how I might go about fixing it?
It seems to allow me to connect on the index page and then error on signin page. If I wait long enough it will let me log on but error every time I open a new connection.
View Replies
View Related
I'm writing a website.. I designed and coded the site on my laptop. Now that I am finished I've uploaded the site on an IIS server.
Information:
I'm writing the site in ASP, with an Access database. Now that I've upload the site to ISS, I am getting this error!
This error is often used by ASP, it gets there if u get problems with policies, like users who can eddit the database. I've added IUSER with write/read rights, so that cant
be the problem.
IIS is configured succesfully... The problem does nog accur, if I am the only one on
the website, but it does when many users get to the site.
Well I found the next thing, and it seemed logical...: ASP connects with a connection-
string... when u call a SQL database, the connectionstring is loaded, when u kill the
browser (or page) the connectionstring dies asswell.
But with Access, the connectionstring remains. There is a limit on these strings, (100)
so if many users connect, many strings are created, but this isnt it either
Error:
Provider error '80004005' Unspecified error, this error is located on the line where
the connectionstring is declared.
View Replies
View Related
Im in a real pickle - the most annoying thing is, because the database was working perfectly for a month, but suddenly im getting this -
Provider error '80004005'
Unspecified error
/site/bars_list.asp, line 15
code -
Set site01 = Server.CreateObject("ADODB.Recordset")
It does not make any sense. all i did was upload the database to the server, made a couple of ASP pages, and suddenly it wont work. Any possible ideas here?
View Replies
View Related
I am getting the following error!
Provider error '80020005'
Type mismatch.
/forms/Eta_database4.asp, line 145
line 145 is : Set objRS = Server.CreateObject("ADODB.Recordset")
ObjRS.open "status", strSQL, objConn, 0, 1
By the i have made some changes! The rest of my code:
View Replies
View Related
I am using the following to connect to SQL Server. How can connect to 2 database with this?
strProvider = "Driver={SQL Server};SERVER=myserver;UID=user;PWD=password;DATA BASE=myDatabase;"
I do not want to code the Database name and user in the query, as below:
[database].[user].[table]
View Replies
View Related
Hosting is being done at a WebHost company. ASP makes calls to database and
seems to work on first call, but second call (refresh or do anything with
data first call pulls up) it errors out.
this only showed up today, after testing worked fine for first 24 hours of
i have taken the database off the host site and replaced it looking at it as well as reset the read/write permissions to directory and mdb file as well (it is Access). Still no go - same issues.
View Replies
View Related
We are using classic ASP for our site and we are looking for a solid and inexpensive payment provider that we can do under the hood API integration with. We do not want to install any software on the server to do this (re: PayPal's API). We have worked with Authorize.net before but their startup price tag is a little high.
View Replies
View Related
I'm wanting to know how I can plug in a session state provider into ASP.NET. Currently you can use either the in-process, stateServer or SQL stores. Is the provider interface open and where is it documented? I've seen that Mono does provide their own state servers but I'm not sure if this is using standard provider interfaces.
View Replies
View Related