Database.MSSQLServer.Connection

SQL Server client library implemented in Haskell

Usage Example

Connect with the SQL Server

connect and close function could be used as follows.

{-# LANGUAGE OverloadedStrings #-}
module Main where

import Network.Socket (withSocketsDo)
import Control.Exception (bracket)

import Database.MSSQLServer.Connection
import Database.MSSQLServer.Query

main :: IO ()
main = do
  let info = defaultConnectInfo { connectHost = "192.168.0.1"
                                , connectPort = "1433"
                                , connectDatabase = "some_database"
                                , connectUser = "some_user"
                                , connectPassword = "some_password"
                                }
  withSocketsDo $
    bracket (connect info) close $ \conn -> do
    rs <- sql conn "SELECT 2 + 2" :: IO [Only Int]
    print rs

data ConnectInfo

Constructors

ConnectInfo

Fields

• connectHost :: !String
• connectPort :: !String
• connectDatabase :: !String
• connectUser :: !String
• connectPassword :: !String
• connectEncryption :: !Word8
• connectPacketSize :: !Word32
• connectOptionFlags1 :: !Word8
• connectOptionFlags2 :: !Word8
• connectOptionFlags3 :: !Word8
• connectTypeFlags :: !Word8
• connectTimeZone :: !Int32
• connectCollation :: !Collation32
• connectLanguage :: !String
• connectAppName :: !String
• connectServerName :: !String

defaultConnectInfo :: ConnectInfo

data Connection

Constructors

Connection Socket Word32

connect :: ConnectInfo -> IO Connection

connectWithoutEncryption :: ConnectInfo -> IO Connection

close :: Connection -> IO ()

data ProtocolError

Constructors

ProtocolError String

Instances

Show ProtocolError

Defined in Database.MSSQLServer.Connection

Methods

showsPrec :: Int -> ProtocolError -> ShowS

show :: ProtocolError -> String

showList :: [ProtocolError] -> ShowS

Exception ProtocolError

Defined in Database.MSSQLServer.Connection

Methods

toException :: ProtocolError -> SomeException

fromException :: SomeException -> Maybe ProtocolError

displayException :: ProtocolError -> String

data AuthError

Constructors

AuthError !Info

Instances

Show AuthError

Defined in Database.MSSQLServer.Connection

Methods

showsPrec :: Int -> AuthError -> ShowS

show :: AuthError -> String

showList :: [AuthError] -> ShowS

Exception AuthError

Defined in Database.MSSQLServer.Connection

Methods

toException :: AuthError -> SomeException

fromException :: SomeException -> Maybe AuthError

displayException :: AuthError -> String