Recent content by LuvASP

I am executing an Insert query through connection object: set conn = server.CreateObject("ADODB.connection") conn.Open constr conn.execute "INSERT INTO table1(val) SELECT val FROM table2", recs, adAsyncExecute I keep getting a -1 in recs. What am I doing wrong...

I have seen a website in action where when something changes in the database the ASP gets updated without getting refreshed. Unfortunately, I have not been able to find anything on the net for this. I believe this is possible by having an activeX control which contains winsock component...

Is there any way to start execution of a query on SQL Server and quit instead of waiting for the complete execution of the query. Is this possible in ASP or am I just dreaming. I want to avoid writing a service.

VBScript doesn't accept "format" by itself so you have to use the "formatdatetime". Look online or in MSDN for this function.

dsn="CSOLPhone" You need to specify the username and password also in this string. dsn="CSOLPhone,UID=youdbuserid,PWD=dbuserpassword"

I don't think its anything to do with the version of IIS. Try using this string: "Provider=SQLOLEDB;Data Source=Yourservername;Initial Catalog=Yourdatabasename;User ID=dbuser;Password=dbuserpassword;" The connection string should really be the same for both dev and production...

Thank you very much. It worked.

I am using the following queries to get the WeekStarting date and WeekEnding date depending on today's date. For e.g. the weekstarting date for today would be 6/18(Monday) and weekending would be 6/24(Sunday). (Select dateadd(d, -(datepart(dw,getdate())-2), getdate())) as weekstarting (Select...

I have an ASP web application that uses COM as the middle-tier. COM communicates with a SQL Server database and in COM we have the DSN-Less connection string to connect to the database. I don't know how safe this actually is and am looking for alternatives to storing the database connection...

Why don't you create an <iframe> in the HTML page and call an ASP page in the iframe to do the processing. Your page will always be an HTML page but when you click SUBMIT it will process in the iframe. You will have to write Javascript to call the iframe so that it can call the processing ASP...

Can someone point me in the right direction. I want to update an Exchange profile via COM. I have written code to fetch information from the exchange server and that I am using in ASP via a COM object using ADSI objects. I would like to go a step further and update that information via COM as...

Can someone point me in the right direction. I want to update an Exchange profile via COM. I have written code to fetch information from the exchange server and that I am using in ASP via a COM object using ADSI objects. I would like to go a step further and update that information via COM as...

Can someone point me in the right direction. I want to update an Exchange profile via COM. I have written code to fetch information from the exchange server and that I am using in ASP via a COM object using ADSI objects. I would like to go a step further and update that information via COM as...

Does SQL Server 2000 support replication to a 7.0 database. My source database resides on a SQL Server 2000 box and the destination database resides on a SQL Server 7.0 box. Will the replication work? Thanks.

I'm having no luck getting my Interdev project in Sourcesafe. Please help! I have installed Sourcesafe Server on the Web server and everytime I try to &quot;Add to SourceControl&quot; from Interdev it gives me the following error: &quot;cannot establish source control for the web application...