- Total Members: 220,001
- Threads: 525,379
- Posts: 976,967
-
December 21st, 2012, 06:51 AM
#1
Asp
Dear Sir(s)
Can someone help me with this
My Connection string is stored in dll which I have already registered successfully . (Name : eml.dll and class eml_cls) as below :
eml_cls (Class File) contents
Function ConnectionFunction()
Dim Conn
Conn = Provider=MSDAORA;Data Source=XXXXXX;User Id=XXXXXXXX;Password=XXXXXXXX
End Function
My ASP Page has the below Code :
Dim myConString,conn,acc_set,dbconn
Set myConString =Server.CreateObject("eml.eml_cls")
dbconn= myConString.ConnectionFunction()
acc_set = "Select email_id from eml_tbl"
dbconn.execute(acc_set)
But I am getting the below error :
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/ANJ/SMGT/dl.asp, line 9
Basically i want to save the connection string in dll and use it in ASP page.
Any help is really appreciated..
Thank You Gurus