[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Connect to Informix DB through SQL Server stored-procedure

Posted on 2006-04-03
1
Medium Priority
?
1,394 Views
Last Modified: 2006-11-18
Hi, All!

What I need is to access an Informix database using a MS SQL Server 2000 stored-procedure. These are the steps I need to develop:

1. Connect to an Informix database using an ODBC connection which I already have configured;
2. Fetch data from the Informix database (it's a very simple SELECT statement);
3. Write the result of that query to a text file, using however any file manipulation objects (I believe they exist).

In conclusion, what I need to know is:

1. How to use Informix ODBC connection on a SQL Server 2000 stored-procedure.
2. How to create (or not) any kind of cursors which can help me fetch data.
3. How to write to a text file or what objects may I use to edit text files on the hard disk.

Can someone please help on this one? I don't really know much about stored-procedures in SQL Server, however I have good programming background, which will make it easy for me to understand any solution or information you may provide me.

Thankx in advance!

Paulo
0
Comment
Question by:paulop1975
1 Comment
 
LVL 9

Accepted Solution

by:
gabeso earned 750 total points
ID: 16360667
It'll be something like this but you'll need to identify the exact name of the informix driver in {Informix}: Just fill in all the bits between <> characters.

SELECT
  *
FROM OPENROWSET(  'MSDASQL', 'DRIVER={Informix};SERVER=<Server>;UID=<username>;PWD=<password>',   <table>)

You run this in sql server.

If you export the data from Informix to sql server you can then manipulate it there.

As for getting data to text files, csv files or whatever you can use DTS from the sql server enterprise manager - it will do everything you want.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question