HDBC-ODBC under Windows
From HaskellWiki
(Difference between revisions)
(Categorize, format, fix headings) |
|||
| Line 1: | Line 1: | ||
| + | [[Category:Libraries]] [[Category:How to]] | ||
A brief description of how to get HDBC-ODBC working under windows, for connecting to things like MS SQL server. | A brief description of how to get HDBC-ODBC working under windows, for connecting to things like MS SQL server. | ||
| - | = Install = | + | == Install == |
* Ensure your path contains the ghc bin directory: | * Ensure your path contains the ghc bin directory: | ||
** Right click on My Computer, select Properties -> Advanced -> Environment variables -> change the variable 'Path' | ** Right click on My Computer, select Properties -> Advanced -> Environment variables -> change the variable 'Path' | ||
| - | |||
* Download and install MDAC/ODBC Software Development Kit, from a link on this page:<br />http://msdn.microsoft.com/data/ref/mdac/downloads/ | * Download and install MDAC/ODBC Software Development Kit, from a link on this page:<br />http://msdn.microsoft.com/data/ref/mdac/downloads/ | ||
| - | |||
* Download and unpack the most recent versions of hdbc and hdbc-odbc from the HDBC homepage:<br />http://gopher.quux.org:70/devel/hdbc | * Download and unpack the most recent versions of hdbc and hdbc-odbc from the HDBC homepage:<br />http://gopher.quux.org:70/devel/hdbc | ||
| - | + | * Follow the README instructions for installing [[HDBC | hdbc]] | |
| - | * Follow the README instructions for installing hdbc | + | |
| - | + | ||
* Follow the README instructions for installing hdbc-odbc, with these changes: | * Follow the README instructions for installing hdbc-odbc, with these changes: | ||
** The include-dirs line should be changed to:<br/>include-dirs: . "C:\\Program Files\\Microsoft Data Access SDK 2.8\\Libs\\x86" | ** The include-dirs line should be changed to:<br/>include-dirs: . "C:\\Program Files\\Microsoft Data Access SDK 2.8\\Libs\\x86" | ||
** Do the following at a command prompt, with the hdbc-odbc directory being current directory:<br/> | ** Do the following at a command prompt, with the hdbc-odbc directory being current directory:<br/> | ||
| - | + | ghc --make -o setup Setup.hs | |
| - | + | setup configure | |
| - | + | setup build | |
| - | + | setup install | |
You may need other ODBC drivers, but often they will be installed already on a development box that has the database server installed. | You may need other ODBC drivers, but often they will be installed already on a development box that has the database server installed. | ||
| - | = Test = | + | == Test == |
| - | You can test it from a | + | You can test it from a [[ghc]]i prompt (obviously you'll need to change the connection string and query): |
<pre> | <pre> | ||
Revision as of 21:13, 23 June 2007
A brief description of how to get HDBC-ODBC working under windows, for connecting to things like MS SQL server.
1 Install
- Ensure your path contains the ghc bin directory:
- Right click on My Computer, select Properties -> Advanced -> Environment variables -> change the variable 'Path'
- Download and install MDAC/ODBC Software Development Kit, from a link on this page:
http://msdn.microsoft.com/data/ref/mdac/downloads/ - Download and unpack the most recent versions of hdbc and hdbc-odbc from the HDBC homepage:
http://gopher.quux.org:70/devel/hdbc - Follow the README instructions for installing hdbc
- Follow the README instructions for installing hdbc-odbc, with these changes:
- The include-dirs line should be changed to:
include-dirs: . "C:\\Program Files\\Microsoft Data Access SDK 2.8\\Libs\\x86" - Do the following at a command prompt, with the hdbc-odbc directory being current directory:
- The include-dirs line should be changed to:
ghc --make -o setup Setup.hs
setup configure
setup build
setup install
You may need other ODBC drivers, but often they will be installed already on a development box that has the database server installed.
2 Test
You can test it from a ghci prompt (obviously you'll need to change the connection string and query):
Prelude> :m Database.HDBC
Prelude Database.HDBC> :m + Database.HDBC.ODBC
Prelude Database.HDBC Database.HDBC.ODBC> let connectionString = "Driver={SQL Server};Server=myserver;Database=mydatabase;Trusted_Connection=yes;"
Prelude Database.HDBC Database.HDBC.ODBC> let ioconn = connectODBC connectionString
Prelude Database.HDBC Database.HDBC.ODBC> do { conn <- ioconn; vals <- quickQuery conn "SELECT TOP 10 * FROM mytable;" []; print vals }
[[SqlString "1",SqlString "Copy",...
