Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 [WTA] VB6 Connect SQL Server using ADODB error

views
     
TSgodjai
post Jul 27 2016, 12:48 PM, updated 8y ago

Getting Started
**
Junior Member
94 posts

Joined: Sep 2006
Assume my password is abc@123. i using vb6, try connect to sql server to retrieve data and show appointment date using specific appointment no. But it keep on show table ReservationTBL request login, and my login failed. Please help me on the connection coding.

user posted image

QUOTE
Set sqlcnn1 = New ADODB.Connection
Set sqlrst1 = New ADODB.Recordset

sqlcnn1.Open "PROVIDER = MSDASQL;driver={SQL Server};database=ReservationHS ;server=10.10.10.10;uid=sa;pwd=abc@123#;"

sqlrst1.Open "select * from ReservationTBL where AppointmentNo = 'APP00001'", sqlcnn1, adOpenStatic, adOpenStatic, adCmdText
If sqlrst1.EOF = False Then
    MsgBox sqlrst1!AppointmentDate
   
End If
sqlrst1.Close
sqlcnn1.Close
This post has been edited by godjai: Jul 27 2016, 03:13 PM

 

Change to:
| Lo-Fi Version
0.0122sec    0.54    5 queries    GZIP Disabled
Time is now: 29th March 2024 - 04:42 PM