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

I'm porting a database developed in Access to a Web site. In Access, I define a number of queries that are then used in other queries just as if they were tables. How do I do the same thing in ASP? I am thinking that what I want to do is something like the following. I would open a record...more >>

Sorry for posting here but I can't find the SQL server NG. What is the correct syntax for using Like in a select with a variable in a stored procedure? My stored procedure is: Select fields from Table where ClientAccess = @Client I would like Select fields from Table where ClientAc...more >>

Hello, So, I have an MS Access DB (replicated) that is attached to a website using ASP. I was changing some information in the DB (as I do many, MANY times) and this time something strange happened. After I changed the DB, MS Access had prompted me to save changes (usually it doesn't, just m...more >>

I'm running IIS on Windows XP Pro, and I have a problem whenever I try to add, delete or update records in a database using ADO. The DB is an MDB DB. The error message I get is: "Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /blkbrd-sdc/default.asp,...more >>

I'm looking at migrating the AccessDB backend of my website to SQLServer. There will be a copy of the SQLDB sitting on my PC and another copy sitting on the web server. The copy on the PC will be considered the master. How does replication work when access to the replicant is via IP? Als...more >>

Hi, I have an array as follows a=array("1","2","3","3","2","5","5","1","3") Now i want a function(in vbscript or in asp) which makes my array as follows a=array("1","2","3","3.1","2.1","5","5.1","1.1","3.2") Regards Kalyan...more >>

Hi, I have the following ASP... set dbconn = server.createobject("ADODB.connection") dbconn.open "dsn=news;uid=hello" After the dbconn.open, how do I check if the dbconn.open has an error? e.g. if dbconn has error do something... Thanks, June........more >>

Is there a way to 'append' and manipulate a 'string' onto the beginning of returned results in sql server. For instance, one of my fields [URLCurrent] returns in the following format: "/catamaranco/charter/bareboat/lagoon440_electric/index.asp" However, I wish to remove the tra...more >>

Hello all, I've read over: http://idunno.org/dotNet/trustedConnections.aspx I would like to use a trusted connection vice using encrypted database strings: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT11.asp http://msdn.microsoft.com/library/d...more >>

Hi, I am looking for a way / an example to compute the median and first/last quartils in ASP/ADO/SQL. Thanks in advance for your answers. Bi...more >>