Masalah Sql Server

[mutanic]

dkt locap pc..kjp bro kjp lg aku tempek

adoyaiiii....mmg la mat oiiiiiii....))))

nko sepatutnya create exact development environment ada server sume tu...cer nko buat sume pc tu register under same domain pastu connect ke database server insyaAllah boleh...

 

[mutanic]

asl gelak bro aku pkai vb.net..dh ni je la yg i mmpu bro..nk buat web base xpndai

bro, aku bukan gelak hina ka apa ka...aku gelak sbb aku boleh teka bahasa yg nko pakai...VB .Net power gak beb & aku pun x reti sebenarnya...tapi kalu nak study sket2 bleh la...

 

[mutanic]

sebelum pi lebih jauh, app nko ni target guna kat mana? local network ka?

 

[premier30]

sebelum pi lebih jauh, app nko ni target guna kat mana? local network ka?

yup local network bro..tp klau bro bleh kasi lebih jauh terima ksh bnyk2

 

[mutanic]

yup local network bro..tp klau bro bleh kasi lebih jauh terima ksh bnyk2

jauh tu xda la sbb la ni aku free sket
pastikan SQL server nko tu install kat satu pc yg bertindak as server...senang cite registered under same domain account...

pakai HyperV atau VMware untuk buat database server nko senirik,
cer guna windows server pastu add server role as domain controller & dns server bla bla bla bleh google part ni...paling penting server kena ada fix IP address bro, bila dah setel bab ni nko install SQL Server plak dlm tu & masa configure tu amik mixed authentication bla bla bla bleh google gak part ni...
pastu try ping database server yg nko dah setup melalui desktop(kena join domain ngan database server tadi di mana ia juga bertindak as domain controller) nko...

 

[mutanic]

yup local network bro..tp klau bro bleh kasi lebih jauh terima ksh bnyk2

aiseh terlepas pandang, mmg local network so registered under domain kan?

 

[mutanic]

woi Erazer nko power VB .Net meh assist sket...hehehe

 

[Erazer]

woi Erazer nko power VB .Net meh assist sket...hehehe

nak assist mcmana, tt kena belajar foundation dulu, ni takde basic terus redah memang takkan faham le..

so belajarlah dari database paling basic.

http://www.homeandlearn.co.uk/net/nets12p1.html

dah faham konsep open connection, close connection, query, blablahblah, barulah move on ke mysql.

http://www.codeproject.com/Tips/493133/Connecting-to-MySQL-databases-using-VB-NET

http://www.soagateway.com/tutorials/PDFs/Accessing_MySQL_from_Visual_Basic.pdf

 

[mutanic]

aku nak dia create development environment dulu, dlm kes ni dia develop windows app so xperlu web server memadai ada server yg bertindak as domain controller+dns server+sql server, dah ada ni aku nak dia setup database dlm tu & test connection dari desktop dia ok ker x...

 

[Erazer]

Lagi satu kalau hang kat LAN, nak conect dari PC lain , solution aku sama macam mutanic, kena setup remote server dulu la untuk db tu , pastu pastikan set dekat host , allow from all, jangan guna root account, create user baru lepas tu test balik.