Read *.accdb files in GNU/Linux Post: 302737901

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

GNU and Linux: Different or the same?

Sorry for sounding like an incredible n00b, but as I have been lurking and searching on the net, I have come across something that may be common sense to most, but to me is confusing. I constantly see the word GNU when I do searches for Linux, both on this web site and on search engines. I found...

2. UNIX for Advanced & Expert Users

read() wont allow me to read files larger than 2 gig (on a 64bit)

Hi the following c-code utilizing the 'read()' man 2 read method cant read in files larger that 2gig. Hi I've found a strange problem on ubuntu64bit, that limits the data you are allowed to allocate on a 64bit platform using the c function 'read()' The following program wont allow to allocate...

3. Fedora

FreeBSD or GNU/Linux?

Hi, i'm working on micro$oft windows based networking environment's. i want learn other os than micro$oft windows. i tested FreeBSD & Gnu/Linux (Fedora). both are similar. which of following is best choice for me? for networking? and which of them has future (for e.g not discontinued after 2...

4. UNIX for Beginners Questions & Answers

Linux read specific content file from tar.gz files without extracting

hello i wish to write the result of these below conditions in a file: 1. in a specific folder, i have many tar.gz files. 2. each tar.gz file contains ".dat" file in sub folders. 3. i wish to get the full path of these .dat files, if i find in it a specific word ("ERROR24"). 4. all this...

LEARN ABOUT DEBIAN

dbix::class::storage::dbi::odbc::access

DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)		User Contributed Perl Documentation	      DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)

NAME

       DBIx::Class::Storage::DBI::ODBC::ACCESS - Support specific to MS Access over ODBC

DESCRIPTION

       This class implements support specific to Microsoft Access over ODBC.

       It is a subclass of DBIx::Class::Storage::DBI::ODBC and DBIx::Class::Storage::DBI::ACCESS, see those classes for more information.

       It is loaded automatically by by DBIx::Class::Storage::DBI::ODBC when it detects a MS Access back-end.

       This driver implements workarounds for "IMAGE" and "MEMO" columns, and DBIx::Class::InflateColumn::DateTime support for "DATETIME" columns.

EXAMPLE DSN

	 dbi:ODBC:driver={Microsoft Access Driver (*.mdb, *.accdb)};dbq=C:Users
kitoverDocumentsaccess_sample.accdb

TEXT
/IMAGE/MEMO COLUMNS
       Avoid using "TEXT" columns as they will be truncated to 255 bytes. Some other drivers (like ADO) will automatically convert "TEXT" columns
       to "MEMO", but the ODBC driver does not.

       "IMAGE" columns work correctly, but the statements for inserting or updating an "IMAGE" column will not be cached, due to a bug in the
       Access ODBC driver.

       "MEMO" columns work correctly as well, but you must take care to set LongReadLen to "$max_memo_size * 2 + 1". This is done for you
       automatically if you pass LongReadLen in your connect_info; but if you set this attribute directly on the $dbh, keep this limitation in
       mind.

AUTHOR

       See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.14.2							    2011-05-10			      DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)