>>3
Seconded; the concept is of course solid but that doesn't mean their implementation is.
Name:
Anonymous2008-08-28 22:05
>>4
Most of the providers I've used are shit in one way or another (I'm looking at MySQL and Jet DB in particular note: I probably had an old version of the mysql ODBC drivers, but I don't expect much to have changed), but I never had any problems with the concept itself.
>>1
We'll need some examples of alternative (non-MS) solutions that are shit, to prove that the concept isn't obvious, and the implementation isn't trivial.
Imports Microsoft.Data.Odbc
Module Module1
Sub Main()
Dim conn As OdbcConnection
Dim comm As OdbcCommand
Dim dr As OdbcDataReader
Dim connectionString As String
Dim sql As String
connectionString = "DSN=PracticalLotusScriptTest;UID=Chester;Pwd=Tester;"
sql = "SELECT CustomerID, ContactName, ContactTitle FROM Customers"
conn = New OdbcConnection(connectionString)
conn.Open()
comm = New OdbcCommand(sql, conn)
dr = comm.ExecuteReader()
While (dr.Read())
Console.WriteLine(dr.GetValue(0).ToString())
Console.WriteLine(dr.GetValue(1).ToString())
Console.WriteLine(dr.GetValue(2).ToString())
End While
conn.Close()
dr.Close()
comm.Dispose()
conn.Dispose()
End Sub
End Module