Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote database.
Message
From
25/03/1999 06:52:39
Penmetsa Sridhar
Visualsoft Technologies Limited
Hyderabad, India
 
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00200634
Message ID:
00201781
Views:
12
Hai Eric Moreau

Sorry for the delay I was out of station

Follow these steps to get connected to the database through TCP/IP

1. Check in your Sequeal Server for the permissions to TCP/IP Sockets
---In the Sequeal Server go to SQL Server Setup and in the "Change Network Support" option check the TCP/IP Sockets

2.Create a Dsn(sree) [using SqlServer Driver and type the TCP/IP number in the Server option and with the sql Server authentication option, Enter the LoginId and password and also the set the Client Configuration-Net Library to TCP/IP Sockets]

3.Use this code in vb

Dim sqldb As New ADODB.Connection
Dim rs As New ADODB.Recordset

Private Sub main()
Dim sconnect As String
sconnect = "Provider=MSDASQL;Data Source=sree;User Id=sa;Password="
sqldb.Open sconnect
rs.Open "select * from category", sqldb, adOpenStatic, adLockPessimistic
End Sub

Private Sub Command1_Click()
MsgBox rs(0).Value & vbCrLf & rs(1).Value & vbCrLf & rs(3).Value
End Sub



Feel Free to contact

Penmetsa.Sridhar
Software Engineer
e-mail : sree_raju@rocketmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform