Sure. Code is below. This code had been working for quite some time and then
it stopped for a bit. It seems however that the problem is always solved
during our nightly IIS resets. Naturally this is not a good way of fixing
things ... BTW, some names have been changed below ...
dim con
dim DSN
dim cmd
dim objCMD
dim POutCon
dim JSCon
sub PunchoutConnection(rs,sql)
set POutCon = Server.CreateObject("ADODB.Connection")
POutCon.Open "File Name=C:\aigi\yyyyy.udl;"
set rs = POutCon.Execute(sql)
end sub
sub Job_Scheduler(rs,sql)
set JSCon = Server.CreateObject("ADODB.Connection")
JSCon.Open "File Name=C:\aigi\Job_Scheduler.udl;"
set rs = JSCon.Execute(sql)
end sub
set con = Server.CreateObject("ADODB.Connection")
'DSN = "DSN=udlAAAAAmsp;uid=xxxxxx;pwd=xxxxxx;"
con.ConnectionTimeout=500
'con.Open DSN
'con.Open "File Name=C:\aigi\udlAAAAAmsp.udl;"
con.Open "File Name=C:\aigi\aaaaaa.udl;"
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:OD**************@TK2MSFTNGP11.phx.gbl...
We need to see more code. (no html please)
Has it ever worked?
Rohan Hattangdi wrote: Yes.
set con = Server.CreateObject("ADODB.Connection")
This is the line where it fails.
Thanks,
Rohan
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:eP**************@TK2MSFTNGP09.phx.gbl... I get the following error message on a line that attempts to create
an instance of an ADODB connection object.
"Object does not support this property or method:
'Server.CreateObject' ".
Can you show the actual line?
--
http://www.aspfaq.com/
(Reverse address to reply.)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.