Re: Executing SP in VB6

Hello my friend,

I know.
I have worked with VB about 6 years. I´m using ACCESS, ORACLE, SQL_SERVER,
XBASE integrated with Visual Basic.
Now, for my experience, I would like to use PostGresQL with VB6. OK ??!!

Thanks for you colaboration.

Sandroyy


----- Original Message -----
From: "Rick Sivernell" <res005ru@verizon.net>
To: "Sandro Yaqub Yusuf" <sandro@proservvi.com.br>
Sent: Monday, October 04, 2004 1:07 PM
Subject: Re: [ODBC] Executing SP in VB6


> On Mon, 4 Oct 2004 16:24:33 -0300
> "Sandro Yaqub Yusuf" <sandro@proservvi.com.br> wrote:
>
>> Hello my friend,
>>
>> That is simple. I work developing programs in Visual Basic using complex
>> Stored
>> Procedures in SQL-SERVER 7/2000. I want to make STORED PROCEDURES in
>> PostGresQL
>> using Visual Basic 6. I need one example to begin.
>>
>> Thanks,
>>
>> Sandroyy
>>   ----- Original Message -----
>>   From: Goulet, Dick
>>   To: Sandro Yaqub Yusuf ; pgsql-odbc@postgresql.org
>>   Sent: Monday, October 04, 2004 4:15 PM
>>   Subject: RE: [ODBC] Executing SP in VB6
>>
>>
>>   May I ask why you want to use a stored procedure?  A simple "Select
>> fullname from
>>   users where user = '<value>';" should work just fine.
>>
>>   Dick Goulet
>>   Senior Oracle DBA
>>   Oracle Certified 8i DBA
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>>   From: Sandro Yaqub Yusuf [mailto:sandro@proservvi.com.br]
>>   Sent: Monday, October 04, 2004 3:13 PM
>>   To: pgsql-odbc@postgresql.org
>>   Subject: [ODBC] Executing SP in VB6
>>
>>
>>   Hello,
>>
>>    Please, I just trying search in all WEB SITES about using STORED
>> PROCEDURES with
>>   VISUAL BASIC, but I not found anything about this that can help me.
>>
>>   I have a table: USERS with colums IDUSER, USER, PASSWORD, FULLNAME
>>   I need get the colum FULLNAME with parameter USER.
>>   How I do to create and execute a STORED PROCEDURE in VISUAL BASIC 6 to
>> resolve
>>   this litle problem ? (please, forgiven my english because I live in
>> BRAZIL and
>>   not speak english).
>>
>>   Thanks,
>>
>>   Sandroyy
>>
>>
> Sandro
>
>   You do not need to use stored procedure, VB has database objects for you
> to use.
> Personally I would use C++ and OLE DB. It is much better, faster and if
> you are
> working across OSes, you still connect to db using odbc. From your
> description your
> are on M$. ODBC or OLE DB do not care what the database is, as long as
> there is a ODBC
> driver. There are plenty of examples in books and on the net.
>
> cheers
>
> --
> Rick Sivernell
> Dallas, Texas  75287
> 972 306-2296
> res005ru@verizon.net
> Gentoo Linux
> Registered Linux User #193859
>
>   .~.
>  / v \
> /( _ )\
>   ^ ^
> In Linux we trust!