hi good day to all
meron akong ginawang program for inventory system
merung main(server) at merung mga branches(clients)
iisang database lang sya and naka group yung mga tables for every locations
every locations has its own tables e.g(tblstocks) etc.
the problem is how can i connect it....
the server and the client..
using vb6
any one can help me....
thanks in advance
Forum Topic
Networking on Visual Basic 6.0
-
try using odbc po ser
-
nasan yung mga branches? pano sila mgkikita, thru internet ba?
kung thru internet, kelangan mo ng publc IP. Yung Public IP lagay mo sa server mo para ma-access ng mga branches kahit nasan man silang sulok ng mundo. hehehe -
yup trough internet po
how can i configure?
yung mga branches po e.g manila,cavite,laguna....
mga sir newbie pa lang kasi ako in terms of networking po
pero fast learner naman po
if merung link for that IP addressing
paki post na po ahh
many thanks po talaga...
-- edited by dhar_08 on Sep 02 2010, 12:10 PM -
punta ka sa PLDT, pakabit ka ng internet sabihin mo ang kelangan mo e public IP. mas mahal yun compare dun sa ordinary internet. Medyo me kaartehan din ang PLDT, pag ang lugar nyo e tag as residential, hindi ka bibigyan nun ng public IP. try mo pa rin.
tapos pag me public IP na yung main office nyo. sa Cavite branch, punta ka ng explorer type mo. \\\\Public Ip ng main officer nyo\\c$ para ma-access mo yung main office.
sample:
\\\\202.198.100.34\\c$ -
sir pwde p.m tayo sa ym?
merun me tatanung po ule
eto po e-add ko po
[email protected]
tnx po talaga ahhh... -
nakablock YM dito sa office nmin. post mo na lang dito. Dami dito magagaling sa networking, cguro mga nglunch lang yun.
-
wala po kasi ako ideya kung panu gagawin eh
kaya kung merun po sanang tutorial about IP addressing po
uhm yung mga branches po ay usb modem gamit po
then yung main po pldt na po sya
may mga codes pa po ba na kailangan para dun sa pagcoconnect ng mga programs po?
actually 2 sets ng program po sya
one for the main that includes the daily time record of the employees and the current stocks po for every branches
and the 2nd program is for the clients, that contains their DTR and the current stocks -
di ba kayo pwede mag-upgrade ng .NET, para magamit nyo web service/WCF/.Net Remoting? heheh magmamanual ka kasi nyan sa vb6 eh using sockets, o nasubukan mo na ba activex dll hosted sa IIS?
o kaya subukan nyo ganito, kung may public IP na yung main upload na lang dun lahat ng raw data coming from different braches via FTP/SFTP/FTPS kahit XLS/TXT format lang. then gawa ka na lang sa server ng service programs na magpprocess and magiimport ng data pupuntang database. tapos malamang sunod nyan reporting he he.. lahat ng braches lagay mo na lang sa isang table, tapos ipartition mo na lang by branch.. -
di ko ma gets, ang .NET naka 1.0, 1.1, 2.0, 3.0, 3.5 and now 4.0, may mga nag vb6 pa din ngayon?
yung mga libre na tools for .NET is mas maayos pa sa VB6.. hehe. -
wala gano changes sa program, kung pano mo ni-access yung database mo, ganun pa rin. medyo marami ka lang kelangan i-configure dyan sa server. Mas maganda hire kayo ng system admin para i-configure yung VPN.
kuha ka ng public IP sa PLDT or any ISP
enable/installan mo yung VPN sa server
yung client installan mo ng vpn client
pag-irun mo yung application mo sa client, dapat naka-ON yung vpn client. -
sir how about yung FTP?
kasi po yung data base ko iisa lang naman sya eh
what i mean is naka shared lang sana sya through internet po -
@joepen
try using odbc po ser
how???
@dragonslash
2days and 3 nights ko ginawa yung inventory system
pag ginawa ko syang vb.net back to start ule ako nun...
uhmmm...
yung logic ko po ay ganito po
may iisang data base tapus bawat branches ay magbabato ng updates nila sa main po...
@arthurjr07
try ko gawin yung sinasabi nyo po
aralin ko pong mabuti para dont need na maghire pa po ng system admin to do that thing po..
>>>>help me mga master<<<<<< -
@vhane
yup!!!
i already do that about sa winsock po
but still hindi sya nag update eh..
panu pala process ng thesis nyo?
ang kailangan ko kasi every time na mag eencode si branch eh automatic ibabato na agad yung updates kay main po.. -
@dhar_08
ano ba requirement mo, real-time? i mean pag nag-update ng item yung isang branch automatic update agad sa main/server? -
@dragonslash
opo ganun nga po...
kung baga every time na may mag purchase ng item po
automatic ma-uupdate yung data base after ma-encode po...
panu po ba gawin ko po???? -
@dhar_08
usually kasing approach by schedule ang update, let say daily after business hours. so bawat branch may kanya kanyang database di sya directly connected sa database ng main, for security reasons and performance.
anyways, paano pag nagupdate sa main, let say nag-edit ng item, dapat auto-update din yung branch?
in that case, at parang limited ka sa technology, mag windows socket ka na lang with custom protocol he he (mahabahaba coding neto).. so setup ka ng server socket sa program mo sa main, google for sample codes, then gawa ka ng client socket for your branch program.
sample protocol/conversation (xml style):
client (branch): sends the \"<get records>\" command to the server.
server (main): query the database then returns the data \"<records><record><field id=\"key\" value=\"1\" /><field id=\"brand\" value=\"colgate\" /></record></records>\" to the client.
client (branch): displays records in the grid
client (branch): issues the \"<update><field id=\"key\" value=\"1\" /><field id=\"price\" value=\"75.00\" /></update>\" command to the server.
server (main): receives the command then updates the database
server (main): returns the \"<done>\" command to the client.
client (branch): interprets the \"<done>\" and continues with its operation.
sana naintindihan mo lolz -
@dragonslash
sir baka pede pm tayo tru Y.m
heres my e-add
[email protected]
coz i have a lot of questions to ask po eh...
thanks in advance -
>>>>sir what i mean po ay ganito po..
every client merung kanya kanyang data base then yung main ko
sya yung nagmomonitor po dun sa galaw ng stocks ayon po
merun pong pldt my dsl yung main then mga suncell n usb broadband yung sa mga branches po
yung problem po kung panu ko icoconect yung data base ng bawat branches para ma-view ng main yung stocks ng bawat branches po
parang file sharing lang po sya through internet po
help me please mga master..... -
up
-
@dhar_08
ayan naman pala may concept ka na, gawan mo na ng functional and technical specification he he.. tapos familiarization na lang with the technology, in your case client-server socket. sa vb6 meron winsock control, pwede mo cia gamitin o kaya kung medio complicated sayo hanap ka na lang ng third-party control. -
newbie pa lang po ako in terms of networking po eh..
help me guys... -
kung ayaw mo ng public IP, gamit ka na lang ng email. mas madali ito at pure programming lang kelagnan.
1)gawa ka dalawang email address sa gmail. Yung isa para sender kung isa nman receiver.
2) Dun sa branches mo, send mo yung mga stocks nyo in CSV format. attach mo sa email.
3) sa main mo, access mo yung receiver email. Check mo kung meron dun email yung client. Extract mo yung CSV tapos i-merge mo dun sa main table mo. Lagay mo sa task scheduler para mag-run sya on scheduled task. -
i-search mo yung Web service or SOAP. yan ang kailangan mo..
Programmer ako sa isang retail company.. maraming branch mga 600 stores.. lahat nag a-update ng inventory, ginagamit ko yung Web Service ng .NET. Sa Visual Studio 6 ay SOAP ang equivalent nito. -
paramg ganito yung structure ng Web Service ng .NET
-- edited by NoFalter on Sep 08 2010, 03:07 PM -
ganda nito.. ako po talgang zero tungkol sa networking na katulad nito.. may collection system kami sa ofc nasa isang computer.. tapos may sarili akong computer.. na aaccess ko system pero hindi ko ma open yung mga report.. ano gagawin ko ?? thanks sa mga maestro dyan..
-
What you really need is:
VPN Connection = all your branches will be connected to your main office just like you are in local network but through internet.
Just research on it and if you are interested I can help you setup vpn. Thanks
-- edited by oniskewl on Oct 14 2014, 10:11 AM -
Collection System using microsoft visual basic 2010 and microsoft sql server
patulong naman mga sir kung paano po magamit yung system using my computer.. salamat po.. -
local network lang po muna..