[raziel_]

in your connection string there is an IP to where your DB is example:

        "driver={MySQL ODBC 3.51 Driver};" & _
        "server=" & m_SERVER & ";" & _
        "port=" & CStr(m_IPPORT) & ";" & _
        "user=m_User; pwd=m_Password;" & _
        "database=" & m_DBNAME & ";" & _
        "charset='cp1251';" & _
        "OPTION=" & CStr(CNNOPTIONS) & ";"

Put PC1 IP for m_Server, the port to connect (usually 3306) for port etc.

hope it help you

[raziel_]

nope you just need ODBC connector installed for other computers. you can download it here

[raziel_]

well usually install it make your connection string to your program and connect to the database.

[Motoma]

evry1falls, on 02 June 2010 - 06:15 PM, said:

i want that when i work in pc2 or 3 or 4 the data added to the database tables in pc1 .... ??

how can i do that ? or where can i learn that ??

It sounds to me like what you are trying to learn about is SQL Replication. This is how a single database can be spanned across multiple physical machines.

Hope this points you in the right direction,
Motoma

[raziel_]

connection string firs line:

 "driver={MySQL ODBC <insert version here> Driver};" & _

if you want to connect to the server where your DB is you need this installed on other machines . also you will need the IP of the server the port to connect (usually 3306) witch you can make the user to enter and save them in some file. so the user may connect to other server to without you have to change the exe.

Replication on other hand is used for synchronizing databases usually server-to-server. for example several small local machines(for a city) databases are synchronized in a main server(for the state). do you even try it?

This post has been edited by NoBrain: 09 June 2010 - 03:02 PM

[Motoma]

evry1falls, on 10 June 2010 - 09:04 AM, said:

now ... i will set the sotware up on the 3 other pcs ... how can i use this sql server 2000 database ?? without installlin sql server 2000 on the other 3 pcs ???

something like server to clients !!
so all the data from the 4 pcs will go into the one database on the pc that holding it (Server) ... is it possible ???

As was mentioned earlier in the post, you will need to change your software's connection string on the three other computer to point to the database on the server.

This is dependent on the language/software you are using, but you would typically do this where the connection is initialized or created.

[raziel_]

exactly + they (the other PCs) need ODBC installed.

[raziel_]

i think i miss something ... if you connect the way we tell you the user will work directly with the database on the server. for example if user from PC3 make a query to add info in some table( INSERT INTO SomeTable VALUES(Value1, Value2...)), lets say using your program, it will effect the main database on PC1. what data you want to transfer? the idea of SQL is to connect to remote server database and the user to not have local database.

This post has been edited by NoBrain: 10 June 2010 - 03:44 PM