hdbc odbc driver 1.0.1.1
Sponsored Links
Sponsored Links
Secleted [ 0 ] software to compare
Results 1 - 15 of about 895
HDBC ODBC Driver 1.0.1.1
HDBC ODBC Driver is the Haskell ODBC backend driver for HDBC. more>>
HDBC ODBC Driver is the Haskell ODBC backend driver for HDBC. This driver has been tested on Windows and on Linux with unixODBC. It should also be compatible with iODBC, though this has not been tested. It should be portable to any platform supported by both Haskell and unixODBC.
This driver is the preferred method of communicating with MySQL from Haskell.
MYSQL NOTE
Important note for MySQL users:
Unless you are going to use InnoDB tables, you are strongly encouraged to set
Option = 262144
in your odbc.ini (for Unix users), or to disable transaction support in your DSN setup for Windows users.
If you fail to do this, the MySQL ODBC driver will incorrectly state that it
supports transactions. dbTransactionSupport will incorrectly return True. commit and rollback will then silently fail. This is certainly /NOT/ what you want. It is a bug (or misfeature) in the MySQL driver, not in HDBC.
You should ignore this advice if you are using InnoDB tables.
<<lessThis driver is the preferred method of communicating with MySQL from Haskell.
MYSQL NOTE
Important note for MySQL users:
Unless you are going to use InnoDB tables, you are strongly encouraged to set
Option = 262144
in your odbc.ini (for Unix users), or to disable transaction support in your DSN setup for Windows users.
If you fail to do this, the MySQL ODBC driver will incorrectly state that it
supports transactions. dbTransactionSupport will incorrectly return True. commit and rollback will then silently fail. This is certainly /NOT/ what you want. It is a bug (or misfeature) in the MySQL driver, not in HDBC.
You should ignore this advice if you are using InnoDB tables.
Download (0.036MB)
Added: 2007-03-09 License: LGPL (GNU Lesser General Public License) Price:
959 downloads
HDBC Sqlite3 Driver 1.0.1.0
HDBC Sqlite3 Driver is the Haskell Sqlite v3 backend driver for HDBC. more>>
HDBC Sqlite3 Driver is the Haskell Sqlite v3 backend driver for HDBC.
Please see HDBC itself for documentation on use. If you dont already
have it, you can browse this documentation at
http://darcs.complete.org/hdbc/doc/index.html.
This package provides one function in module Database.HDBC.Sqlite3:
{- | Connect to an Sqlite version 3 database. The only parameter needed is
the filename of the database to connect to.
All database accessor functions are provided in the main HDBC module. -}
connectSqlite3 :: FilePath -> IO Connection
<<lessPlease see HDBC itself for documentation on use. If you dont already
have it, you can browse this documentation at
http://darcs.complete.org/hdbc/doc/index.html.
This package provides one function in module Database.HDBC.Sqlite3:
{- | Connect to an Sqlite version 3 database. The only parameter needed is
the filename of the database to connect to.
All database accessor functions are provided in the main HDBC module. -}
connectSqlite3 :: FilePath -> IO Connection
Download (0.023MB)
Added: 2007-03-09 License: LGPL (GNU Lesser General Public License) Price:
961 downloads
HDBC PostgreSQL Driver 1.1.2.0
HDBC PostgreSQL Driver is the Haskell PostgreSQL backend driver for HDBC. more>>
HDBC PostgreSQL Driver is the Haskell PostgreSQL backend driver for HDBC.
Please see HDBC itself for documentation on use. If you dont already have it, you can browse this documentation at http://darcs.complete.org/hdbc/doc/index.html.
This package provides one function in module Database.HDBC.PostgreSQL:
{- | Connect to a PostgreSQL server.
See for the meaning of the connection string. -}
connectPostgreSQL :: String -> IO Connection
An example would be:
dbh<<less
Please see HDBC itself for documentation on use. If you dont already have it, you can browse this documentation at http://darcs.complete.org/hdbc/doc/index.html.
This package provides one function in module Database.HDBC.PostgreSQL:
{- | Connect to a PostgreSQL server.
See for the meaning of the connection string. -}
connectPostgreSQL :: String -> IO Connection
An example would be:
dbh<<less
Download (0.034MB)
Added: 2007-05-21 License: LGPL (GNU Lesser General Public License) Price:
886 downloads
DVB Driver Project 1.1.1
DVB Driver Project is a driver for DVB cards by many manufacturers. more>>
If you want to receive IP over Satellite and DVB on your Linux machine, you might want to buy one of these DVB PCI cards (see also the developer section for a list of card revisions supported by our driver):
* The Siemens DVB card - this is the card we developped the Linux drivers for (thanks to the Siemens guys). The Siemens DVB-S card is identical to the cards built by Hauppauge, Technotrend, Galaxis and Katek. We also support the Siemens DVB-C card.
* Hauppauge has released a low budget version of the Siemens card. The WinTV Nova has no MPEG2 decoder chip anymore. From driver version 0.8 on we support this card - you should be able to get a complete transport stream from it.
* Technotrend has developed a DVB-T card and our driver also supports this card (both, the version with DSP and the Nova card). Most DVB-S cards (except for Version 1.6) are also supported by us. The Technotrend DVB-C card (at least the newer version 2.1) is currently not working with our driver.
* The Telemann Skymedia card - never seen that card, but there are Linux drivers
* The Pentamedia cards - Linux drivers for a IP-over-Satellite card.
<<less* The Siemens DVB card - this is the card we developped the Linux drivers for (thanks to the Siemens guys). The Siemens DVB-S card is identical to the cards built by Hauppauge, Technotrend, Galaxis and Katek. We also support the Siemens DVB-C card.
* Hauppauge has released a low budget version of the Siemens card. The WinTV Nova has no MPEG2 decoder chip anymore. From driver version 0.8 on we support this card - you should be able to get a complete transport stream from it.
* Technotrend has developed a DVB-T card and our driver also supports this card (both, the version with DSP and the Nova card). Most DVB-S cards (except for Version 1.6) are also supported by us. The Technotrend DVB-C card (at least the newer version 2.1) is currently not working with our driver.
* The Telemann Skymedia card - never seen that card, but there are Linux drivers
* The Pentamedia cards - Linux drivers for a IP-over-Satellite card.
Download (0.32MB)
Added: 2005-08-09 License: GPL (GNU General Public License) Price:
1540 downloads
HDBC 1.0.1.2
HDBC is a Haskell Database Connectivity. more>>
HDBC is a Haskell Database Connectivity.
HDBC provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
HDBC is modeled loosely on Perls DBI interface http://search.cpan.org/~timb/DBI/DBI.pm, though it has also been influenced by Pythons DB-API v2, JDBC in Java, and HSQL in Haskell.
HDBC is a from-scratch effort. It is not a reimplementation of HSQL, though its purpose is the same.
<<lessHDBC provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
HDBC is modeled loosely on Perls DBI interface http://search.cpan.org/~timb/DBI/DBI.pm, though it has also been influenced by Pythons DB-API v2, JDBC in Java, and HSQL in Haskell.
HDBC is a from-scratch effort. It is not a reimplementation of HSQL, though its purpose is the same.
Download (0.10MB)
Added: 2007-03-09 License: LGPL (GNU Lesser General Public License) Price:
959 downloads
ALSA driver 1.0.14a
ALSA driver is an alternative implementation of Linux sound support. more>>
The Advanced Linux Sound Architecture is composed of several parts. The first is a fully modularized sound driver which supports module autoloading, devfs, isapnp autoconfiguration, and gives complete access to analog audio, digital audio, control, mixer, synthesizer, DSP, MIDI, and timer components of audio hardware.
It also includes a fully-featured kernel-level sequencer, a full compatibility layer for OSS/Free applications, an object-oriented C library which covers and enhances the ALSA kernel driver functionality for applications (client/server, plugins, PCM sharing/multiplexing, PCM metering, etc.), an interactive configuration program for the driver, and some simple utilities for basic management.
Main features:
- Efficient support for all types of audio interfaces, from consumer soundcards to professional multichannel audio interfaces.
- Fully modularized sound drivers.
- SMP and thread-safe design.
- User space library (alsa-lib) to simplify application programming and provide higher level functionality.
- Support for the older OSS API, providing binary compatibility for most OSS programs.
<<lessIt also includes a fully-featured kernel-level sequencer, a full compatibility layer for OSS/Free applications, an object-oriented C library which covers and enhances the ALSA kernel driver functionality for applications (client/server, plugins, PCM sharing/multiplexing, PCM metering, etc.), an interactive configuration program for the driver, and some simple utilities for basic management.
Main features:
- Efficient support for all types of audio interfaces, from consumer soundcards to professional multichannel audio interfaces.
- Fully modularized sound drivers.
- SMP and thread-safe design.
- User space library (alsa-lib) to simplify application programming and provide higher level functionality.
- Support for the older OSS API, providing binary compatibility for most OSS programs.
Download (2.3MB)
Added: 2007-06-11 License: GPL (GNU General Public License) Price:
869 downloads
Bind9 LDAP sdb driver 1.0 / 1.1.0
Bind9 LDAP sdb driver is an attempt at an LDAP back-end for BIND 9 using the new simplified database interface sdb. more>>
Bind9 LDAP sdb driver is an attempt at an LDAP back-end for BIND 9 using the new simplified database interface "sdb". Using this you can store zones in LDAP rather than in files.
Note that when using sdb, the zones are not cached in memory, BIND will do a database lookup whenever it gets a query. If you want to store zones in LDAP but still have BIND do caching, you may be interested in the ldap2zone tool.
<<lessNote that when using sdb, the zones are not cached in memory, BIND will do a database lookup whenever it gets a query. If you want to store zones in LDAP but still have BIND do caching, you may be interested in the ldap2zone tool.
Download (0.008MB)
Added: 2007-07-03 License: GPL (GNU General Public License) Price:
848 downloads
Semtech Touchscreen Driver 1.0
Semtech Touchscreen Driver is a driver on X for the Semtech Touchscreen. more>>
Semtech Touchscreen Driver is a driver on X for the Semtech Touchscreen as found on the GoBook III manufactured by Itronix.
It comes with a calibration program and has been tested on Linux 2.6.9.
You will need a kernel with the following options compiled.
CONFIG_SERIO_RAW=y
CONFIG_INPUT_MOUSE=y
CONFIG_MOUSE_PS2=y
Next you will need to enable raw PS/2 reporting for the touchscreen. Type in the following command:
echo -n "serio_raw" > /sys/bus/serio/devices/serio1/driver
You should see the following message:
serio_raw: raw access enabled on isa0060/serio2 (serio_raw0, minor 1)
Compiling:
Type the following command to compile the driver:
make
Installing:
Do the following as root to install the driver:
make install
Configuration:
You will need to issue this command every time the computer starts so I suggest you stick somewhere in the initalization scripts.
Add a section in xorg.conf or XF86Config that looks like this:
Section "InputDevice"
Driver "semtech"
Identifier "Semtech Touchscreen"
Option "Device" "/dev/serio_raw0"
Option "DebugLevel" "0"
Option "CalibrateA" "-369046"
Option "CalibrateB" "1114"
Option "CalibrateC" "4893014"
Option "CalibrateD" "-2152"
Option "CalibrateE" "-282719"
Option "CalibrateF" "5331971"
Option "CalibrateDiv" "-359811"
EndSection
Note that the device can also be called /dev/psaux depending on your setup.
Start X and run the touchcal program to calibrate your screen. It will ouput the calibration information
There is also a program called touchcal.pl, it requires the Perl Tk toolkit. The program will write calibration information on your X configuration file.
<<lessIt comes with a calibration program and has been tested on Linux 2.6.9.
You will need a kernel with the following options compiled.
CONFIG_SERIO_RAW=y
CONFIG_INPUT_MOUSE=y
CONFIG_MOUSE_PS2=y
Next you will need to enable raw PS/2 reporting for the touchscreen. Type in the following command:
echo -n "serio_raw" > /sys/bus/serio/devices/serio1/driver
You should see the following message:
serio_raw: raw access enabled on isa0060/serio2 (serio_raw0, minor 1)
Compiling:
Type the following command to compile the driver:
make
Installing:
Do the following as root to install the driver:
make install
Configuration:
You will need to issue this command every time the computer starts so I suggest you stick somewhere in the initalization scripts.
Add a section in xorg.conf or XF86Config that looks like this:
Section "InputDevice"
Driver "semtech"
Identifier "Semtech Touchscreen"
Option "Device" "/dev/serio_raw0"
Option "DebugLevel" "0"
Option "CalibrateA" "-369046"
Option "CalibrateB" "1114"
Option "CalibrateC" "4893014"
Option "CalibrateD" "-2152"
Option "CalibrateE" "-282719"
Option "CalibrateF" "5331971"
Option "CalibrateDiv" "-359811"
EndSection
Note that the device can also be called /dev/psaux depending on your setup.
Start X and run the touchcal program to calibrate your screen. It will ouput the calibration information
There is also a program called touchcal.pl, it requires the Perl Tk toolkit. The program will write calibration information on your X configuration file.
Download (0.12MB)
Added: 2005-11-23 License: MIT/X Consortium License Price:
813 downloads
Ethernet TAP driver 1.1
TAP provides packet reception and transmission for user-space programs. more>>
TAP provides packet reception and transmission for user-space programs. It can be viewed as a simple Ethernet device, which instead of receiving packets from a physical medium, receives them from a user-space program and instead of sending packets via physical media, writes them to the user-space program.
When a program opens /dev/tunX or /dev/tapX, driver creates and registers corresponding net device tunX or tapX. After a program closed above devices, driver will automatically delete tunXX or tapXX device and all routes corresponding to it.
This package(http://vtun.sourceforge.net/tun) contains two simple example programs that shows you how to use tun and tap devices. Both programs work like bridge between two network interfaces. br_select.c - bridge based on select system call. br_sigio.c - bridge based on async io and SIGIO signal. However the best example is VTun http://vtun.sourceforge.net
Enhancements:
- Massive Linux driver update: 2.4.x kernel support. New cloning interface, protocol indication. Statistics counting fixes.
- Solaris driver update: Correct Ethernet header substitution.
- Configure and Makefile updates. RPM package update.
- Documentation update.
<<lessWhen a program opens /dev/tunX or /dev/tapX, driver creates and registers corresponding net device tunX or tapX. After a program closed above devices, driver will automatically delete tunXX or tapXX device and all routes corresponding to it.
This package(http://vtun.sourceforge.net/tun) contains two simple example programs that shows you how to use tun and tap devices. Both programs work like bridge between two network interfaces. br_select.c - bridge based on select system call. br_sigio.c - bridge based on async io and SIGIO signal. However the best example is VTun http://vtun.sourceforge.net
Enhancements:
- Massive Linux driver update: 2.4.x kernel support. New cloning interface, protocol indication. Statistics counting fixes.
- Solaris driver update: Correct Ethernet header substitution.
- Configure and Makefile updates. RPM package update.
- Documentation update.
Download (0.006MB)
Added: 2006-07-04 License: GPL (GNU General Public License) Price:
1215 downloads
Apache LDAP vhost driver 1.1
Apache LDAP vhost driver lets you put vhost with all possible information in an LDAP database for both Apache 1.x and 2.x. more>>
Apache LDAP vhost driver project lets you put vhost with all possible information in an LDAP database for both Apache 1.x and 2.x.
Bug report system
With the new maintainence, there is now also a bug report system at the URL http://bugs.bayour.com/ (project mod_ldap_cfg).
Schemas
A schema called mod_ldap_cfg is used.
Apache config
To setup Apache to use this module, the httpd.conf is used.
<<lessBug report system
With the new maintainence, there is now also a bug report system at the URL http://bugs.bayour.com/ (project mod_ldap_cfg).
Schemas
A schema called mod_ldap_cfg is used.
Apache config
To setup Apache to use this module, the httpd.conf is used.
Download (MB)
Added: 2007-07-12 License: GPL (GNU General Public License) Price:
834 downloads
DBD::ODBC 1.14
DBD::ODBC Perl module contains a ODBC Driver for DBI. more>>
DBD::ODBC Perl module contains a ODBC Driver for DBI.
SYNOPSIS
use DBI;
$dbh = DBI->connect(dbi:ODBC:DSN, user, password);
Private DBD::ODBC Attributes
odbc_more_results (applies to statement handle only!)
Use this attribute to determine if there are more result sets available. SQL Server supports this feature. Use this as follows:
do { my @row; while (@row = $sth->fetchrow_array()) { # do stuff here } } while ($sth->{odbc_more_results});
Note that with multiple result sets and output parameters (i.e. using bind_param_inout, dont expect output parameters to be bound until ALL result sets have been retrieved.
odbc_ignore_named_placeholders
Use this if you have special needs (such as Oracle triggers, etc) where :new or :name mean something special and are not just place holder names You must then use ? for binding parameters. Example: $dbh->{odbc_ignore_named_placeholders} = 1; $dbh->do("create trigger foo as if :new.x :old.x then ... etc");
Without this, DBD::ODBC will think :new and :old are placeholders for binding and get confused.
odbc_default_bind_type
This value defaults to 0. Older versions of DBD::ODBC assumed that the binding type was 12 (SQL_VARCHAR). Newer versions default to 0, which means that DBD::ODBC will attempt to query the driver via SQLDescribeParam to determine the correct type. If the driver doesnt support SQLDescribeParam, then DBD::ODBC falls back to using SQL_VARCHAR as the default, unless overridden by bind_param()
odbc_force_rebind
This is to handle special cases, especially when using multiple result sets. Set this before execute to "force" DBD::ODBC to re-obtain the result sets number of columns and column types for each execute. Especially useful for calling stored procedures which may return different result sets each execute. The only performance penalty is during execute(), but I didnt want to incur that penalty for all circumstances. It is probably fairly rare that this occurs. This attribute will be automatically set when multiple result sets are triggered. Most people shouldnt have to worry about this.
odbc_async_exec
Allow asynchronous execution of queries. Right now, this causes a spin-loop (with a small "sleep") until the SQL is complete. This is useful, however, if you want the error handling and asynchronous messages (see the err_handler) below. See t/20SQLServer.t for an example of this.
odbc_exec_direct
Force DBD::ODBC to use SQLExecDirect instead of SQLPrepare() then SQLExecute. There are drivers that only support SQLExecDirect and the DBD::ODBC do() override doesnt allow returning result sets. Therefore, the way to do this now is to set the attributed odbc_exec_direct. There are currently two ways to get this: $dbh->prepare($sql, { odbc_exec_direct => 1}); and $dbh->{odbc_exec_direct} = 1; When $dbh->prepare() is called with the attribute "ExecDirect" set to a non-zero value dbd_st_prepare do NOT call SQLPrepare, but set the sth flag odbc_exec_direct to 1.
odbc_err_handler
Allow errors to be handled by the application. A call-back function supplied by the application to handle or ignore messages. If the error handler returns 0, the error is ignored, otherwise the error is passed through the normal DBI error handling structure(s).
This can also be used for procedures under MS SQL Server (Sybase too, probably) to obtain messages from system procedures such as DBCC. Check t/20SQLServer.t and mytest/testerrhandler.pl
The callback function takes three parameters: the SQLState, the ErrorMessage and the native server error.
odbc_SQL_ROWSET_SIZE
Here is the information from the original patch, however, Ive learned since from other sources that this could/has caused SQL Server to "lock up". Please use at your own risk!
SQL_ROWSET_SIZE attribute patch from Andrew Brown > There are only 2 additional lines allowing for the setting of > SQL_ROWSET_SIZE as db handle option. > > The purpose to my madness is simple. SqlServer (7 anyway) by default > supports only one select statement at once (using std ODBC cursors). > According to the SqlServer documentation you can alter the default setting > of > three values to force the use of server cursors - in which case multiple > selects are possible. > > The code change allows for: > $dbh->{SQL_ROWSET_SIZE} = 2; # Any value > 1 > > For this very purpose. > > The setting of SQL_ROWSET_SIZE only affects the extended fetch command as > far as I can work out and thus setting this option shouldnt affect > DBD::ODBC operations directly in any way. > > Andrew >
SQL_DRIVER_ODBC_VER
This, while available via get_info() is captured here. I may get rid of this as I only used it for debugging purposes.
odbc_cursortype (applies to connect only!)
This allows multiple concurrent statements on SQL*Server. In your connect, add { odbc_cursortype => 2 }. If you are using DBI > 1.41, you should also be able to use { odbc_cursortype => DBI::SQL_CURSOR_DYNAMIC } instead. For example:
my $dbh = DBI->connect("dbi:ODBC:$DSN", $user, $pass, { RaiseError => 1, odbc_cursortype => 2});
my $sth = $dbh->prepare("one statement");
my $sth2 = $dbh->prepare("two statement");
$sth->execute;
my @row;
while (@row = $sth->fetchrow_array) {
$sth2->execute($row[0]);
}
See t/20SqlServer.t for an example.
odbc_query_timeout
This allows the end user to set a timeout for queries on the ODBC side. After your connect, add { odbc_query_timeout => 30 } or set on the dbh before executing the statement. The default is 0, no timeout. Note that some drivers may not support this attribute.
See t/20SqlServer.t for an example.
odbc_has_unicode (applies to database handle only)
A read-only attribute signifying whether DBD::ODBC was built with the C macro WITH_UNICODE or not. A value of 1 indicates DBD::ODBC was built with WITH_UNICODE else the value returned is 0.
Building WITH_UNICODE affects columns and parameters which are SQL_C_WCHAR, SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCHAR.
When odbc_has_unicode is 1, DBD::ODBC will:
bind columns the database declares as wide characters as SQL_Wxxx
This means that UNICODE data stored in these columns will be returned to Perl in UTF-8 and with the UTF8 flag set.
bind parameters the database declares as wide characters as SQL_Wxxx
Parameters bound where the database declares the parameter as being a wide character (or where the parameter type is explicitly set to a wide type - SQL_Wxxx) can be UTF8 in Perl and will be mapped to UTF16 before passing to the driver.
NOTE: You will need at least Perl 5.8.1 to use UNICODE with DBD::ODBC.
NOTE: At this time SQL statements are still treated as native encoding i.e. DBD::ODBC does not call SQLPrepareW with UNICODE strings. If you need a unicode constant in an SQL statement, you have to pass it as parameter or use SQL functions to convert your constant from native encoding to Unicode.
NOTE: Binding of unicode output parameters is coded but untested.
NOTE: When building DBD::ODBC on Windows ($^O eq MSWin32) the WITH_UNICODE macro is automatically added. To disable specify -nou as an argument to Makefile.PL (e.g. nmake Makefile.PL -nou). On non-Windows platforms the WITH_UNICODE macro is not enabled by default and to enable you need to specify the -u argument to Makefile.PL. Please bare in mind that some ODBC drivers do not support SQL_Wxxx columns or parameters.
UNICODE support in ODBC Drivers differs considerably. Please read the README.unicode file for further details.
odbc_version (applies to connect only!)
This was added prior to the move to ODBC 3.x to allow the caller to "force" ODBC 3.0 compatibility. Its probably not as useful now, but it allowed get_info and get_type_info to return correct/updated information that ODBC 2.x didnt permit/provide. Since DBD::ODBC is now 3.x, this can be used to force 2.x behavior via something like: my $dbh = DBI->connect("dbi:ODBC:$DSN", $user, $pass, { odbc_version => 2});
<<lessSYNOPSIS
use DBI;
$dbh = DBI->connect(dbi:ODBC:DSN, user, password);
Private DBD::ODBC Attributes
odbc_more_results (applies to statement handle only!)
Use this attribute to determine if there are more result sets available. SQL Server supports this feature. Use this as follows:
do { my @row; while (@row = $sth->fetchrow_array()) { # do stuff here } } while ($sth->{odbc_more_results});
Note that with multiple result sets and output parameters (i.e. using bind_param_inout, dont expect output parameters to be bound until ALL result sets have been retrieved.
odbc_ignore_named_placeholders
Use this if you have special needs (such as Oracle triggers, etc) where :new or :name mean something special and are not just place holder names You must then use ? for binding parameters. Example: $dbh->{odbc_ignore_named_placeholders} = 1; $dbh->do("create trigger foo as if :new.x :old.x then ... etc");
Without this, DBD::ODBC will think :new and :old are placeholders for binding and get confused.
odbc_default_bind_type
This value defaults to 0. Older versions of DBD::ODBC assumed that the binding type was 12 (SQL_VARCHAR). Newer versions default to 0, which means that DBD::ODBC will attempt to query the driver via SQLDescribeParam to determine the correct type. If the driver doesnt support SQLDescribeParam, then DBD::ODBC falls back to using SQL_VARCHAR as the default, unless overridden by bind_param()
odbc_force_rebind
This is to handle special cases, especially when using multiple result sets. Set this before execute to "force" DBD::ODBC to re-obtain the result sets number of columns and column types for each execute. Especially useful for calling stored procedures which may return different result sets each execute. The only performance penalty is during execute(), but I didnt want to incur that penalty for all circumstances. It is probably fairly rare that this occurs. This attribute will be automatically set when multiple result sets are triggered. Most people shouldnt have to worry about this.
odbc_async_exec
Allow asynchronous execution of queries. Right now, this causes a spin-loop (with a small "sleep") until the SQL is complete. This is useful, however, if you want the error handling and asynchronous messages (see the err_handler) below. See t/20SQLServer.t for an example of this.
odbc_exec_direct
Force DBD::ODBC to use SQLExecDirect instead of SQLPrepare() then SQLExecute. There are drivers that only support SQLExecDirect and the DBD::ODBC do() override doesnt allow returning result sets. Therefore, the way to do this now is to set the attributed odbc_exec_direct. There are currently two ways to get this: $dbh->prepare($sql, { odbc_exec_direct => 1}); and $dbh->{odbc_exec_direct} = 1; When $dbh->prepare() is called with the attribute "ExecDirect" set to a non-zero value dbd_st_prepare do NOT call SQLPrepare, but set the sth flag odbc_exec_direct to 1.
odbc_err_handler
Allow errors to be handled by the application. A call-back function supplied by the application to handle or ignore messages. If the error handler returns 0, the error is ignored, otherwise the error is passed through the normal DBI error handling structure(s).
This can also be used for procedures under MS SQL Server (Sybase too, probably) to obtain messages from system procedures such as DBCC. Check t/20SQLServer.t and mytest/testerrhandler.pl
The callback function takes three parameters: the SQLState, the ErrorMessage and the native server error.
odbc_SQL_ROWSET_SIZE
Here is the information from the original patch, however, Ive learned since from other sources that this could/has caused SQL Server to "lock up". Please use at your own risk!
SQL_ROWSET_SIZE attribute patch from Andrew Brown > There are only 2 additional lines allowing for the setting of > SQL_ROWSET_SIZE as db handle option. > > The purpose to my madness is simple. SqlServer (7 anyway) by default > supports only one select statement at once (using std ODBC cursors). > According to the SqlServer documentation you can alter the default setting > of > three values to force the use of server cursors - in which case multiple > selects are possible. > > The code change allows for: > $dbh->{SQL_ROWSET_SIZE} = 2; # Any value > 1 > > For this very purpose. > > The setting of SQL_ROWSET_SIZE only affects the extended fetch command as > far as I can work out and thus setting this option shouldnt affect > DBD::ODBC operations directly in any way. > > Andrew >
SQL_DRIVER_ODBC_VER
This, while available via get_info() is captured here. I may get rid of this as I only used it for debugging purposes.
odbc_cursortype (applies to connect only!)
This allows multiple concurrent statements on SQL*Server. In your connect, add { odbc_cursortype => 2 }. If you are using DBI > 1.41, you should also be able to use { odbc_cursortype => DBI::SQL_CURSOR_DYNAMIC } instead. For example:
my $dbh = DBI->connect("dbi:ODBC:$DSN", $user, $pass, { RaiseError => 1, odbc_cursortype => 2});
my $sth = $dbh->prepare("one statement");
my $sth2 = $dbh->prepare("two statement");
$sth->execute;
my @row;
while (@row = $sth->fetchrow_array) {
$sth2->execute($row[0]);
}
See t/20SqlServer.t for an example.
odbc_query_timeout
This allows the end user to set a timeout for queries on the ODBC side. After your connect, add { odbc_query_timeout => 30 } or set on the dbh before executing the statement. The default is 0, no timeout. Note that some drivers may not support this attribute.
See t/20SqlServer.t for an example.
odbc_has_unicode (applies to database handle only)
A read-only attribute signifying whether DBD::ODBC was built with the C macro WITH_UNICODE or not. A value of 1 indicates DBD::ODBC was built with WITH_UNICODE else the value returned is 0.
Building WITH_UNICODE affects columns and parameters which are SQL_C_WCHAR, SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCHAR.
When odbc_has_unicode is 1, DBD::ODBC will:
bind columns the database declares as wide characters as SQL_Wxxx
This means that UNICODE data stored in these columns will be returned to Perl in UTF-8 and with the UTF8 flag set.
bind parameters the database declares as wide characters as SQL_Wxxx
Parameters bound where the database declares the parameter as being a wide character (or where the parameter type is explicitly set to a wide type - SQL_Wxxx) can be UTF8 in Perl and will be mapped to UTF16 before passing to the driver.
NOTE: You will need at least Perl 5.8.1 to use UNICODE with DBD::ODBC.
NOTE: At this time SQL statements are still treated as native encoding i.e. DBD::ODBC does not call SQLPrepareW with UNICODE strings. If you need a unicode constant in an SQL statement, you have to pass it as parameter or use SQL functions to convert your constant from native encoding to Unicode.
NOTE: Binding of unicode output parameters is coded but untested.
NOTE: When building DBD::ODBC on Windows ($^O eq MSWin32) the WITH_UNICODE macro is automatically added. To disable specify -nou as an argument to Makefile.PL (e.g. nmake Makefile.PL -nou). On non-Windows platforms the WITH_UNICODE macro is not enabled by default and to enable you need to specify the -u argument to Makefile.PL. Please bare in mind that some ODBC drivers do not support SQL_Wxxx columns or parameters.
UNICODE support in ODBC Drivers differs considerably. Please read the README.unicode file for further details.
odbc_version (applies to connect only!)
This was added prior to the move to ODBC 3.x to allow the caller to "force" ODBC 3.0 compatibility. Its probably not as useful now, but it allowed get_info and get_type_info to return correct/updated information that ODBC 2.x didnt permit/provide. Since DBD::ODBC is now 3.x, this can be used to force 2.x behavior via something like: my $dbh = DBI->connect("dbi:ODBC:$DSN", $user, $pass, { odbc_version => 2});
Download (0.12MB)
Added: 2007-07-26 License: Perl Artistic License Price:
822 downloads
MyHD/TL880 Linux Driver 0.2.0
MyHD/TL880 Linux Driver is a Linux driver for TL880-based HDTV tuner cards. more>>
MyHD/TL880 Linux Driver is a Linux driver for TL880-based HDTV tuner cards.
This is the development page for the Linux driver for the MyHD and other HDTV tuners based on the TL880 chip.
The driver is in early development stage right now, and we need lots of help testing. If you own any TL880-based card, please download the driver using the Downloads link at the left.
Keep in mind that the driver does not support video capture or playback at this time, but we need as many people as possible to run tests to help the driver move along.
<<lessThis is the development page for the Linux driver for the MyHD and other HDTV tuners based on the TL880 chip.
The driver is in early development stage right now, and we need lots of help testing. If you own any TL880-based card, please download the driver using the Downloads link at the left.
Keep in mind that the driver does not support video capture or playback at this time, but we need as many people as possible to run tests to help the driver move along.
Download (0.081MB)
Added: 2006-02-20 License: GPL (GNU General Public License) Price:
1342 downloads
nVidia Linux Display Driver IA32 100.14.11
nVidia Linux Display Driver is the OpenGL nVidia support for graphic cards on Linux operating systems. more>>
nVidia Linux Display Driver is the OpenGL nVidia support for graphic cards on Linux operating systems.
Installation:
Type "sh NVIDIA-Linux-x86-100.14.09-pkg1.run" to install the driver. NVIDIA now provides a utility to assist you with configuration of your X config file.
Enhancements:
Added support for new GPUs:
- GeForce 7050 PV / NVIDIA nForce 630a
- GeForce 7025 / NVIDIA nForce 630a
Fixed console restore problems in several different configurations:
- Quadro FX 4400 SLI
- VESA console
- Notebook LCD displays
- Improved interaction with ATi RS480/482 based mainboards.
- Improved support for House Sync with G-Sync II.
- Improved NVIDIA X driver interaction with ACPI daemon.
<<lessInstallation:
Type "sh NVIDIA-Linux-x86-100.14.09-pkg1.run" to install the driver. NVIDIA now provides a utility to assist you with configuration of your X config file.
Enhancements:
Added support for new GPUs:
- GeForce 7050 PV / NVIDIA nForce 630a
- GeForce 7025 / NVIDIA nForce 630a
Fixed console restore problems in several different configurations:
- Quadro FX 4400 SLI
- VESA console
- Notebook LCD displays
- Improved interaction with ATi RS480/482 based mainboards.
- Improved support for House Sync with G-Sync II.
- Improved NVIDIA X driver interaction with ACPI daemon.
Download (14.6MB)
Added: 2007-06-22 License: Other/Proprietary License Price:
868 downloads
nVidia FreeBSD Display Driver x86 100.14.11
nVidia FreeBSD Display Driver is the OpenGL nVidia support for graphic cards on FreeBSD operating systems. more>>
nVidia FreeBSD Display Driver is the OpenGL nVidia support for graphic cards on FreeBSD operating systems.
Enhancements:
Added support for new GPUs:
- GeForce 7050 PV / NVIDIA nForce 630a
- GeForce 7025 / NVIDIA nForce 630a
Fixed console restore problems in several different configurations:
- Quadro FX 4400 SLI
- VESA console
- Notebook LCD displays
- Improved interaction with ATi RS480/482 based mainboards.
- Improved support for House Sync with G-Sync II.
- Improved NVIDIA X driver interaction with ACPI daemon.
<<lessEnhancements:
Added support for new GPUs:
- GeForce 7050 PV / NVIDIA nForce 630a
- GeForce 7025 / NVIDIA nForce 630a
Fixed console restore problems in several different configurations:
- Quadro FX 4400 SLI
- VESA console
- Notebook LCD displays
- Improved interaction with ATi RS480/482 based mainboards.
- Improved support for House Sync with G-Sync II.
- Improved NVIDIA X driver interaction with ACPI daemon.
Download (10.9MB)
Added: 2007-06-22 License: Other/Proprietary License Price:
878 downloads
Other version of nVidia FreeBSD Display Driver x86
License:Other/Proprietary License
odbc-bench 1.0.0
OpenLink ODBC Bench is an open-source ODBC Benchmarking tool. more>>
OpenLink ODBC Bench is an open-source ODBC Benchmarking tool providing real-time comparative benchmarking for ODBC Drivers, Database Engines, and Operating Systems combinations.
The Benchmarks in this application are loosely based on the TPC-A and TPC-C standard benchmarks, with modifications to specifically test the performance of an ODBC Driver and/or Database Engine in a client/server environment.
The benchmark results can be automatically stored to an ODBC Datasource or XML file for further analysis and comparisons to be made.
ODBC-Bench is licensed under the terms of the GNU General Public License version 2.
<<lessThe Benchmarks in this application are loosely based on the TPC-A and TPC-C standard benchmarks, with modifications to specifically test the performance of an ODBC Driver and/or Database Engine in a client/server environment.
The benchmark results can be automatically stored to an ODBC Datasource or XML file for further analysis and comparisons to be made.
ODBC-Bench is licensed under the terms of the GNU General Public License version 2.
Download (1.3MB)
Added: 2005-11-10 License: GPL (GNU General Public License) Price:
1445 downloads
Secleted [ 0 ] software to compare
Copyright Notice:
Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future software development. The above hdbc odbc driver 1.0.1.1 search only lists software in full, demo and trial versions for free download. Download links are directly from our mirror sites or publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed