Re: SQL Server 2000 - Remote

Posted 05 June 2010 - 06:21 PM

thnx nobrain for your answer, but this is not what i wanted to know , actualy all Pcs are connected through Network .. My Thing is .. i want to know ( do i need to install Sql Server 2000 on the other 3 pcs??) ... if not , then how ???

Re: SQL Server 2000 - Remote

Posted 09 June 2010 - 02:56 PM

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?

Re: SQL Server 2000 - Remote

Posted 10 June 2010 - 08:04 AM

NoBrain ... Look
why do u insist that im using internet .... i don't
Also ... i didn't use Mysql in my sotware ..... at all !
and the replication thing was something else .... very far away from what im loooking for ... !!

i dunno what is so hard about it !?? im sure there are plenty of softwares that running the same idea as mine ,,,,

again .. maybe i messed something .. here is the thing :

there are 4 pcs
and the 4 pcs are in one room bad they are connected through a network (router) so they can share files ..
i designed a sotware that will be used by the 4 pcs .. ok ??
so far so good ??

the database is Ms-Access 2003 and i converted it to Sql Server 2000 ...
Localy i already connected the software with the pc im using now ....

ok ??

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 ???

Re: SQL Server 2000 - Remote

Posted 10 June 2010 - 03:32 PM

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.

Re: SQL Server 2000 - Remote

Posted 11 June 2010 - 02:58 AM

well Yes i want every user to affect where ever he chooses to insert , because in the end of the month i use these data inserted by all users to report the monthly income and outcome so all the users must affect n their own tables and the Outcome and Income Tables ....

i found out that Sql Server 2000 Enterprise Full Version is not Supported on Cluster OS like Xp ,
that is why im not able to upgrade my evaluation enterprise into full version, it needs windows server ,

so do you have any idea Where to learn to work With MS-Office 2003 database as a shared DataBase, and do the same thing i waned to do with sql server ???