Sql 2005 ten listboxa veri almaya çalışıyorum ama hata alıyorum kodları şu şekilde
Private Sub CommandButton3_Click()
SERVER = "server"
USER = "SA"
SIRKET = "DATA12"
SIFRE = "1"
MyCon.Open "Provider=SQLOLEDB.1;Password=" + SIFRE + ";Persist Security Info=True;User ID=" + USER + ";Initial Catalog=" + SIRKET + ";Data Source=" + SERVER + ";Use Procedure for Prepare=1;Auto Translate=False;Packet Size=4096;Workstation ID=SAYFA1;Use Encryption for Data=False;Tag with column collation when possible=False"
SqlText = "select * from TBLPROJE"
Set RS1 = MyCon.Execute(SqlText)
ListBox1.RowSource = RS1("PROJE_KODU")
MyCon.Close
End Sub
Aldığım Hata ise Run Time error '380'
Couldnt set Rowsource Property,invalid property value
Private Sub CommandButton3_Click()
SERVER = "server"
USER = "SA"
SIRKET = "DATA12"
SIFRE = "1"
MyCon.Open "Provider=SQLOLEDB.1;Password=" + SIFRE + ";Persist Security Info=True;User ID=" + USER + ";Initial Catalog=" + SIRKET + ";Data Source=" + SERVER + ";Use Procedure for Prepare=1;Auto Translate=False;Packet Size=4096;Workstation ID=SAYFA1;Use Encryption for Data=False;Tag with column collation when possible=False"
SqlText = "select * from TBLPROJE"
Set RS1 = MyCon.Execute(SqlText)
ListBox1.RowSource = RS1("PROJE_KODU")
MyCon.Close
End Sub
Aldığım Hata ise Run Time error '380'
Couldnt set Rowsource Property,invalid property value