problem with a oRs.Open command in asp
Posted on 2010-01-10
I just moved over my site to a new server and got the sql moved over and main site moved over ok.
the site uses asp coding, however after moving it over and changing the connection strings i get the following error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/store/0128-newproducts.asp, line 118
any ideas where i have gone wrong ? It was working on the old server fine.
the code i use is as follows:
strConnection = "Provider=sqloledb;Data Source=infdb3;Initial Catalog=airpower;User Id=userid;Password=*********;"
Set oDb = Server.CreateObject("ADODB.Connection")
Set oRs = Server.CreateObject("ADODB.Recordset")
oRs.Open strSql, oDb,adOpenForwardOnly, adLockReadOnly, adCmdText