01-18-2012
9 More Discussions You Might Find Interesting
1. Solaris
Dear All
Now I can't connect from VB to Sybase on Unix. How could I do?
Please help me. (0 Replies)
Discussion started by: Than Chanroeun
0 Replies
2. AIX
Hi All,
Am porting my application from AIX to Windows. As a part of this I need to port the Database in IBM DB2 UDB to SQL Server 2005. Is there any Guide/Doc/Article available on this? How to convert the stored procedures and physical data from DB2 to SQL Server 2005?
Thanks in Advance (0 Replies)
Discussion started by: mvictorvijayan
0 Replies
3. Solaris
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
Kindly let me know on how to do this
Thanks,
Double post. Continue here (0 Replies)
Discussion started by: amitbhelave
0 Replies
4. Shell Programming and Scripting
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
I am using solaris-5.1 to run shell script and want to connect to SQL-5.1 which is installed on SantOS.
Kindly let... (3 Replies)
Discussion started by: amitbhelave
3 Replies
5. Shell Programming and Scripting
Hello All
I am getting a problem.What i want to do is to connect unix(korn shell) and sql server 2005. But it is not happening.
The task is to schedule a job using crown or something else that connect with sql server 2005 and run the query and save the result in a text file. (5 Replies)
Discussion started by: parthmittal2007
5 Replies
6. Shell Programming and Scripting
I need to connect sql server 2008 from korn shell script. Can you please give me the script which connects sql server 2008 from korn shell script. (2 Replies)
Discussion started by: santoshhegde
2 Replies
7. SuSE
I am trying to establish connection with SQL server 2008 through ODBC on Linux. First step would be
1. How to verify if ODBC driver for SQL server is installed on Linux OS.
PLease let me know how to do it/ if there is any link which could be helpful in this context.
thanks in advance (1 Reply)
Discussion started by: cvsanthosh
1 Replies
8. AIX
Hello aix community,
After scouring the internet to find a step by step process, I've exhausted my efforts. Although I have learned a lot which brings me to this forum. I'm totally new and hope to ask the right questions.
What is the easiest way to connect to a SQL server from aix?
... (2 Replies)
Discussion started by: TechStudent36
2 Replies
9. AIX
I have a requirement and below is the detail.
Create a shell script and needs to run in server "a".
Connect to teradata database server "b".
execute the .sql file from server "a"
Save the output of the query to a file in server "a"
Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::ado::ms_jet5.18
DBIx::Class::Storage::DBI::ADO::MS_Jet(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::ADO::MS_Jet(3)
NAME
DBIx::Class::Storage::DBI::ADO::MS_Jet - Support for MS Access over ADO
DESCRIPTION
This driver is a subclass of DBIx::Class::Storage::DBI::ADO and DBIx::Class::Storage::DBI::ACCESS for connecting to MS Access via DBD::ADO.
See the documentation for DBIx::Class::Storage::DBI::ACCESS for information on the MS Access driver for DBIx::Class.
This driver implements workarounds for "TEXT/IMAGE/MEMO" columns, sets the cursor_class to DBIx::Class::Storage::DBI::ADO::MS_Jet::Cursor
to normalize returned "GUID" values and provides DBIx::Class::InflateColumn::DateTime support for "DATETIME" columns.
EXAMPLE DSNs
# older Access versions:
dbi:ADO:Microsoft.Jet.OLEDB.4.0;Data Source=C:Users
kitoverDocumentsaccess_sample.accdb
# newer Access versions:
dbi:ADO:Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Users
kitoverDocumentsaccess_sample.accdb;Persist Security Info=False'
TEXT
/IMAGE/MEMO COLUMNS
The ADO driver does not suffer from the problems the ODBC driver has with these types of columns. You can use them safely.
When you execute a "CREATE TABLE" statement over this driver with a "TEXT" column, it will be converted to "MEMO", while in the ODBC driver
it is converted to "VARCHAR(255)".
However, the caveat about LongReadLen having to be twice the max size of your largest "MEMO/TEXT" column +1 still applies. DBD::ADO sets
LongReadLen to a large value by default, so it should be safe to just leave it unset. If you do pass a LongReadLen in your connect_info, it
will be multiplied by two and 1 added, just as for the ODBC driver.
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 2013-09-24 DBIx::Class::Storage::DBI::ADO::MS_Jet(3)