Recent content by duckweb

We looked at both options--storing them on folders and the db and chose db b/c we heard sQL Server could handle it. Maybe we were wrong. Anyway, we are using something like this for recordset: Set rs = Server.CreateObject("adodb.recordset") SQL = "SELECT image_blob FROM tb_Images WHERE id =...

We are storing images in sql server 2000 using the image data type. We are using ASP to display these images images in a recordset on our webpages, but even pulling small sized images seem to take a looong time to load. Does anyone know any performance enhancements in asp or sql server to...

Here is my problem: We have a local sql server in our data center and a remote web server. When we hit a web page that makes a call to the db server, we get a pretty quick response. However, after we make other calls to the db server, it gets slower and slower, and finally stops the web...

Nevermind....the problem was that I was missing 1 parameter in my connection string Network Library=dbmssocn Apparently to connect to sql server behind a firewall you must have that in the con. string. Lesson learned. thanks for the reply.

Here is my problem: We have a SQL Server box behind our corporate firewall, in our data center. We can hit this box via the Intranet all day long with no problems. However, we now need to hit this box from our web server, which is hosted externally via another hosting company. We have opened...

Has anyone ever used ActiveEdit as a WYSIWYG editor with ASP? We're looking at using this but would like feedback from others as to your experiences.

Ok...i have seen this somewhere before, but forgot how to do it...I need to use ASP to view all table names in a given database...I know there is some SQL that allows this. Any ideas?

Here is the code. This is the line where my error says its not capable of performing the transaction: rsData.AbsolutePage = iPage <% Dim rsData Dim iPage Dim iTotalPages Dim fldF Dim iRec Dim sQuote Dim sMe Dim sRecs sQuote = Chr(34) ' the double quote character Set conn...

I'm trying to use paging functionality in ASP...i know my code works, b/c I used in a previous job. However, I am trying to do this now, but keep getting the following error: ADODB.Recordset error '800a0cb3' Object or provider is not capable of performing requested operation. /paging.asp...

Thanks to all....I can use your advice to solve my problem!

I'm trying to use paging functionality in ASP...i know my code works, b/c I used in a previous job. However, I am trying to do this now, but keep getting the following error: ADODB.Recordset error '800a0cb3' Object or provider is not capable of performing requested operation. /paging.asp...

Ok...I should know this but I know someone out there will. I have a variable string....let's say it is: myimage.jpg I want to perform some kind of function that returns the following: myimage In other words, I want to always trim the last 4 right-most characters from this string. I can't...