ASP error connecting to MS SQL database

[kisslogicgoodbye]

I am getting the error: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.


here is my code (names and passwords changed to protect the innocent):

var SQLConn = Server.CreateObject("ADODB.Connection"
SQLConn.Open("DSN=acme", "sa", ""

var sql_Statement = new String("SELECT ItemNumber, Description, TradeName, SWC, ContractItem_ID FROM ContractItem ORDER BY Contract_ID, ItemNumber, Description"

var fp_getItems = Server.CreateObject("ADODB.Recordset"

var prevItemNumber = new String(""
var prevItemDesc = new String(""
var prevItemTradeName = new String(""
var prevItemSWC = new String(""

var curItemNumber = new String(""
var curItemDesc = new String(""
var curItemTradeName = new String(""
var curItemSWC = new String(""

var i=0;

for (fp_Contracts.MoveFirst(); !fp_Contracts.EOF; fp_Contracts.MoveNext()){
curItemNumber = new String(fp_Contracts("ItemNumber&quot);
curItemDesc = new String(fp_Contracts("Description&quot);
curItemTradeName = new String(fp_Contracts("TradeName&quot);
curItemSWC = new String(fp_Contracts("SWC&quot);

etc... the script stops when I try to get the recordset.

 

[dbrom]

you need to open the recordset:

fp_getItems.Open(sql,SQLConn);

that should help. Dmitriy
dbrom@crosswinds.net

 

[link9]

It also looks as if your recordset does not have the same name as what you are trying to .moveNext and such...

 

[kisslogicgoodbye]

Thanks - silly error on my part