So I decided to dig out my database stuff and try to build an ASP script...

Here is what I have so far:
conn_user="name"
conn_pass="pass"

adOpenForwardOnly = 0
adLockReadOnly = 1
adOpendynamic = 2
adCmdTable = 2
adOpenStatic = 3
adOpenKeyset = 1

db1="vanilla"

Set objcheck1Conn = Server.CreateObject("ADODB.Connection")
objcheck1Conn.Open CONN_STRING1, CONN_USER, CONN_PASS


Set objcheck1RS = Server.CreateObject("ADODB.Recordset")


strSQL="get * from SPM_file;"

objcheck1RS.Open strQSL, adopenstatic, adLockReadOnly, adCmdText

When I run the script, I get:

ADODB.Recordset error '800a0bb9'

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

Phill,

<< When I run the script, I get:

ADODB.Recordset error '800a0bb9'

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

Why are you using "get" instead of "SELECT" ?

--
Tim Young
Elevate Software
www.elevatesoft.com