|
 |
activex_data_objects thread: Missing records
Message #1 by "Nimisha" <nimisha_uk@y...> on Fri, 16 Aug 2002 10:47:01
|
|
Hi!
This a very strange problem and does not happen
regularly..but happens it does.
I'm using VB6,MDAC 2.7, SQL2000 and COM+.
I have got a dll placed in COM+ which accesses the
database and returns records to the exe. Sometimes,some of
the records are not returned for no apparent reason.No error message is
returned.
If I start up the application again, these records are
returned.
Is the problem due to MTS, SQL Server, Cursor Type????
MSDN does not have much help!!
Hope someone can shed some light into the problem.
I put my problem across in the newsgroup a few weeks back and have got no
reply
Ta
Nimisha
Message #2 by "Joseph De Guzman" <josephdg@o...> on Mon, 19 Aug 2002 10:15:42 +0800
|
|
Nimisha,
Maybe it would be better if you specify (as you said) the type of cursor you
had and other technical details of your setup.
Jojo
----- Original Message -----
From: "Nimisha" <nimisha_uk@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Friday, August 16, 2002 10:47 AM
Subject: [activex_data_objects] Missing records
>
>
>
>
>
> Hi!
>
> This a very strange problem and does not happen
> regularly..but happens it does.
>
> I'm using VB6,MDAC 2.7, SQL2000 and COM+.
> I have got a dll placed in COM+ which accesses the
> database and returns records to the exe. Sometimes,some of
> the records are not returned for no apparent reason.No error message is
> returned.
> If I start up the application again, these records are
> returned.
> Is the problem due to MTS, SQL Server, Cursor Type????
> MSDN does not have much help!!
>
> Hope someone can shed some light into the problem.
> I put my problem across in the newsgroup a few weeks back and have got no
> reply
> Ta
> Nimisha
>
Message #3 by "Nimisha" <nimisha_uk@y...> on Mon, 19 Aug 2002 15:01:46
|
|
> Nimisha,
Maybe it would be better if you specify (as you said) the type of cursor
you
had and other technical details of your setup.
Jojo
----- Original Message -----
From: "Nimisha" <nimisha_uk@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Friday, August 16, 2002 10:47 AM
Subject: [activex_data_objects] Missing records
>
>
>
>
>
> Hi!
>
> This a very strange problem and does not happen
> regularly..but happens it does.
>
> I'm using VB6,MDAC 2.7, SQL2000 and COM+.
> I have got a dll placed in COM+ which accesses the
> database and returns records to the exe. Sometimes,some of
> the records are not returned for no apparent reason.No error message is
> returned.
> If I start up the application again, these records are
> returned.
> Is the problem due to MTS, SQL Server, Cursor Type????
> MSDN does not have much help!!
>
> Hope someone can shed some light into the problem.
> I put my problem across in the newsgroup a few weeks back and have got no
> reply
> Ta
> Nimisha
>
Message #4 by "Nimisha" <nimisha_uk@y...> on Mon, 19 Aug 2002 15:02:55
|
|
Hi
The connection string and cursor type used in my code . An example
strCLIENT = objSPM.GetSPM("ClientObject", "DBConnectionString")
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FYI
THE STORED PROPERTY MANAGER RETURNS THE CONNECTION STRING IN THIS FORMAT
"Provider=SQLOLEDB.1;Password=;User ID=;Initial Catalog=TestDB;Data
Source="
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Set objSPM = Nothing
Set rsQuestion = New Recordset
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FYI
An example of the sql code, cursor type etc
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
strSQL = "SELECT UserName.* FROM Users WHERE UserID=" & CStr(UserID) _
& " AND CompID = " & CStr(CompID) & " AND CountryID = " _
& CStr(CountryID) & " ORDER BY Users.UserOrder"
rsQuestion.Open strSQL,strCLIENT, _
adOpenForwardOnly, adLockReadOnly
Hope this info can shed some light.
ta
Nimisha
> Nimisha,
Maybe it would be better if you specify (as you said) the type of cursor
you
had and other technical details of your setup.
Jojo
----- Original Message -----
From: "Nimisha" <nimisha_uk@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Friday, August 16, 2002 10:47 AM
Subject: [activex_data_objects] Missing records
>
>
>
>
>
> Hi!
>
> This a very strange problem and does not happen
> regularly..but happens it does.
>
> I'm using VB6,MDAC 2.7, SQL2000 and COM+.
> I have got a dll placed in COM+ which accesses the
> database and returns records to the exe. Sometimes,some of
> the records are not returned for no apparent reason.No error message is
> returned.
> If I start up the application again, these records are
> returned.
> Is the problem due to MTS, SQL Server, Cursor Type????
> MSDN does not have much help!!
>
> Hope someone can shed some light into the problem.
> I put my problem across in the newsgroup a few weeks back and have got no
> reply
> Ta
> Nimisha
>
Message #5 by "Ashley Collado" <ad_collado@s...> on Tue, 20 Aug 2002 07:28:19 +0800
|
|
Nimisha, please see my comments below..
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Set objSPM = Nothing
> Set rsQuestion = New Recordset
** Set rsQuestion = New ADODB.Recordset
** (most cases, VB requires explicit reference to the ADODB library.
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> An example of the sql code, cursor type etc
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> strSQL = "SELECT UserName.* FROM Users WHERE UserID=" & CStr(UserID) _
> & " AND CompID = " & CStr(CompID) & " AND CountryID = " _
> & CStr(CountryID) & " ORDER BY Users.UserOrder"
**if CompID is VARCHAR, then make it:
** ...& " AND CompID = '" & CStr(CompID) & "'"... etc...
** ADO sometimes return values without using the single quote string
qualifier this maybe ** one of the reasons why you're encountering such
problem
>
> rsQuestion.Open strSQL,strCLIENT, _
> adOpenForwardOnly, adLockReadOnly
**please provide us also the DDL/Create Table Statement of the table you've
used (USERS) for **me to go into deeper analysis..
best regards,
ash
----- Original Message -----
From: "Nimisha" <nimisha_uk@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Monday, August 19, 2002 3:02 PM
Subject: [activex_data_objects] Re: Missing records
> Hi
> The connection string and cursor type used in my code . An example
>
> strCLIENT = objSPM.GetSPM("ClientObject", "DBConnectionString")
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> THE STORED PROPERTY MANAGER RETURNS THE CONNECTION STRING IN THIS FORMAT
> "Provider=SQLOLEDB.1;Password=;User ID=;Initial Catalog=TestDB;Data
> Source="
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Set objSPM = Nothing
> Set rsQuestion = New Recordset
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> An example of the sql code, cursor type etc
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> strSQL = "SELECT UserName.* FROM Users WHERE UserID=" & CStr(UserID) _
> & " AND CompID = " & CStr(CompID) & " AND CountryID = " _
> & CStr(CountryID) & " ORDER BY Users.UserOrder"
>
> rsQuestion.Open strSQL,strCLIENT, _
> adOpenForwardOnly, adLockReadOnly
>
> Hope this info can shed some light.
> ta
> Nimisha
>
> > Nimisha,
>
> Maybe it would be better if you specify (as you said) the type of cursor
> you
> had and other technical details of your setup.
>
> Jojo
>
> ----- Original Message -----
> From: "Nimisha" <nimisha_uk@y...>
> To: "ActiveX_Data_Objects" <activex_data_objects@p...>
> Sent: Friday, August 16, 2002 10:47 AM
> Subject: [activex_data_objects] Missing records
>
>
> >
> >
> >
> >
> >
> > Hi!
> >
> > This a very strange problem and does not happen
> > regularly..but happens it does.
> >
> > I'm using VB6,MDAC 2.7, SQL2000 and COM+.
> > I have got a dll placed in COM+ which accesses the
> > database and returns records to the exe. Sometimes,some of
> > the records are not returned for no apparent reason.No error message is
> > returned.
> > If I start up the application again, these records are
> > returned.
> > Is the problem due to MTS, SQL Server, Cursor Type????
> > MSDN does not have much help!!
> >
> > Hope someone can shed some light into the problem.
> > I put my problem across in the newsgroup a few weeks back and have got
no
> > reply
> > Ta
> > Nimisha
> >
>
Message #6 by "Nimisha" <nimisha_uk@y...> on Thu, 22 Aug 2002 09:55:08
|
|
> Nimisha, please see my comments below..
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Set objSPM = Nothing
> Set rsQuestion = New Recordset
** Set rsQuestion = New ADODB.Recordset
** (most cases, VB requires explicit reference to the ADODB library.
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> An example of the sql code, cursor type etc
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> strSQL = "SELECT UserName.* FROM Users WHERE UserID=" & CStr(UserID) _
> & " AND CompID = " & CStr(CompID) & " AND CountryID = " _
> & CStr(CountryID) & " ORDER BY Users.UserOrder"
**if CompID is VARCHAR, then make it:
** ...& " AND CompID = '" & CStr(CompID) & "'"... etc...
** ADO sometimes return values without using the single quote string
qualifier this maybe ** one of the reasons why you're encountering such
problem
>
> rsQuestion.Open strSQL,strCLIENT, _
> adOpenForwardOnly, adLockReadOnly
**please provide us also the DDL/Create Table Statement of the table you've
used (USERS) for **me to go into deeper analysis..
best regards,
ash
----- Original Message -----
From: "Nimisha" <nimisha_uk@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Monday, August 19, 2002 3:02 PM
Subject: [activex_data_objects] Re: Missing records
> Hi
> The connection string and cursor type used in my code . An example
>
> strCLIENT = objSPM.GetSPM("ClientObject", "DBConnectionString")
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> THE STORED PROPERTY MANAGER RETURNS THE CONNECTION STRING IN THIS FORMAT
> "Provider=SQLOLEDB.1;Password=;User ID=;Initial Catalog=TestDB;Data
> Source="
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Set objSPM = Nothing
> Set rsQuestion = New Recordset
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> An example of the sql code, cursor type etc
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> strSQL = "SELECT UserName.* FROM Users WHERE UserID=" & CStr(UserID) _
> & " AND CompID = " & CStr(CompID) & " AND CountryID = " _
> & CStr(CountryID) & " ORDER BY Users.UserOrder"
>
> rsQuestion.Open strSQL,strCLIENT, _
> adOpenForwardOnly, adLockReadOnly
>
> Hope this info can shed some light.
> ta
> Nimisha
>
> > Nimisha,
>
> Maybe it would be better if you specify (as you said) the type of cursor
> you
> had and other technical details of your setup.
>
> Jojo
>
> ----- Original Message -----
> From: "Nimisha" <nimisha_uk@y...>
> To: "ActiveX_Data_Objects" <activex_data_objects@p...>
> Sent: Friday, August 16, 2002 10:47 AM
> Subject: [activex_data_objects] Missing records
>
>
> >
> >
> >
> >
> >
> > Hi!
> >
> > This a very strange problem and does not happen
> > regularly..but happens it does.
> >
> > I'm using VB6,MDAC 2.7, SQL2000 and COM+.
> > I have got a dll placed in COM+ which accesses the
> > database and returns records to the exe. Sometimes,some of
> > the records are not returned for no apparent reason.No error message is
> > returned.
> > If I start up the application again, these records are
> > returned.
> > Is the problem due to MTS, SQL Server, Cursor Type????
> > MSDN does not have much help!!
> >
> > Hope someone can shed some light into the problem.
> > I put my problem across in the newsgroup a few weeks back and have got
no
> > reply
> > Ta
> > Nimisha
> >
>
Message #7 by "Nimisha" <nimisha_uk@y...> on Thu, 22 Aug 2002 10:00:25
|
|
Hi Ash
Sorry for the dealy in reply..thanks for your suggestions
It's very difficult to for me to recreate the problem as it occurs in it's
own time. The problem may not occur for weeks and suddenly it does.
But I'll implement the changes you have mentioned , hope it will solve
the issue.
Thanks again
Ta
Nimisha
> Nimisha, please see my comments below..
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Set objSPM = Nothing
> Set rsQuestion = New Recordset
** Set rsQuestion = New ADODB.Recordset
** (most cases, VB requires explicit reference to the ADODB library.
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> An example of the sql code, cursor type etc
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> strSQL = "SELECT UserName.* FROM Users WHERE UserID=" & CStr(UserID) _
> & " AND CompID = " & CStr(CompID) & " AND CountryID = " _
> & CStr(CountryID) & " ORDER BY Users.UserOrder"
**if CompID is VARCHAR, then make it:
** ...& " AND CompID = '" & CStr(CompID) & "'"... etc...
** ADO sometimes return values without using the single quote string
qualifier this maybe ** one of the reasons why you're encountering such
problem
>
> rsQuestion.Open strSQL,strCLIENT, _
> adOpenForwardOnly, adLockReadOnly
**please provide us also the DDL/Create Table Statement of the table you've
used (USERS) for **me to go into deeper analysis..
best regards,
ash
----- Original Message -----
From: "Nimisha" <nimisha_uk@y...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Monday, August 19, 2002 3:02 PM
Subject: [activex_data_objects] Re: Missing records
> Hi
> The connection string and cursor type used in my code . An example
>
> strCLIENT = objSPM.GetSPM("ClientObject", "DBConnectionString")
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> THE STORED PROPERTY MANAGER RETURNS THE CONNECTION STRING IN THIS FORMAT
> "Provider=SQLOLEDB.1;Password=;User ID=;Initial Catalog=TestDB;Data
> Source="
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Set objSPM = Nothing
> Set rsQuestion = New Recordset
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> FYI
> An example of the sql code, cursor type etc
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> strSQL = "SELECT UserName.* FROM Users WHERE UserID=" & CStr(UserID) _
> & " AND CompID = " & CStr(CompID) & " AND CountryID = " _
> & CStr(CountryID) & " ORDER BY Users.UserOrder"
>
> rsQuestion.Open strSQL,strCLIENT, _
> adOpenForwardOnly, adLockReadOnly
>
> Hope this info can shed some light.
> ta
> Nimisha
>
> > Nimisha,
>
> Maybe it would be better if you specify (as you said) the type of cursor
> you
> had and other technical details of your setup.
>
> Jojo
>
> ----- Original Message -----
> From: "Nimisha" <nimisha_uk@y...>
> To: "ActiveX_Data_Objects" <activex_data_objects@p...>
> Sent: Friday, August 16, 2002 10:47 AM
> Subject: [activex_data_objects] Missing records
>
>
> >
> >
> >
> >
> >
> > Hi!
> >
> > This a very strange problem and does not happen
> > regularly..but happens it does.
> >
> > I'm using VB6,MDAC 2.7, SQL2000 and COM+.
> > I have got a dll placed in COM+ which accesses the
> > database and returns records to the exe. Sometimes,some of
> > the records are not returned for no apparent reason.No error message is
> > returned.
> > If I start up the application again, these records are
> > returned.
> > Is the problem due to MTS, SQL Server, Cursor Type????
> > MSDN does not have much help!!
> >
> > Hope someone can shed some light into the problem.
> > I put my problem across in the newsgroup a few weeks back and have got
no
> > reply
> > Ta
> > Nimisha
> >
>
|
|
|
View Cart
