Invalid Object Name

Hi,
My application uses VB6 and Sql-Server 2000.
I cant understand why the error
INVALID OBJECT NAME Run-time error '-2147217865 (80040e37)'
appears only sometimes and not always. For example, a select instruction is executed inside a loop without any problem 1 thousand times, then when I try to execute it 1 thousand times and one, it fails.


Have you got any suggestions?

Ive read a lot of posts on Internet Forums, without finding any solutions.

In the mail I attach, you can see that the application stops at 79%, after having executed many times the select instruction without any problem!

Thank you very much for your help!

Bye,

EmanuelaWhat attachment?

Just post the code here...but my guess is you're building dynamic sql|||Without seeing it I too am guessing dynamic SQL, but I reckon the problem lies in the length/size of a variable you've declared. Varchar(50) for example|||Here is the code:

Dim Con As ADODB.Connection

Set Con = New ADODB.Connection
Con.ConnectionString = "driver={SQL Server};server=OIVN303;uid=NIS_adm;pwd=nisdb04;dat abase=ZET"
Con.ConnectionTimeout = 3000
Con.Open

Set CreaConnessioneDB = Con

Dim Rs3 As ADODB.Recordset

Set Rs3 = New ADODB.Recordset
Rs3.CursorType = adOpenKeyset
Rs3.LockType = adLockOptimistic
Rs3.ActiveConnection = Con

Sql3 = "SELECT * T_NUM_E1_OMC_PER_OFFICE
Rs3.Open Sql3
If Not Rs3.EOF Then
Num_Tot_TRX = Rs3(0)
Num_Min_E1_GSM = Rs3(1)
End If
Rs3.Close

Set rs3 = nothing

...

Sorry, no attachment.

Thanks very much to everybody can help me!,
Bye,
Emanuela|||Sql3 = "SELECT * T_NUM_E1_OMC_PER_OFFICE

SURELY this is wrong.
No FROM and no closing quote (")?!|||Ok, I made a mistake during copy and paste:
Obviously the correct statement is:
Sql3 = "SELECT * FROM T_NUM_E1_OMC_PER_OFFICE"

A part from this, can you help me?|||That's it?

No Predicates?

Why not use Stored Procedures in any case?|||CreaConnessioneDB

Another typo?

Fancy pasting this loop you speak of that's causing the problem?sql

invalid authorization specification error? Frontpage DB wizard

I have searched high and low to find out what this means... and I can't. My
connection to the SQL server from Frontpage 2003 database wizard worked then
suddenly didn't. What did I inadvertently change... if anything... Sounds
like an SQL isn't letting me retrieve..but I have no idea why...
Help
"Cheryl" <Cheryl@.discussions.microsoft.com> wrote in message
news:71C7C35F-BA9F-4F25-81D5-8BB3E6005A63@.microsoft.com...
>I have searched high and low to find out what this means... and I can't. My
> connection to the SQL server from Frontpage 2003 database wizard worked
> then
> suddenly didn't. What did I inadvertently change... if anything... Sounds
> like an SQL isn't letting me retrieve..but I have no idea why...
> Help
What error message is being reported back by Frontpage?
Is the SQL Server running?
Did you install any service packs, upgrades, other software?
Rick Sawtell
MCT, MCSD, MCDBA
|||That was what the browser was reporting: invalid authorization specification
in the database results wizard... Yet, when I coded my own connection instead
of using the wizard on a page.. It worked fine...
When I changed the authentication method on the server to send in clear text
as per:
http://support.microsoft.com/default...;en-us;Q247931
It seemed to start to work again... Yet I recalled re-setting nothing of the
sort...
I was lead here by changing trusted_connection to yes and following the
message from there...
"Rick Sawtell" wrote:

> "Cheryl" <Cheryl@.discussions.microsoft.com> wrote in message
> news:71C7C35F-BA9F-4F25-81D5-8BB3E6005A63@.microsoft.com...
>
> What error message is being reported back by Frontpage?
> Is the SQL Server running?
> Did you install any service packs, upgrades, other software?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Hmmm..
Glad you got it working again.
I wonder if you have automatic updates turned on and it installed a service
pack for IIS or IE that may have reset that value...
Rick
"Cheryl" <Cheryl@.discussions.microsoft.com> wrote in message
news:FFA1F56D-C150-4665-AB3F-D4FDEC749002@.microsoft.com...[vbcol=seagreen]
> That was what the browser was reporting: invalid authorization
> specification
> in the database results wizard... Yet, when I coded my own connection
> instead
> of using the wizard on a page.. It worked fine...
> When I changed the authentication method on the server to send in clear
> text
> as per:
> http://support.microsoft.com/default...;en-us;Q247931
> It seemed to start to work again... Yet I recalled re-setting nothing of
> the
> sort...
> I was lead here by changing trusted_connection to yes and following the
> message from there...
> "Rick Sawtell" wrote: