Hi I have a stored procedure assigns different variables and want to return to asp page. How can I do it? Here is part of my sp. ------------------------------------------ IF Exists(Select * from CFSecurity..Secure where UserID = @UserID) Select @SuntronAccount = 1 Else Select @Suntro...more >>

hi, i am trying to run a asp sql query containging many tables. the main table though is a simple ID based table contains all ids from the other tables. eg: K_Nr Bundesland Bezirk Index.Branch 1 2 2 ...more >>

Hi. I wrote a query with parameter in MS Access. When i try to call it from .NET(C#) i recieved errors. Can everybody send my working code. Thanks ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, ...more >>

Hello, (With ASP) I m looking for "the best" way to secure a connection string (OLE DB or ODBC) for an Oracle database. Actually, i m using an include file to open and close the connection with informations write in clear text. I would like to permit an acces to the application over inte...more >>

Hey, I've been doing ASP web apps with SQL Server 2000 for a few years now, but now I need to purchase a DB server license for a new web server (which will only be running 5-6 large bandwidth sites) and there's no way I can afford to use SQL Server. At my previous company I set up the SQL...more >>

I am working on a project using classic ASP. Every time I install Windows and IIS, it works for 2-3 days and then starts having problems. Specifically, things that have to do with the FileSystemObject stop working. I have tried Win2k, WinXP, the IISs that go with them, different partitions ...more >>

hi, I want to redirect my user to another page. With ASP (not .Net) and IIS 5.0, under windows 2000 server. We have installed the component WinHTTP that is used to manipulate http requests. We want to automatically identify the user through his Windows login/pwd (NTML) He does not need t...more >>

I hope I can make this clear: I have an Access 2000 database that drives an ASP web site to track sales leads. There is a combo box , "units", that lists the inventory of models we sell. Here's a code snippet Fills the combo box: <select name="units" id="units"> ...more >>

Hi All: Once again I have to ask for assistance from all you friendly people out there. I have an ASP page that updates a set of Access tables in the following manner: I have a list of products that I produce. Every time I produce say 10 items of product A, I have to generate unique i...more >>

Hi, I got a code where I am trying to check the values of the variables of AuthorID and intCount by adding response.write statement. However, I am not getting the value of the above two variables. Cannot figure out why. Any help is appreciated. Thanks. Please ignore earlier post which got ...more >>

If fPerformUpdate = True Then Dim intCount intCount = 0 Dim AuthorID Dim FName, LName, Phone Dim Address, City, State For Each Item In Request.Form If Left(item, 3) = "ID_" Then AuthorID = Mid(Item, 4) i...more >>

Hi All: I have just published the same pages to two different web sites (both running Windows 2000 Server). One works perfectly OK, while the other creates the following error: ADODB.Recordset error '800a0cb3' Current Recordset does not support bookmarks. This may be a limitation of the...more >>

I developed an application in asp on a test server. This application queries an SQL DB within the same network. When finished, I created a new web site in my IIS. I then copied all of my asp pages into the new folder where the new site lives. When I open my browser and surf to the new ...more >>

Hi All This is really bizarre prob that I don't know how I'm going to get round it. In essence I have created a site that allows the user to select their preferred shoe size, this then gets added to a simple cart and then they submit the cart order. The problem is that even though I'm b...more >>

I have read somewhere (in a ASP programming book) that I can generate Excel readable output. Following one of the examples in that book, I have tried to run that file against my web server. However, server returns only: "HTTP/1.1 New Application Failed" I have a feeling that it caused by the...more >>

I have a question. Is it possible to send a variable through a hyperlink, to a frames page, and have all 3 pages in the frame pick up the variable using the request.querystring? In other words, I click on a link that has ?id=2 lets say.. it goes to a page called umm say index.asp the inde...more >>

I read aspfaq, and saw almost all execute statement have options 129 i.e. conn.execute sql, , 129 But what does 129 mean in statment? can I simple write conn.execute sql? ...more >>

I want to use a Form to display/get fields from a table - problem is, I do not know how many records the query will pull up. I have been trying to use an array to identify the NAME=" " value, but have not been able to do so. I want it to come up with something like <INPUT TYPE="text" NAME=<...more >>

Hi All: Something really strange is occurring here: When I execute the following SQL string against an Access 2000 database: 'UPDATE mytable SET firstname = 'John', Datestart = '3/10/2006' WHERE ID = 1' and later run: 'SELECT firstname, datestart FROM mytable' then it turns out t...more >>

for some small websites we still have access db's running. i want to convert them to a true sql db. now i wonder if there is any impact of putting the dbs into a msde when accessing the data from asp websites. as far as i found out, the limitations of a msde database shouldn't be of any mat...more >>

Hi, This "query2" is used in an MS Access environment. SELECT T_Perso.*, query1.* FROM T_Perso LEFT JOIN query1 ON T_Perso.IdPerso = query1.IdPerso; In SQL, "query1" is : SELECT T_Items.*, T_Items.IdTypeItem FROM T_Items WHERE (((T_Items.IdTypeItem)="Inscription")); ...more >>

I am trying to pass in 10 variables. I know that can't be the limit. All was fine with 9. What else could be the problem? MS SQL 2000 windows 2000 dev box Thanks Mike...more >>

I hope this is the right group for this question, if it's not please direct me. I have a data-driven website that allows users to enter records for sales leads. It all works perfectly. The only thing I want to do right now is prohibit users from entering the same lead twice. I have a PK fi...more >>

Hi, Just I want to use a static variable, that should be accessible for any of my ASP pages. How should I declare a variable as static? TIA Harish ...more >>

I am using Windows XP with IIS and Access 2000 DB and getting the following error: Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in INSERT INTO statement. /xmlListener.asp, line 67 Here are the values I get using Response.Write statements with a Response.End: 42...more >>

Hello, I have just inherited an ASP project that connects to a SQL Server 2000 database that is currently located on the web server machine. My first task is to move the SQL Server database to a separate machine. I would also like to change it to use integrated Windows security instead of...more >>

Hi, I am trying to run a sample code to see how it works. However, I am getting the following error message: Error Type: ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. /gwis/FSR_EditDetail_test2.asp, line 346 THE CODE: ...more >>

Hi all, i have one asp page which picks up about 15 number values from form, and enters it into sql server database whit float data type fiels. my problem is how to enter NULL value into database if nothing is entered into form, and not '0'. i have this code which doesnt work well.. ---...more >>

I have the problem to find out if its wise to use Oracle as a backend for ASP.NET applications. At the moment all applications are build against a SQL Server backend. A important aspect of the comparision im making is the performance of reading and updating data. Therefor im searching for perfor...more >>

Hi All Wonder if you could give me any pointers on the following plan: 1) I want to auto-extract a number of resultsets from an SQL 7.0 DB using possibly 3 or 4 different queries, which in turn can use 3 or 4 different tables each. 2) Ideally I'd like to put these resultsets into 1 Access...more >>

http://asptango.sourceforge.net/ Download, Use, Enjoy ...more >>

Hi. I'm getting the "Transction context in use by another session" error when saving data to SQL server 7.0 from ASP using <%@ TRANSACTION =Requires_New %> . No DTS is involved. The error only occurs sometimes and seems to have nothing to do with the amount of data saved. Could have somethin...more >>

Hi All, I have BIG Problem in ASP. I have a ADO Connection that I Want to Connect to DBASE IV Database Located in a Local Networked System. The DBASE Database is located in other system then the IIS System in the same Network.But Both are in the same Local Network When I Try the Connec...more >>

Could someone advise me of a website that has decent instructions on how to establish a DSN-less connection to a MySQL database using ASP? I've seen some connection string examples but I'm confused about the drivers and how to set them up. Thanks, -- Jerry...more >>

Hi, I got a web application which was connected to Access97 database. However, few months back someone converted the database to Access 2000. This database is uploaded on a monthly basis from client server production Access97 database. Now, when I am uploading the Access97 database, there is ...more >>

Currently, my application assigns security levels to users (1, 2, 3 etc.) and I control access to areas via this level which is stored in a session. I would like to allow the administrator to be able to specify which areas are accessible by user instead if being limited by my hardcoded option...more >>

Hi, We have a client running our application against SQL Server 2000 (on same box as web-server). After a few hours they start getting sporatic error messages: Microsoft OLE DB Provider for ODBC Drivers Error Code: -2147467259 Description: [Microsoft][ODBC Driver Manager] Driver's SQLAllo...more >>

Hello there, Is there a way I can call VB.net code from a stored procedure? I need to schedule a sql job (stored procedure) and in the logic of the stored procedure, I need to call vb.net code to generate a pdf document. Your answers will help us much. Kind Regards, Benny ...more >>

When I execute a query(written in MS-ACCESS) on an MS-ACCESS database it retrieves records, and I if do the same through ASP-ADO I got either bof of eof is true error. Here's the query select * from placingdrawing where JOB_CODE="P-82-2004" and TITLE LIKE "*AREA A*" Any fix? TIA ...more >>

I get this whenver I try to add a book to the database Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. /book_add.asp, line 110 Now for the snippet from book_ad.asp where the errro...more >>

Dear all, I need to compare two db(Access2003), they have the same ProductID, not more then 10000 records. While using rs.filter, the time take more then 10 minutes, and take 99% cpu loading, also, after comparing, the file size become very large. Is there any better way to do this instead of ...more >>

I did a registry search and found that the threadingmodel for the ADODB.recordset class is "both"... Becuase of this, Is it not true that I should be able to use a recordset object well and efficiently if I store it in a session object in order to reference that object on all my asp page calls...more >>

I'm querying an Access database to retrieve information about one record and then displaying that information in a report. If the contents of a particular field are not blank I want to query the database again to get other information to display in the report. If the information does not exi...more >>

Hello Experts, Thank you for the help the other day on stored queries and work tables. Now I've got a mysterious problem. It cropped up in a DB with a complex set of tables and queries, but I've boiled down the behavior to appear in the following simpler structure: SELECT ProductDat...more >>

Hello, I developed ASP web application for small company. The company only has one computer acting as Server. Windows 2000 Server and SQL Server 7 are installed in the same computer,also it act as a web server. Server's CPU speed is 600mHz and RAM is 1GB. We are using ADSL connection. The s...more >>

Hi, I have asp page where it acts as a form with numerous recordsets, few for retrieval and few for saving and retrieval. One of the recordset is shown as below. Here for a particular record, I am getting the error message as: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the curr...more >>

I am running a series of conn.execute statements on ASP pages against a database. The SQL strings contain single quotes (') as value delimiters - i.e: "INSERT INTO mytable (name, lastname) VALUES ('John', 'Smith') - which is a problem when the values contain single quotes themselves, because...more >>

Hello, I am dummy of Linux. Now company's owner wants to switch OS to Linux from Windows because the cost issue. We currently use ASP web application running in Windows 2000 Server with SQL Server 7. If we change to Linux, can I continue to use the existing ASP web application? What web serv...more >>

I am getting this error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x4f4 Thread 0xe38 DBC 0xd28da4 Jet'. This is the code that it is tr...more >>

Hi Gang I have to 2 SQL statments that grab data from 2 different tables. What I need to do is create a recordset for each and then combine the 2 into 1 recordset. Can I do this easily? Thanks Andy ...more >>