Recent content by mateos2

I will follow all your advices Thanks for all

Thanks I thought that mantaining the Connection alive was more efficient than reconnect to DB, this will help me?, if yes then, what do I do with the ADO Command?, I will need to recreate it too? This is because I create the ADO Command at program Startup, then I just pass the parameters and...

Sorry I write bad the question. I create the "Command" to hold the Stored Procedure I do that at program Startup Here is the code for the Command preparation Private Function Prepare_Procesos_Command() As Boolean Set m_comProcesos = New ADODB.Command With m_comProcesos...

Hello I have a program that inserts records to a SQL Server 2000 Database, it inserts the records through a Stored Procedure, the program calls the Stored Procedure a lot of times. The problem is that the memory that SQL Server uses begins to grow constantly while the program is running until...

Hello. I want to create a SP that receive some input parameters and return a output parameter of type cursor. That cursor is not from a SELECT statement, I want to create my custom Cursor. It´s that possible Thanks

You can try reading when the number of bytes recibed, ex Private Sock_DataArrival(...= if bytestotal = 4 then read end if or Sock.PeekData This don't delete the data from the buffer then you can read until you want and use a GetData to clean a buffer If this this don't help you...

Use the GetVersion APi, That's All

Exist a RDBMS 100% ANSI SQL? Where I can find information about ANSI SQL? Exist a new SQL ANSI standard? Thanks