Connecting to Object that returns database connection
in [ASP]
|
From: Bob Barrows [MVP] on 28 Mar 2008 09:12 Errr... that was the first suggestion he received ... two weeks ago. I would imagine his problem is resolved by now. B(a)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.
From: B on 28 Mar 2008 10:12 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(a)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. > > >
From: T McDonald on 1 Apr 2008 16:07 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(a)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(a)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. > > > > > >
From: Venkatesan S Venkatesan on 18 Apr 2008 15:48 Hi, I am facing a different issue with the same scenario. My component returns a Connection objec to ASP page and then I am trying to use the same Connection object to Command/Recordset object to execute a SP I am getting the error given below ************************************ ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. ===================================== Source code : Option 1: rs1.Open "MentorTest",objConnection.GetConnection,2,4,4 Option 2: Dim sqlConnection Set sqlConnection = objConnection.GetConnection rs1.Open "MentorTest",sqlConnection,2,4,4 Option 3: Dim sqlConnection Set sqlConnection = Server.CreateObject("ADODB.Connection") Set sqlConnection = objConnection.GetConnection rs1.Open "MentorTest",sqlConnection,2,4,4 ************************************ I ensured object creation by IsObject method, connection state of the sqlConnection Could you please tell what could be the issue. Your pointers will be appreciated. "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(a)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. > > >
From: Bob Barrows [MVP] on 18 Apr 2008 16:08 Venkatesan S wrote: > Hi, > I am facing a different issue with the same scenario. > > My component returns a Connection objec to ASP page and then I am > trying to use the same Connection object to Command/Recordset object > to execute a SP > > I am getting the error given below > ************************************ > ADODB.Recordset error '800a0bb9' > > Arguments are of the wrong type, are out of acceptable range, or are > in conflict with one another. > > ===================================== > Source code : > Option 1: > rs1.Open "MentorTest",objConnection.GetConnection,2,4,4 > > Option 2: > > Dim sqlConnection > Set sqlConnection = objConnection.GetConnection > rs1.Open "MentorTest",sqlConnection,2,4,4 > > Option 3: > Dim sqlConnection > Set sqlConnection = Server.CreateObject("ADODB.Connection") > Set sqlConnection = objConnection.GetConnection > rs1.Open "MentorTest",sqlConnection,2,4,4 > > ************************************ > I ensured object creation by IsObject method, connection state of the > sqlConnection > So that seems to indicate that you are misplacing the blame here. To prove it, try a simple set rs1 = createobject("adodb.recordset") sqlConnection.MentorTest, rs1 I believe a dynamic cursor (2) is incompatible with a lock type of adLockBatchOptimistic (4), which may be causing your error. -- 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.
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Exception when sending mail Next: How to setup a HTTP Server in the PC |