Give me better way to do it with remote database

[jsssss]

Hi there

I am new in VB.net.
I want to create a program which work on local Wi-Fi. remote database
In this pogram there r 10 to 15 client computers are connected with a server computer. Each client have a local database (.mdb). And server will work with sql.

Each client user is entering the data in its local database and the server is getting that data from the client database (.mdb) to its own database.
The client entering the data in a table of local Access database(.mdb). and the server is getting that data from the table and placing it in there

own database table and remove the client table data after copy to server databse table.

the server program have to work with 10 to 15 client databases.

i think the client program will be HANGED or IDEL when the server get the data from the client. beacuse on the same time the client is entering

the data in table and the server is getting the data and removing it. It may conflict and the program will make problem

tell me what techniqe or what is the better way to achive the goal.

[kleinma]

Why can't the clients connect to the SQL Server? Why bother even using access databases?

[jsssss]

i don't understand what your meaning.

but i want to tell you that. there is a company using this type of software on wi fi. the detail of that software was told by me.

and they are facing that problem of HANG or IDLE

now i want to create the better software for that company so they may give me work in future

so i think. i have to use the same type of database for client(.mdb) and for server(sql)


guide me what can i do for best

[dminder]

The question is why are you using 2 different databases? Unless you are experiencing network connectivity issues there is really no reason to be using 2 totally different databases. In my experience, it doubles the work, increases the chance of failure for coding as well as database integrity.

While I understand that there is software out there that may do this already, that does not mean it is the best or most efficient way to accomplish the task. My suggestion is (if you have not done so already) to sit down and flow out how your program should/will work. From the time the user starts it, through all of your data ins and outs right down to exiting the program. This will help you decide the best course of action to take.

If the SQL server is setup correctly you will have minimal delay when updating across a network - you can also setup the updates (both to and from the server) to work off of background worker threads. This will help to reduce/eliminate "hang" or "idle" issues.

Without knowing more about what it is you are looking for, I am not sure that we can be of more assistance. If you run into specific issues with coding that is where we (mostly others such as kleinma ) are the most help. I know I for one have enough of a time designing my programs let alone somebody elses!!

For those celebrating it - HAPPY 4th of JULY!!!
To everyone else, I wish you happy coding!!

D

[jsssss]

thankx and thank you very much
dminder

know i will focus on my work

but if in coding any problem will arise can you help me in future. because the VB.NET is diffrent from VB6

[kleinma]

jsssssss,

Even if the project was to be done in VB6, I would still only use one database.

[jsssss]

can sql2000 receive multiusers data at same time.

[kleinma]

yes, multiple people can connect to and read/write to the database at a given time.

[dminder]

Sql can handle as many connections as you have licenses for it. It is extremely important to remember while coding that when you are finished with a call to the database (does not matter if it is for a retreive, update, add, delete, whatever) that you close that server connection so that it keeps those licenses/resources free for others to use. Can ya guess what I have had to do the past few days??

Good Luck!!

D

[jsssss]

thanks for reply

i am working on a project.
in that project there is a SQL2000 database on a computer and 15 other computers are connected. the target is to send the data from client to server

i have 2 ways to achive the goal. please tell me which one is good.

one is that the client software send data to sql database directle

and another is that the client software place the data in local database like (mdb) and the server software get the data from the client database.

all the work is done on Lan connection

help me

[dminder]

Again - as stated above a while ago, why would you put anything, especially another database type in the middle of what you are doing? It will take up time, potentially cause errors and will double your development time. You should connect to your SQL Database directly - if the server itself is setup correctly then security should not be an issue.

Personally, I have a class that is nothing but data related subs, functions, etc. There is 1 function that I use repeatedly to open the database connection (1 global variable) and 1 that use to close the same connection (less code repetition) when I am through with it. This is what I have found to be the fastest, safest and best route overall.

D

[jsssss]

please give me a little codding example to connect a client to sql database directly.

thankx

[jsssss]

please send me a small example

[thered]

Hi Jssssss
I suggest you start with these:

http://www.vbforums.com/showthread.php?t=306750

[jsssss]

hi there

i need help again

now i am working on a new school software also.
i want to know that

I Want to connect to access database using DATAENVIRONMENT of visual basic6. I am using Microsoft jet 4.0 provider. I place a password on access database "ABC" . i have also given the user name and password in the DATA LINK PROPERTIES >>connection. but it does not connect to database and show error message.

what i have to do.


*******************************************
i have a question for the previous discision of SQL2000 software.

In client/SERVER software . there are number of users who are remotely using MS SQL SERVER 2000.

Wheather i create seprate table for each user or use single table for all users.
Data sent to server by all users is same.

If i create a single table for all users wheather it will be a slow process in storing the data or it will conflict with each other while storing.


thankx

[thered]

Hi Jesssss,

Sorry I cannot help you with VB 6.

But the SQL server, when you say “remotely using“; is it over the internet or an off line database?

If it is the same data that is been updated in an offline database; & two people update it at the same time. Is it acceptable just to take the latest update?

If it is the same data for each user, it would make sense to use the same table for all users, and keep logs of all data changes so conflicts can be resolved when you synchronise.

If i create a single table for all users wheather it will be a slow process in storing the data or it will conflict with each other while storing.

How many users are you talking about? Servers like e-bay take many transactions per second. In the telecoms industry all phone call are logged onto a single SQL server for the entire phone network.

[jsssss]

thankx for reply


there are 5 to 25 users input the data at same time to sql2000 server

it is not on internet. it is LAN networking

each user is storing the data like NAME AMOUNT ADDRESS PHONE_NO
to sql2000 database.

and also please tell me.
i am develpoing that software at my home computer without networking.
it is working very well with Loacl SQL database now.
i want to place the code that will help me to work on networking when i implement the project to the user office.

what will be the format of the REMOTE Connect

[thered]

It will depend how the server is configured, check how they connect with there current configuration.

If you have login permissions on the server and allocate permissions to the database for authenticated users then you can use the same Integrated Security; else create a user on the database.

I normally create an options page where you can select how you authenticate; the format is:

        ' Set database options
        If m_Options.UseIntSecurity Then
            LOCAL_CONNECTION_STRING = _
                 "Server=" & m_Options.LocalSQLServer & "," & _
                 m_Options.LocalPort & ";" & _
                 "DataBase=" & m_Options.SQLDB & ";" & _
                 "Integrated Security=SSPI;Connect Timeout=5"
        Else
            LOCAL_CONNECTION_STRING = _
                    "Server=" & m_Options.LocalSQLServer & "," & _
                    m_Options.LocalPort & ";" & _
                    ";User ID=" & m_Options.LocalUser & _
                    ";Password=" & m_Options.LocalPassword & ";" & _
                    "DataBase=" & m_Options.SQLDB & _
                    "; Connect Timeout=5"
        End If

[thered]

each user is storing the data like NAME AMOUNT ADDRESS PHONE_NO
to sql2000 database.

Use a single table; you will not have any problems.

[jsssss]

This code not work

connSQL = "Driver={SQL Server};server=127.0.0.1;database=MYDB;uid=SA";


****but this code work

connSQL = "Driver={SQL Server};server=B3Y8Z9;database=MYDB;uid=SA";


i am working now on my own computer with SQL2000. but in the Office the database sql is not local. so how can i manage or what chages i have to made.

please give me a perfeact string