**keyw: dreamweaver mysql aspnet

Dreamweaver aspnet (ASPX) digunakan untuk koneksi ke database ms sql. Bagaimana kita bisa terhubung ke mysql?
Semua orang sekarang dapat menhubungkan aspnet (ASPX) mysql melalui Dreamweaver (DW)

Dreamweaver aspnet (ASPX) is used to connect to database ms sql. How can we connect to mysql ??
Everyone can now connect aspnet (ASPX) mysql through Dreamweaver (DW)

BISA PAKAI INI:: http://www.dmxzone.com/forum/topic/32389/

Provider=MSDataShape.1;Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDatabase;User Id=myUserName;Password=MyPassword

--Provider=MSDataShape.1;Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=wm;User Id=root;Password=123

Provider=MSDataShape.1;Driver={MySQL ODBC 2.50 Driver};Server=localhost;Database=wm;User Id=root;Password=123

--pertama-tama install FILE mysql-connector-odbc-3.51.30-win32.msi

--First, you must install FILE mysql-connector-odbc-3.51.30-win32.msi



MySQL Connector/ODBC (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as ...
13 Aug. 2010 Windows Me, Windows 2000, Windows Server 2003, Windows NT, Windows XP, Windows 98

** MySQL OLEDB ("Provider=MySQLProv")
This is a OLE DB Provider provided by MySQL. The provider is contained in the file ---MySql.Data.dll.
Coding Include ---"Provider=MySQLProv" in the connection string to use this provider.



**
'define connection used through out in the form
Private mConn As ADODB.Connection

'//Synposis:
'//1. Create an ADO connection
'//2. Enable Read Data button if the table exists
Private Sub FormLoad()
On Error GoTo trap
Set mConn = New Connection
'connect to MySQL server (localhost, port 3306), Database Name: test
mConn.Open "Provider=OleMySql.MySqlSource.1; " _
& " Data Source=localhost,3306; Initial Catalog=test", _
"root", "myPassword"
If DoesTableExist("AllFields") Then
Me.Command3.Enabled = True
End If
Exit Sub
trap:
MsgBox Err.Description
End Sub

** contoh conn string::

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

Provider=MySQLProv;Data Source=mypushaka;User Id=root;Password=123;

mysql connector-install files di windows assembly ::

C:\Program Files\MySQL Connector Net 6.5.4\Assemblies\v2.0\MySql.Data.CF.dll
C:\WINDOWS\assembly\tmpQJW9AF\MySql.Data.CF.dll
C:\Program Files\MySQL Connector Net 6.5.4\Assemblies\v2.0\MySql.Data.Entity.dll
C:\WINDOWS\assembly\tmp\SXAN09IJ\MySql.Data.Entity.dll
C:\Program Files\MySQL Connector Net 6.5.4\Assemblies\v2.0\MySql.Data.dll
C:\WINDOWS\assembly\tmp\WDIV8P23\MySql.Data.dll
C:\Program Files\MySQL Connector Net 6.5.4\Assemblies\v4.0\MySql.Data.dll
C:\Program Files\MySQL Connector Net 6.5.4\Visual Studio Integration08\MySQL.VisualStudio.dll
C:\Program Files\MySQL Connector Net 6.5.4\Assemblies\v2.0\MySql.Web.dll
C:\Program Files\MySQL Connector Net 6.5.4\Assemblies\v4.0\MySql.Web.dll

Pakai query-DatabaseTOUR (dbTour), BISA::

Provider=MSDASQL.1;Persist Security Info=False;Data Source=my_pushaka