Visual Basic Sample Code on How to Establish via Internet Connection

‘Visual Basic can connect the database through the internet connection, this is very useful when you want to centralize the database or connect the different locations let say for example the company has three ‘branches in different cities or country so you must setup one for database server and the rest connect the server as client.

‘Visual Basic Sample Code

Dim RS As RecordsetDim cnnGeneric As ConnectionSet Conn = New ConnectionConn.Open

“Provider=MS Remote;” _& “Remote Provider=MSDataShape;” _& “Remote Server=http://www.mydomain.com;” _& “Data Source=Employee;” _& “User Id=myusername;Password=mypassword;”

Set RS = New Recordset

With RS.CursorLocation = adUseClient.Open strQuery, Conn, adOpenStatic, adLockReadOnly.ActiveConnection = NothingEnd

With