Visit Our UNIX and Linux User Community


Updating the ODBC.ini file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Updating the ODBC.ini file
# 1  
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.
# 2  
Old 09-12-2009
Lightbulb Not sure if you got your file already

This might take some time,
but will find it if you can give it some time.
Try the /etc folder, have seen most of such config files for DW systems in this folder.
or
Code:
find / -name "odbc.ini" -print | more

I doubt anybody on this forum can help with your second question Smilie.
Better try any Informatica forum, or the help manuals.Guessing them manuals, have it all.
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #222
Difficulty: Easy
NetMarketShare reported that the combined versions of Microsoft Windows lead the worldwide market with close to a 93% market share at the end of August 2011, followed by OS X at 6%, and Linux with 1%.
True or False?

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

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

Featured Tech Videos