[ahmedhakem]

0099FF

sql server connection with vb6
my_sql is the record set
my_sql = "select * from users where user_id='" & UCase
(Combo1.Text) & "'"
my_conn is the connection to sql
my_conn
= "provider=sqloledb.1;SERVER=;uid=SA;pwd=;database= INVDATA1"