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