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(at)verizon(dot)net>
To: "Sandro Yaqub Yusuf" <sandro(at)proservvi(dot)com(dot)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(at)proservvi(dot)com(dot)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(at)postgresql(dot)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(at)proservvi(dot)com(dot)br]
>> Sent: Monday, October 04, 2004 3:13 PM
>> To: pgsql-odbc(at)postgresql(dot)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(at)verizon(dot)net
> Gentoo Linux
> Registered Linux User #193859
>
> .~.
> / v \
> /( _ )\
> ^ ^
> In Linux we trust!