Connecting from VB6 to a remote Oracle Database (Q/A)

Posted by NosaLee in Oracle, VB6 Programming on 13-06-2012. Tags: , , , , , , ,

Q by Gcasner
We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect stat[......]

Read More…

Logon automation (Q/A)

Posted by NosaLee in VB6 Programming on 13-06-2012. Tags: , , ,

Q by Blowerycolumbus
I have several programs that where written in vb6 that are now required to be automated through a scheduler. It has been a while since I coded in vb6 and need to know a way to get access to the current logged on users credentials to pass on to a database loggon. the Oracle datab[......]

Read More…

database access (Q/A)

Posted by NosaLee in VB6 Programming on 13-06-2012. Tags: , , ,

Q by vijaycse
how can i connect to a ms access database which resides on other computer in a network using vb6.0
Re by CharlesJC
1. Place the database in a directory the is accessible to the user running the program. 2. In your VB project, add a reference to the Microsoft ActiveX Data Objects 2.[......]

Read More…

dynamic visual basic form based on access database table (Q/A)

Posted by NosaLee in VB6 Programming on 08-06-2012. Tags: , , ,

Q by YitoGraft
I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don’t want to have to[......]

Read More…

need help in vb code (Q/A)

Posted by NosaLee in Oracle, VB6 Programming on 08-06-2012. Tags: , , , , , , ,

Q by rosy99
Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example [......]

Read More…

VB app connecting to Oracle database (Q/A)

Posted by NosaLee in Oracle, VB6 Programming on 08-06-2012. Tags: , , , , , , ,

Q by skovac
I have a custom VB application that connects to an Oracle database (9.2.0.5). It inserts records into an interface table then disconnects from Oracle. The VB app is on about 400 PCs with about 5000 inserts into the interface table daily. My question is having this app connect and disconn[......]

Read More…

Oracle database authentication in VB (Q/A)

Posted by NosaLee in Oracle, VB6 Programming on 06-06-2012. Tags: , , , , , , ,

Question by wanaug
Hullo every one. Am programming in VB6 and connecting to an oracle db. How can I get the database to authenticate users, maintain all the specified privileges in the database from my application?
Thanx!
Wana
____________________________________
Replied by costevet
When you connect[......]

Read More…

How to scroll to the specified row/item in ListView control of .NET and VB6

Posted by NosaLee in .NET Programming, VB6 Programming on 25-04-2012. Tags: ,

Author: Nosa Lee
Original Address: http://www.seeksunslowly.com/dot-net-vb6-listview-scroll-row
To reprint this article, please indicate the source, thank you.
_____________________________________
Sometimes, we need to scroll a row/item to a visual position in ListView control (.NET: View property [......]

Read More…

The easiest and best way to write/read application data in VB6 (compare Registry, database and configuration file)

Posted by NosaLee in VB6 Programming on 30-08-2011. Tags: , , ,

Author: Nosa Lee
Original Address: http://www.seeksunslowly.com/vb6-write-read-application-data
To reprint this article, please indicate the source, thank you.
_____________________________________
This method has a premise: the application data is not complicated, usually is some simple configurati[......]

Read More…

The easiest and perfect way to open web page/URL (includes mailto protocol) and methods contrast in VB6

Posted by NosaLee in VB6 Programming on 29-08-2011. Tags: , , ,

Author: Nosa Lee
Original Address: http://www.seeksunslowly.com/vb6-easiest-perfect-open-url-mailto-methods
To reprint this article, please indicate the source, thank you.
_____________________________________
First, list three common ways for opening web page/URL:
1. Use Win32 API
123456′ API decla[......]

Read More…