Sponsored Content
Full Discussion: Updating the ODBC.ini file
Top Forums UNIX for Dummies Questions & Answers Updating the ODBC.ini file Post 302351468 by Ariean on Tuesday 8th of September 2009 03:57:03 PM
Old 09-08-2009
Updating the ODBC.ini file

Hi,

I want to access MS SQL Server database through Informatica which is an ETL tool installed on sun solaris Unix operating system. For me to access the MS SQL Server i studied that i need to update the odbc.ini file on Unix box. Could you please let me know how and where i can access this file and what should be my required entries in that file to access MS SQL Server. Appreciate your time.

Thanks & Regards,
Sam.
 

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

reading data from .ini file

Hi, I have a sample data file that contains name-value pairs in it. For example: name1=value1 name2=value2 name3=value3 ... ... ... My concern is 1. How to get values of name1, name2, name3 using korn shell script? 2. I don't want to access each varible using $name1,$name2, $name3... (2 Replies)
Discussion started by: vinna
2 Replies

3. Shell Programming and Scripting

awk updating one file with another, comparing, updating

Hello, I read and search through this wonderful forum and tried different approaches but it seems I lack some knowledge and neurones ^^ Here is what I'm trying to achieve : file1: test filea 3495; test fileb 4578; test filec 7689; test filey 9978; test filez 12300; file2: test filea... (11 Replies)
Discussion started by: mecano
11 Replies

4. Shell Programming and Scripting

SED 4.1.4 - INI File Change Problem in Variables= in Specific [Sections] (Guru Help)

GNU sed version 4.1.4 on Windows XP SP3 from GnuWin32 I think that I've come across a seemingly simple text file change problem on a INI formatted file that I can't do with SED without side effects edge cases biting me. I've tried to think of various ways of doing this elegantly and quickly... (5 Replies)
Discussion started by: JakFrost
5 Replies

5. Ubuntu

php.ini

Hi, I have installed ubuntu server lamp. When I used the command locate to find the php.ini file I found two location. /etc/php5/cli/php.ini /etc/php5/apache2/php.ini When I want to change the setting of the php, which one of them should I change and why I have this file twice? (3 Replies)
Discussion started by: programAngel
3 Replies

6. Shell Programming and Scripting

Trouble with sed and ini file parsing

hi people, i'm having a hard time trying to extract a list of vars delimited by section inside a ini file ... let's consider this ini file : ; config file DESC = "channel synchro TGG01" DMM_VER = DMM23 PATH_FIFO = /users/tgg00/fifo QRT = BTS01.TGG.01.2 MODE_TRACE... (5 Replies)
Discussion started by: odium74
5 Replies

7. Shell Programming and Scripting

sed - String substitution within specified section in ini type file

Hello. I am trying to modify a config file which is in windows *.ini type file. I have found a piece of code here :linux - Edit file in unix using SED - Stack Overflow As I can't make it doing the job , I am trying to find a solution step by step. here a modified sample file : my_sample.ini... (1 Reply)
Discussion started by: jcdole
1 Replies

8. Shell Programming and Scripting

Help updating a file

I can not seem to figure out how to update the attached match.txt column 2 using update.txt. However, only the text before the period in updat.txt appears in match.txt. For example, in update.txt NM_001613.2 matches NM_001613 in match.txt, so is it possible to update the record in match.txt to... (8 Replies)
Discussion started by: cmccabe
8 Replies

9. Shell Programming and Scripting

Insert new line of text into Odbc.ini file

I am new to Perl. I wrote a Perl program that inserts text "EnableScrollableCursors=3" after a section of contexts in the odbc.ini file matches a variable in an array list. "EnableScrollableCursors=3" is added to a newline before whitespaces separate each section of contexts in the odbc.ini. ... (0 Replies)
Discussion started by: dellanicholson
0 Replies

10. UNIX for Beginners Questions & Answers

Updating in file

hi, i have an csv(which is a month's log file containing userid and log in date ) file which has to be appended to another file say master.log.I need to compare the next month's log data to master.log file .In case, there is new log date for userid it has to get updated in master.log file or i... (2 Replies)
Discussion started by: preema
2 Replies
DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server(3)User Contributed Perl DocumentatioDBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server(3)

NAME
DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server - Support specific to Microsoft SQL Server over ODBC DESCRIPTION
This class implements support specific to Microsoft SQL Server over ODBC. It is loaded automatically by by DBIx::Class::Storage::DBI::ODBC when it detects a MSSQL back-end. Most of the functionality is provided from the superclass DBIx::Class::Storage::DBI::MSSQL. USAGE NOTES
Basic Linux Setup (Debian) sudo aptitude install tdsodbc libdbd-odbc-perl unixodbc In case it is not already there put the following (adjust for non-64bit arch) in "/etc/odbcinst.ini": [FreeTDS] Description = FreeTDS Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so UsageCount = 1 Set your $dsn in connect_info as follows: dbi:ODBC:server=<my.host.name>;port=1433;driver=FreeTDS;tds_version=8.0 If you use the EasySoft driver (<http://www.easysoft.com>): dbi:ODBC:server=<my.host.name>;port=1433;driver=Easysoft ODBC-SQL Server Basic Windows Setup Use the following $dsn for the Microsoft ODBC driver: dbi:ODBC:driver={SQL Server};server=SERVERSQL_SERVER_INSTANCE_NAME And for the Native Client: dbi:ODBC:driver={SQL Server Native Client 10.0};server=SERVERSQL_SERVER_INSTANCE_NAME Go into Control Panel -> System and Security -> Administrative Tools -> Data Sources (ODBC) to check driver names and to set up data sources. Use System DSNs, not User DSNs if you want to use DSNs. If you set up a DSN, use the following $dsn for connect_info: dbi:ODBC:dsn=MY_DSN MULTIPLE ACTIVE STATEMENTS
The following options are alternative ways to enable concurrent executing statement support. Each has its own advantages and drawbacks and works on different platforms. Read each section carefully. For more details about using MAS in MSSQL over DBD::ODBC see this excellent document provided by EasySoft: http://www.easysoft.com/developer/languages/perl/multiple-active-statements.html <http://www.easysoft.com/developer/languages/perl/multiple-active-statements.html>. In order of preference, they are: o mars o dynamic_cursors o server_cursors METHODS
connect_call_use_mars Use as: on_connect_call => 'use_mars' in your connection info, or alternatively specify it directly: Your::Schema->connect ( $original_dsn . '; MARS_Connection=Yes', $user, $pass, \%attrs, ) Use to enable a feature of SQL Server 2005 and later, "Multiple Active Result Sets". See "Does DBD::ODBC support Multiple Active Statements?" in DBD::ODBC::FAQ for more information. This does not work on FreeTDS drivers at the time of this writing, and only works with the Native Client, later versions of the Windows MS ODBC driver, and the Easysoft driver. connect_call_use_dynamic_cursors Use as: on_connect_call => 'use_dynamic_cursors' Which will add "odbc_cursortype => 2" to your DBI connection attributes, or alternatively specify the necessary flag directly: Your::Schema->connect (@dsn, { ... odbc_cursortype => 2 }) See "odbc_cursortype" in DBD::ODBC for more information. If you're using FreeTDS, "tds_version" must be set to at least 8.0. This will not work with CODE ref connect_info's. WARNING: on FreeTDS (and maybe some other drivers) this will break "SCOPE_IDENTITY()", and "SELECT @@IDENTITY" will be used instead, which on SQL Server 2005 and later will return erroneous results on tables which have an on insert trigger that inserts into another table with an "IDENTITY" column. WARNING: on FreeTDS, changes made in one statement (e.g. an insert) may not be visible from a following statement (e.g. a select.) WARNING: FreeTDS versions > 0.82 seem to have completely broken the ODBC protocol. DBIC will not allow dynamic cursor support with such versions to protect your data. Please hassle the authors of FreeTDS to act on the bugs that make their driver not overly usable with DBD::ODBC. connect_call_use_server_cursors Use as: on_connect_call => 'use_server_cursors' May allow multiple active select statements. See "odbc_SQL_ROWSET_SIZE" in DBD::ODBC for more information. Takes an optional parameter for the value to set the attribute to, default is 2. WARNING: this does not work on all versions of SQL Server, and may lock up your database! At the time of writing, this option only works on Microsoft's Windows drivers, later versions of the ODBC driver and the Native Client 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.16.2 2012-08-23 DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server(3)

Featured Tech Videos

All times are GMT -4. The time now is 08:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy