ASP + Libary+ Connection to DB
Posted on 1999-07-13
I want to put a function in the libary wich connect me to the DB.
Now I'am doing this in the same page where I send the SQL query.
The problem is that when I made a function with the Connection String, the page wich execute the question tell me that doesn't recognize the Conn object.
I send the code so maybe anybody can help me.
I create a Function in the libary with this connection code is all done with ASP...
On error resume next
Set Conn = Server.CreateObject("ADODB.Connection")
Conection = Conn
In the page where I execute the query:
Conn = Conection()
SQLStmt ="SELECT * From Users"
SET Rs = Conn.Execute(SQLStmt)
The ERROR IS Conn doesn`t exists.......