gah more errors


grr i don;t understand this error. here it is:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

send.asp, line 23

here are my lines of code 21-23:

strSql = "SELECT Email FROM newsletters2"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strSql, con, 1, 2

any ideas what's wrong
Posted On: Tuesday 20th of November 2012 02:43:21 AM Total Views:  157
View Complete with Replies

RELATED TOPICS OF Microsoft SQL Server PROGRAMMING LANGUAGE




Syntax errors in code that used to work (convert, multi-part identifier)

I'm working on a project with a friend, we both have sql server 2005 installed. The problem is, some functions and procedures he wrote that worked fine on his installation, showed syntax errors on mine. (e.g. containing TOP instruction - after removing TOP they worked fine). I don't know what's going on and how to fix it. Could anyone help me please
VIEWS ON THIS POST

217

Posted on:

Tuesday 20th November 2012
View Replies!

SQL Server registration errors (NEWBIE)

Odd problem - I'm running SQL 7 (client install) and cannot connect to the server, but only from my machine. From any other machine on the LAN that I've tried (after installing the client and adding my domain acct to the machine) I get in fine. I cannot connect using ISQL either. Any ideas I'm really hoping to avoid a machine reformat.
VIEWS ON THIS POST

248

Posted on:

Tuesday 20th November 2012
View Replies!

Scheduled job not getting completed on first run(takes more than 13 hrs to complete)

we are facing problem with Job performance it is taking hours to get completed : Requirement description: Requirement was to create a job which can run every week and can archive the old records (older then 365 days i.e. around 40000 Records) into an archive database and after Successful archival it deletes those from the live database. Implementation Description: I have created a scheduled job which calls "MASTER_SP" stored procedure; MASTER_SP Stored Procedure in turn calls two more stored procedures "ARCHIVE_SP" and "PURGE_SP" in a single transaction. ARCHIVE_SP Stored procedure archives the data from LIVE_DATABSE to ARCHIVE_DATABASE then PURGE_SP stored procedure Deletes that data from LIVE_DATABSE Problem Description: We took a database dump from the live environment and restored on testing environment, made changes to job and started the job for 40000 records(first run), job dint get Completed in 13 hours so I cancelled the job run. Then we tried with these tests and here are the statistics Second run 2500 records: job gets completed in 12 mins and 30 secs. Third run for 11000 records: job gets completed in 1 min and 30 secs. Fourth run 41000 records: Job gets completed in 1 min and 47 secs. Fifth run 113000: job gets completed in 4 mins and 30 secs. Sixth run 283000: job gets completed in 23 mins. We are facing the problem when job is run for first time on the restored database with huge number of records (i.e. around 40000 Records), CPU utilization is reaching to 100% on this machine, Here SQLSERVER process is utilizing CPU a lot. On the same restored database If we run the job with less number of records say 2500, then this job(i.e 2500 Records) gets completes in 12 minutes, and rest of the successive job runs(i.e. for 40000,113000, 283000) gets completed without any problem. statistics are shown above Can anyone say the exact reason why it creates problem on first run, please come up with some suggestions, so that i can implement them and move code into production.
VIEWS ON THIS POST

211

Posted on:

Monday 26th November 2012
View Replies!