Conexiune mysql

#1
ryady

Posted 12 January 2006 - 23:03

Member

Grup: Members
Posts: 449
Înscris: 30.09.2003

Cum se face o conexiune mysql in vb6, un exemplu ceva de unde sa-mi pot da seama mai exact ?

Back to top

#2
RAZ

Posted 13 January 2006 - 17:56

Member

Grup: Members
Posts: 1,227
Înscris: 15.10.2004

iti trebuie MySQL ODBC driver,
uite un exemplu:

Private Sub cmdConnectMySQL_Click()

Dim cnMySql As New rdoConnection
Dim rdoQry As New rdoQuery
Dim rdoRS As rdoResultset


cnMySql.CursorDriver = rdUseOdbc
cnMySql.Connect = "uid=YourUserName;pwd=YourPassword;
	server=YourServerName;" & _
	"driver={MySQL ODBC 3.51 Driver};
	database=YourDataBase;dsn=;"
cnMySql.EstablishConnection



With rdoQry
	.Name = "selectUsers"
	.SQL = "select * from user"
	.RowsetSize = 1
	Set .ActiveConnection = cnMySql
	Set rdoRS = .OpenResultset(
			rdOpenKeyset, rdConcurRowVer)
End With
	


Do Until rdoRS.EOF
	With rdoRS
				'process the fields
			   ' to access a field called username you would
			   'reference it like !username
		rdoRS.MoveNext
	End With
Loop



rdoRS.Close
cnMySql.Close

End Sub

this link helps

succes!

Back to top

#3
theSefirah

Posted 23 May 2006 - 23:14

Junior Member

Grup: Members
Posts: 48
Înscris: 24.07.2004

ca sa fiu 101% sigur, deci cu mysql odbc driver pot sa ma conectez de pe workstationu meu cu windoz catre baza mea de date mysql care ruleaza pe *nix undeva pe un server nu ?

merci

Back to top

Anunturi

Bun venit pe Forumul Softpedia!

Conexiune mysql

#1 ryady Posted 12 January 2006 - 23:03

#2 RAZ Posted 13 January 2006 - 17:56

#3 theSefirah Posted 23 May 2006 - 23:14

Anunturi

▶ 0 user(s) are reading this topic

Sign In

#1
ryady

Posted 12 January 2006 - 23:03

#2
RAZ

Posted 13 January 2006 - 17:56

#3
theSefirah

Posted 23 May 2006 - 23:14