PGlabo

[VB6.0|MySQL] MySQL��ODBC����³

'�¹Ի��Х���ǥ��󥰡ʻ������ꡧ�ʤ���
Dim OdbcConn As Object
Dim OdbcRS As Object

    Set OdbcConn = CreateObject("ADODB.Connection")

    Set OdbcRS = CreateObject("ADODB.Recordset")

    

    OdbcConn.open "Driver={MySQL ODBC 3.51 Driver};Uid=**;Pwd=**;Database=[DB̾]"

    OdbcRS.open [SQLʸ], OdbcConn

    '�����
    OdbcRS.Close
    Set OdbcRS = Nothing
    OdbcConn.Close
    Set OdbcConn = Nothing

2005 / 10 / 11

[ASP.NET|MySQL] MySQL ����³ ��.NET/ODBC��

        Dim Conn As OdbcConnection
        Dim strConn As String

        strConn = "DRIVER={MySQL ODBC 3.51 Driver};" & _

                       "SERVER=localhost;" & _

                       "DATABASE=test;" & _

                       "UID=[ �桼����̾ ];" & _

                       "PASSWORD=[ �ѥ���� ];"

        Conn = New OdbcConnection

        Conn.ConnectionString = strConn

        Conn.Open()

 

2005 / 10 / 06

[MySQL] MySQL ODBC�ɥ饤�С��Υ��󥹥ȡ���

1. �ɥ饤�Ф����������ɡ��¹Ԥ��롣Google
2. �֥���ȥ�����ѥͥ�ע��ִ����ġ���ע��֥ǡ���������(ODBC)�ע��֥桼����DNS�ץ��֢����ɲá�
   �ɥ饤�С����������MySQL ODBC 3.51 Driver�פ����򢪡ִ�λ��
3. Connector�������ϡ����
     *Data Source Name -- MyOdbc�ʼ�ͳ�˺�����
     *Description -------- MySQL ODBC 3.51 Driver�ʶ���Ǥ�OK����
     *Server ------------ localhost
     *User -------------- UserName�ʥ桼������
     *Password ---------- Pass�ʥѥ���ɡ�
     *Database ---------- ��DB�������
4. ��Test�פ򥯥�å�����Success; connection was made!�ץ�å�������OK

2005 / 10 / 06