HELP- VB6/SQL7 - sp problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

HELP- VB6/SQL7 - sp problem

Author

Topic

JP_xpto
Starting Member

10 Posts

Posted - 2002-11-14 : 06:29:57

I've this SQL7 SP called by a VB6 app, that in some computers work and in other not...? The app have other sp calls and they work fine, so the problem isnt about the components (MDAC,etc...).
In VB6 i have this:


If MsgBox("Are you sure?", vbYesNo, TituloBox) = vbYes Then
  Set adoComando = New ADODB.Command
  With adoComando
    .ActiveConnection = mConnect
    .CommandType = adCmdStoredProc
    .CommandText = "sp_ANd_IDAnom_Diarias"
    .Parameters.Append .CreateParameter("@IDAnom", adInteger, adParamInput, 9, sIDAnom)
    .Parameters.Append .CreateParameter("@DelData", adDate, adParamInput, , Format(Date, "dd-mm-yyyy"))
    .Parameters.Append .CreateParameter("@DelUser", adVarChar, adParamInput, 5, vperfil)
    .Parameters.Append .CreateParameter("@Tcontr", adChar, adParamInput, 1, sTContr)
    .Execute
    .ActiveConnection = Nothing
  End With

My sp is like this:


CREATE procedure sp_ANd_IDAnom_Diarias
@IDAnom int,
@DelData datetime,
@DelUser varchar (5),
@TContr char (1)
as
Set nocount on
Insert TABAN01
select IDAnom,Moeda,Empresa,Nucto,Nucta,Cdata,ValorAN,Obs,UserLog,Lanc,Docum,@DelData,@DelUser,@TContr
from TABAN00
Where IDAnom=@IDAnom
Delete 
From TABAN00
Where IDAnom=@IDAnom

The error i get from some computers (under W95, but not all gave this error):
DBNMPNT-Specifield SQL server not found
I've search in the web for adicional information, but they dont apply to this case...
I need help....:(

Andraax
Aged Yak Warrior

790 Posts

Posted - 2002-11-14 : 06:32:20

Do the other sp calls use the same connection?? Sound to me like the computers you mentioned cannot reach or resolve the server.

JP_xpto
Starting Member

10 Posts

Posted - 2002-11-14 : 06:36:42

quote:

Do the other sp calls use the same connection?? Sound to me like the computers you mentioned cannot reach or resolve the server.

Yes they do... its a strange thing... The only clue i have is that all the others sp dont make two transactions like this (Insert/Delete), but i think the code of the sp is OK, or else didn't worked in other machines. The other clue i have is that the 2 machines that gave this error are the slowest of all.

Edited by - JP_xpto on 11/14/2002 06:43:26

Edited by - JP_xpto on 11/14/2002 06:44:19

JP_xpto
Starting Member

10 Posts

Posted - 2002-11-14 : 07:19:41

...i've compiled again the code and now all things run well... i didnt changed even a comment... And if the other exe was corrupt, why only in that computers didnt work? And why only in that sp, after all the program is very complex and hard writed (2.600KB).
MS made it again :)

Edited by - JP_xpto on 11/14/2002 07:20:33

Andraax
Aged Yak Warrior

790 Posts

Posted - 2002-11-14 : 08:09:42

Yeah that's strange. But computers have always been irrational so

Lavos
Posting Yak Master

200 Posts

Posted - 2002-11-14 : 09:47:46

If I had to guess, the procedure decided to rebel against the CPU, and it wasn't until the program was reloaded that such dangerous thoughts were removed. Fortunately, the game-grid didn't have to be used to correct it.

----------------------
"O Theos mou! Echo ten labrida en te mou kephale!"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources