Connecting SQL Server using ASP
Posted on 2004-08-16
Hi All Experts,
I am new to ASP, so please suggest me with this question.
I am trying to connect to SQL Server using ASP page. My database is sitting on one machine, IIS server on the other and the clients will be using the database over internet. When i tried to connect using the following code i am getting and error. My code is:
dim dbcon, sSQL, rs1
dbcon.Open "Provider=SQLOLEDB;Initial Catalog=MARS;DATA SOURCE=OCEANIC;User ID=mars;Password=mars"
sSQL="select * from transaction"
I am getting an error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
can any one please suggest me to resolve this problem.
Thanks in advance