VB6 code to communicate with SQL Server 6.5

In Progress

VB6 code to connect to SQL Server 6.5 and retrieve some info:

- the code should use ADO 2.5 - it should have reference to Microsoft ActiveX Data Objects 2.5 Library

- connect to SQL Server 6.5, using either password protected connection or not

- get list of all databases in given server

- get list of all tables in given database

- get list of all stored procedures, functions, views, triggers and relationships

- get list of all fields in given table, and their properties (i.e. properties of the fields - what type they are, are Nulls allowed, etc)

- read and display the content of given table (display data stored in given table)

Sample application, which is using all mentioned above code, is to be delivered.

Code is to be commented - each Subroutine and Function has to have comments at the top specifying what it is supposed to do, which parameters it is taken and what it is returning. Also comments should specify the assumptions about passed values (if there are any).

Coding conventions:

- for passed parameters in subs and functions: they need to be specified if they are passed ByVal or ByRef; they should have prefix "p"

- all local variables should have prefix "l"

- after prefix "l" or "p" there should be 3 letters indicating type of the variable, for example:

int for Integer

lng for Long

dbl for Double

bln for Boolean

Examples:

llngCount - local Long variable

pdblAmount - passed Double variable

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

All 32-bit versions of Windows which have ADO 2.5 installed.

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL, Visual Basic

See more: what is sql coding, what is package in sql, what is a 32 bit integer, sql server web, server side coding, sample reference letters, reference letters, prefix under examples, prefix top, prefix function, php examples with source code, p.c. connection, letters of reference, letters of application examples, examples of reference letters, examples of application letters, c code examples, sql server or, p sql, boolean sql server, c++ code examples, subs, sql views, sql l, Microsoft SQL server

About the Employer:
( 2 reviews ) Canada

Project ID: #3704986

Awarded to:

prateeknigamvw

See private message.

$42.5 USD in 7 days
(38 Reviews)
4.5

20 freelancers are bidding on average $58 for this job

atixvw

See private message.

$85 USD in 7 days
(232 Reviews)
8.5
creativexso

See private message.

$80.75 USD in 7 days
(81 Reviews)
5.9
aliweb

See private message.

$29.75 USD in 7 days
(55 Reviews)
5.2
ammadgates

See private message.

$21.25 USD in 7 days
(19 Reviews)
5.1
jondlar

See private message.

$55.25 USD in 7 days
(41 Reviews)
4.8
saqibsaeedkhan

See private message.

$34 USD in 7 days
(26 Reviews)
4.4
amy34

See private message.

$38.25 USD in 7 days
(13 Reviews)
3.1
designz4web

See private message.

$85 USD in 7 days
(12 Reviews)
3.2
digglek

See private message.

$25.5 USD in 7 days
(5 Reviews)
2.5
prosoftsystemsvw

See private message.

$59.5 USD in 7 days
(12 Reviews)
2.6
kjignesh82

See private message.

$68 USD in 7 days
(4 Reviews)
2.3
canadianguyvw

See private message.

$76.5 USD in 7 days
(1 Review)
1.5
codingmachinevw

See private message.

$59.5 USD in 7 days
(1 Review)
0.9
realsolutionsvw

See private message.

$55.25 USD in 7 days
(0 Reviews)
0.0
waqarkhan2002

See private message.

$46.75 USD in 7 days
(0 Reviews)
0.0
vw1532413vw

See private message.

$76.5 USD in 7 days
(0 Reviews)
0.0
er5plus

See private message.

$59.5 USD in 7 days
(0 Reviews)
0.0
mohabed

See private message.

$85 USD in 7 days
(0 Reviews)
0.0
awais1985

See private message.

$85 USD in 7 days
(0 Reviews)
0.0