VB script for SQL database
Hi, I was someone could give me some direcion on a project I am doing.
I am trying to distribute an SQL database. I have have coursework in C++
and visual basic but do not own Visual studios,just Visual InterDev.
I need a program in visual basic or visual C++ that displays information
from the SQL database.
The database can be MSDE Microsoft Data Engine.I need to write (or have someone
partially write) the program as well as an installation program to redist
the necessary files to run the program. (i.e. The exe itself, the VB runtime,
the MSDE engine, and any other required files)
Since I am just starting I do not have access to alot of resources and am
looking for the most efficient way to accomplish the task.
The task is to redistribute an SQL database thru the internet to other cmputers
that may or may not have SQL installed so that they may query it.
Can you be of any assistance? I would appreciate any help you can give.
jim
Re: VB script for SQL database
Jim,
A couple of questions:
1) Is it a requirement that you use SQL Server as the databse? Would and
Access Database be acceptable - the reasoin for asking is the Access is the
Native database which Visual Basic supports, and as such, there is NO REQUIREMENT
for the User to actuall own Access outright, your program can create and
manage the Access Database files totally independent of an actual installation
of the full Access program.
2) Does the data that you are going to be working wqith already exist
or will you be starting out from the very beginning. If it already exists,
how much data are you going to be dealing with?
As a aside, you will be much more likely to get the assitance that you
need, as you say "Since I am just starting ", if you post your questions
in the VB.Getting.Started discussion group.
Arthur Wood
"jim" <cancane1@aol.com> wrote:
>
> Hi, I was someone could give me some direcion on a project I am doing.
>I am trying to distribute an SQL database. I have have coursework in C++
>and visual basic but do not own Visual studios,just Visual InterDev.
>I need a program in visual basic or visual C++ that displays information
>from the SQL database.
>The database can be MSDE Microsoft Data Engine.I need to write (or have
someone
> partially write) the program as well as an installation program to redist
>the necessary files to run the program. (i.e. The exe itself, the VB runtime,
>the MSDE engine, and any other required files)
>Since I am just starting I do not have access to alot of resources and am
>looking for the most efficient way to accomplish the task.
>The task is to redistribute an SQL database thru the internet to other cmputers
>that may or may not have SQL installed so that they may query it.
>Can you be of any assistance? I would appreciate any help you can give.
>jim