Udtræk fra database

Du mangler:

rs.Open sqlquery

Når jeg skriver sådan:
<%
dim connStr, rs, conn, sqlquery
connStr = "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=192.168.90.33,1433; Initial Catalog=DKprod;User ID=sa;Password=sp/2001/9;"
set conn = Server.CreateObject("ADODB.Connection")
set rs = server.createobject("adodb.recordset")
rs.Open sqlquery

sqlquery ="select ActNo from niAct"
%>

<%=rs("ActNo")%>

Får jeg følgende fejlmeddelelse:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/brevdk/index.asp, line 25

Det skal lige siges at jeg aldrig har arbejdet mod en SQL database tidligere :)

Den her rækkefølge:

sqlquery ="select ActNo from niAct"
rs.Open sqlquery

<%
dim connStr, rs, conn, sqlquery
connStr = "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=111.111.11.11,1111; Initial Catalog=DKprod;User ID=sa;Password=xxxxxxx;"
set conn = Server.CreateObject("ADODB.Connection")
set rs = server.createobject("adodb.recordset")

sqlquery ="select ActNo from niAct"
rs.Open sqlquery
%>

Jeg får denne fejlmeddelelse:
ADODB.Recordset error '800a0e7d'
Operation is not allowed on an object referencing a closed or invalid connection.
/brevdk/index.asp, line 16

Hvad går der galt? :)

<%
dim connStr, rs, conn, sqlquery
connStr = "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=111.111.11.11,1111; Initial Catalog=DKprod;User ID=sa;Password=xxxxxxx;"
set conn = Server.CreateObject("ADODB.Connection")
set rs = server.createobject("adodb.recordset")
conn.Open
sqlquery ="select ActNo from niAct"
rs.Open sqlquery
%>

dim connStr, rs, conn, sqlquery
connStr = "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=111.111.11.11,1111; Initial Catalog=DKprod;User ID=sa;Password=xxxxxxx;"
set conn = Server.CreateObject("ADODB.Connection")
set rs = server.createobject("adodb.recordset")
conn.Open connStr
sqlquery ="select ActNo from niAct"
rs.Open sqlquery
%>

Det var åbenbart vores IT-afdeling som havde noget forkert i connection (bruger/pass).
Det du lavede virker :)

Svar for points!

ok

så mangler du bare at acceptere

Ja, det havde jeg glemt! Undskyld :-)