Pada Tutorial VB berikut ini akan dibahas beberapa conection string pada vb untuk koneksi ke database. lanngsung aja ke CN'nya (conecction String):
MYSQL =["Provider=MySQLProv;" & "Data Source=mySQLDB;" & "User Id=username;" & "Password=Pass"]
MS Access(ODBC Driver)= ["Provider=MSDASQL;" & "Driver={Microsoft Access Driver (*.mdb)};" & "Dbq=c:\path\nama database.mdb;" & "Uid=Username;" & "Pwd=Pass"]
Oracle (Microsft) =["Provider=msdaora;" & "Data Source=OracleDB;" & "User Id=Username;" & "Password=Pass"]
SQL Server (OLEDB)=["Provider=sqloledb;" & "Data Source=nama server;" & "Initial Catalog=nama catalog/database;" & "User Id=Username;" & "Password=Pass"]
FOXPro (v.7)=["Provider=vfpoledb;" & "Data Source=C:\path\namadatabasefoxpro.dbc;" & "Mode=ReadWrite|Share Deny None;" & "Collating Sequence=MACHINE;" & "Password=pass''"].
sekian Tutorial VB kali ini dan semoga bermamfaat.
Post a Comment