strConnectionString = "Provider=sqloledb;Data Source=mysql;Initial Catalog=DB;Trusted_Connection=yes;"
Set objConn = CreateObject("ADODB.Connection")
Set objCommand = CreateObject("ADODB.Command")
Set rs = CreateObject("ADODB.Recordset")
objConn.Open strConnectionString
Query = "SELECT * FROM time"
rs.Open Query, objConn, 1
rs.MoveFirst
Do Until rs.EOF
msgbors)
Loop
rs.Close
objConn.Close
this is wht i typed .. but no out put came .. it just displayed me a text wht i typed ...
i want my database to be access from a MSQL which runs on the stand alone ..system ... (localhost)
in my data base i have used the MYSQL ODBC connection datasource name:mysql
mysql database :sample
table:sample.time;
time is the table
can u please help its urgent