Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::storage::dbi::odbc::access(3) [osx man page]

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

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.16.2 2012-08-16 DBIx::Class::Storage::DBI::ODBC::ACCESS(3)

Check Out this Related Man Page

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

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 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.18.2 2014-01-05 DBIx::Class::Storage::DBI::ODBC::ACCESS(3)
Man Page

14 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

ODBC connections from MSAccess suppression

Can anyone tell me if there is a way to stop MSAccess ODBC connections to an Oracle database on HPUX? Thanks. (2 Replies)
Discussion started by: rushton
2 Replies

2. UNIX for Dummies Questions & Answers

IQ 2.69 Database by Programmed Intelligence Corp (10+ years old)

Hi guys. I have a old Unix box here that has loads of accountancy info on it. Id like to be able to get in via ODBC or whatever (even a direct dump would be nice). However it seems the company changed its name to IQ Software Corporation, then went bust! Is there anyone who has any knowledge... (2 Replies)
Discussion started by: RageMonkey
2 Replies

3. Shell Programming and Scripting

Deleting specific columns from a file

Hi Friends, I want to delete specific columns from a file. Say my file content is as follows: "1","a","ww1",1234" "2","b","wwr3","2222" "3","c","erre","3333" Now i want to delete the column 2 and 4 from this file. That is I want the file content to be: "1","ww1" "2","wwr3"... (11 Replies)
Discussion started by: premar
11 Replies

4. UNIX for Dummies Questions & Answers

ODBC Version

how to find the version of ODBC and the database drivers in Unix box :eek: (0 Replies)
Discussion started by: raghunath_mv
0 Replies

5. UNIX for Dummies Questions & Answers

ODBC on UNIX

I see several questions regarding setting up ODBC on UNIX machines but I don't see any replies. I always thought ODBC was only possible on Windows machines, but I've recently heard drivers do exist for ODBC on UNIX. Does anyone know any more details about this: How to set up ODBC on UNIX, web sites... (1 Reply)
Discussion started by: ggmar
1 Replies

6. Shell Programming and Scripting

Adding columns to excel files using Perl

How do I add 4 columns to an excel file using Perl? The 4 headers for those columns will all have different names? Please help and I greatly appreciate... (1 Reply)
Discussion started by: dolo21taf
1 Replies

7. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

8. AIX

Routing setup - AIX

Hi All, I know there is a way to do this in routers. The question is whether it is posisble to do this in AIX. For our Web Focus ODBC connection to the Disaster Recovery servers, we want to restrict the access to the ODBC ports so that only the IP address of the Web Focus server can get to... (1 Reply)
Discussion started by: strunz
1 Replies

9. AIX

ODBC Connectivity between Oracle10g on AIX and Mainframe

Hi, I have a task of setting up connectivity between Oracle 10g (AIX) and Mainframe (1 library). Went through couple of documents, forums, blogs etc. MY understanding is ODBC Generic Connectivity is free from Oracle side. Question: (may be dumb to you) 1. Has anybody done this and would... (3 Replies)
Discussion started by: jvmani_1
3 Replies

10. Shell Programming and Scripting

Remove line starting from space till end.

Hi, I have a code tag, from which i have the below snippet: intelrpt.GetCMB_FB type=ODBC> intelrpt.GetCMB_FB type=SYBASE> I want the output like: intelrpt.GetCMB_FB intelrpt.GetCMB_FB That is remove the lines starting from WHITESPACE till end. Please help. I am new to... (7 Replies)
Discussion started by: anupdas
7 Replies

11. Shell Programming and Scripting

Need to undo hyphenation in columns

I have a file with two columns (output from Tivoli Storage Manager) where each column has 13 character spaces and they are separated by 5 spaces. The columns are schedule names and node names and many of them are longer than 13 characters so they get hyphenated by TSM during the output. I... (3 Replies)
Discussion started by: jongudm
3 Replies

12. Emergency UNIX and Linux Support

Read *.accdb files in GNU/Linux

Hi Guys, Can you please suggest me to read the *.accdb files under linux enviornment? I have google a bit. There is some solution to convert the *.accdb files under windows environment. But I am trying to do it in Linux environment. Please provide your thoughts. Thanks, Ranga :) (3 Replies)
Discussion started by: rangarasan
3 Replies

13. UNIX for Dummies Questions & Answers

ODBC Hive error

Hi , I am trying to setup HIVE ODBC with below setting Host: Local host port : 10000 Database : Default Hive server type : Hive server 2 Mechanism: User But getting below error: Driver Version: V2.5.0.1001 Running connectivity tests... Attempting connection Failed to... (1 Reply)
Discussion started by: rakesh_411
1 Replies

14. UNIX and Linux Applications

Using BTEQ with perl to Teradata

Has anyone used either bteq or mload for inserting into a Teradata Database via perl. We're running Red Hat Enterprise 5.7. I've gotten the DBD::ODBC drivers installed and running. I installed the Teradata ICU, TeraGSS and ODBC pkgs. We are using perl to insert data across the network into... (1 Reply)
Discussion started by: islanderman
1 Replies