ODBC Library?

[Sean Kelly via Digitalmars-d-learn]

Oh, here's a sample, since it doesn't look like that zip includes 
one:


import sql.Connection;
import sql.Exception;
import sql.ResultSet;
import sql.Statement;
import core.stdc.stdio;


pragma( lib, "odbc32.lib" );
pragma( lib, "sql.lib" );


void main()
{
     try
     {
         auto conn = new Connection( "driver={SQL Server};"
                                     "server=(local);"
                                     "trusted_connection=no;"
                                     "database=test;"
                                     "uid=sa;"
                                     "pwd=hello;" );
                                     //"network=dbmssocn;" );
         auto stmt = conn.prepare( "SELECT Name FROM Person WHERE 
PersonID = ?" );
         stmt[0] = 1;
         //auto stmt = conn.prepare( "SELECT Name FROM Person" );
         auto rs = stmt.open();
         printf( "%.*s\n----\n", rs[0].name );
         while( rs.next() )
             printf( "%.*s\n", rs[0].asUtf8 );
     }
     catch( SQLException e )
     {
         foreach( rec; e )
         {
             printf( "%.*s - %d: %.*s\n", rec.state, rec.code, 
rec.msg );
         }
     }
}