Re: Connecting to Object that returns database connection

Yes 'set' was the missing piece of the puzzle. I picked up some other
helpful insights from the responses also.

Thanks for the help everyone.

"B@DJJ" wrote:

> Sorry! that's what I get for not reading all the posts (and doing it only
> now and again!)!
>
> "Bob Barrows [MVP]" wrote:
>
> > Errr... that was the first suggestion he received ... two weeks ago. I
> > would imagine his problem is resolved by now.
> >
> > B@DJJ wrote:
> > > How about simply adding SET to your stmt(s) (so that they get created
> > > as objects):
> > >
> > > SET mytest = Server.CreateObject("mydll.database")
> > > ....
> > > SET myConnection = mytest.getConnection
> > >
> > > "T McDonald" wrote:
> > >
> > >> I'm having some issues with a dll I've created to return an
> > >> ADOConnection back to an ASP script.
> > >>
> > >> I successfully open my object:
> > >> mytest = Server.CreateObject("mydll.database")
> > >> I then attempt to use the connection:
> > >> myConnection = mytest.getConnection
> > >>
> > >> This is where the script breaks down with an "Object required" error.
> > >>
> > >> I am able to access other methods in the dll, it just doesn't seem
> > >> to be returning the database connnection successfully.
> > >>
> > >> Any help is greatly appreciated.
> >
> > --
> > 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.
> >
> >
> >