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.
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.
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.
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:
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?
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?
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?
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.
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??
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;"
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?
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?
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.
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?
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.
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
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.
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:
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.
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.
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?
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.
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.
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.