• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• ODBC DSN Connection

ODBC DSN Connection

ODBC DSN Connection

API Declarations


'Declare Public Declaration

public Cn as ADODB.Connection
public Rc as ADODB.Recordset
public Sql as String



Rate ODBC DSN Connection

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    set Cn = new ADODB.Connection
    set Rc = new ADODB.Recordset

    cn.open "MYODBC","UserName","Password"
    
    while not Rc.Eof
       list1.AddItem rc!TableName
       rc.MoveNext
    wend
end sub