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 >>