Re: access to sql server whith vb5.0

Troy Locke ( (no email) )
Wed, 3 Jun 1998 13:34:08 -0500

I too have a VB5 program with similar functionality. It also duplicates the
online tab of emerald. Has various graphs, such as new users by day/week.
A port from emerald to the NT SAM for username, and passwords. An a sync
feature from emerald to MCIS 1.0/ 2.0 in the works.

It uses an ODBC connection to login to SQL Server.

If you would like to see an example of the login. Get my Emerald to SAM
conversion utility at
create an ODBC DSN named emerald, install and run the program.

Troy Locke

-----Original Message-----
From: Lawrence Watkins Work <>
To: <>
Date: Wednesday, June 03, 1998 9:19 AM
Subject: Re: access to sql server whith vb5.0

>I would like to see what you have done. I have been writing
>a similar program, all web based written in ASP, although it
>does not have the accounting part finished as of yet. I
>have been recently converting it to a VB5 program.
>Lawrence Watkins
>-----Original Message-----
>From: Paul Rensel <>
>To: <>
>Date: Tuesday, June 02, 1998 11:26 PM
>Subject: Re: access to sql server whith vb5.0
>>We've build our own "Emerald" like program in Vb5.0
>Enterprise, it works
>>Plans are to put the program in the public domain to
>enhance further
>>developement by others. Anyone interested ?
>>What it does ?
>>- add/modify/deleter users in the RadiusNT SQL database
>>- print registrationsheets
>>- generate, print/email invoices
>>- export invoicedata to external accounting package
>>- overview of online users
>>Additional scripts (ASP) which
>>- provides overview of user activity (login times, dates
>>- provides overview of dynamic user homepages (i.e. no-pay,
>no homepage
>>- automatic IE4 configuration based on Radius database
>>We've build this package for our ourselves primarily
>because Emerald didn't
>>support all the gadgets we needed with our external
>accounting package.
>>Best Regards,
>>Paul Rensel
>>-----Original Message-----
>>From: vincent b <>
>>To: <>
>>Date: woensdag 3 juni 1998 11:11
>>Subject: access to sql server whith vb5.0
>>>is there somebody who have alredy made a graphic interface
>whith vb5.0
>>>to access on a sql server and use the sql server's
>>>Get Your Private, Free Email at