Skip site navigation (1) Skip section navigation (2)

Re: Executing SP in VB6

From: "Sandro Yaqub Yusuf" <sandro(at)proservvi(dot)com(dot)br>
To: "Rick Sivernell" <res005ru(at)verizon(dot)net>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Executing SP in VB6
Date: 2004-10-04 21:52:53
Message-ID: 007d01c4aa5c$806396e0$9414a8c0@proservvi.com.br (view raw or flat)
Thread:
Lists: pgsql-odbc
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! 


pgsql-odbc by date

Next:From: Andrew AyersDate: 2004-10-04 23:29:18
Subject: Re: Executing SP in VB6
Previous:From: anthony.cadutoDate: 2004-10-04 21:39:03
Subject: Access and PG ODBC problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group