client server database application

[developerno1]

hello guys,
im stuck in making a client server based database application using vb6 and sql. is it possible and easy to do??can anyone please upload such a project jst demonstrating the basic way of doing it or may be give a link to such a project i shall be very thankful to you .......
bye.....

[si_the_geek]

It is definitely possible, but whether or not it is easy depends on what you mean by "client server based".

A phrase like that can be interpreted in many ways, especially when it comes to databases.

If you give us more detail about what kind of system you want, we can give you apt advice.

[developerno1]

thnks for the rply si_the_geek, what i want is to have a simple database based patient information storage system to be able to work on a lan. i.e as we use a database management software in one pc using access databse , i want it to work on a network of 20 pc's connected through lan. so once installed the program could be run on any and all of the computers simaltaneously with a single database so a change from any of them is immediately reflected on all the connected computers. Hope you understand my requirement...........
what ive found out is access is not opt for more comps and larger databases so ive decided to use Sql server 2000. now how shall i proceed??? please help me
waiting for a reply................byeeee

[GaryMazzone]

There are examples in the FAQ section of the Database Area that go though a complete demo of using VB with a database

[si_the_geek]

Yep, the main ADO Tutorial uses Access, but to convert to SQL Server all you need to do is change the Connection String - see the link in my signature for examples of the kind of thing you need.


In terms of having multiple users, you need to be more careful than you might have been with a single user version. See the FAQ article about "Recordset.Open parameters" for some advice, and also avoid setting CursorLocation to adUseClient.

If you currently get more data than you need from the database, you should think about ways to only get the data you need (such as using an apt Where clause when you open a recordset).

[developerno1]

GaryMazzone-----There are examples in the FAQ section of the Database Area that go though a complete demo of using VB with a database

thanks bt could you please point me to the example or a working project, i coulnt locate it in the faq. sorry for inconvenience........

[GaryMazzone]

look here

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

[developerno1]

kk after reading a bit i started to connect my vb app tp a sql database, the connection string i used is probably incorrect , my code is

conn.ConnectionString = "Provider=sqloledb;" & _
           "Data Source=D:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf" & _
           "Initial Catalog=master.mdf;" & _
"User ID=sa;password=sa"
conn.Open

bt its giving errror "[connection error(parseconnectparams().Invalid connection]"
plz tell me the connctn string, i couldnt understandd one given at connectionstrings.com

[si_the_geek]

That should be OK if you get the details right..

Data Source is the Server name (or IP address)

Initial Catalog is the name of the database as it is registered on the server, which is shown in Enterprise Manager (note that it can't be "Master", as that is a system database).

Note also that you should never use the "sa" account from a program (instead create a new user with the rights you need), and should not have a simple password for the sa account either (but of course hopefully you just changed the password in your post).