Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LuvASP

  1. LuvASP

    Connection.execute RecordsAffected Problem

    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...
  2. LuvASP

    Update page without refreshing entire page.

    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...
  3. LuvASP

    Execution of SQL Query and quit

    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.
  4. LuvASP

    'Date format' problems with ASP & Oracle

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

    DSN Rights Problem

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

    Connection String Problem

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

    I am using the following queries to

    Thank you very much. It worked.
  8. LuvASP

    I am using the following queries to

    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...
  9. LuvASP

    Storing DB Connection String - ideas??

    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...
  10. LuvASP

    Capturing submitted form values

    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...
  11. LuvASP

    Update Info on Exchange

    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...
  12. LuvASP

    Update Info on Exchange

    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...
  13. LuvASP

    COM To Exchange

    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...
  14. LuvASP

    Replication between 2000 and 7.0

    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.
  15. LuvASP

    Sourcesafe Error

    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...
See more

Part and Inventory Search

Back
Top