Re: RE: Using ODBC to access Informix from Win95

Well, I guess mixing apples and oranges is better than oil and water! Luckily, my problem isn't really that tough, I just phrased it poorly,. I don't actually need to USE the Informix files on NT. My job is to get the data from the UNIX box into Access so it can be moved to another application. This is why I need to set up the ODBC connection. Since they don't want me to practice on the live accounting data, I copied the .dat files from the UNIX box to my hard drive. Now, when I select the Informix ODBC driver, I'm asked fro the following: Data Source Name Database Server Host Service Protocol Which makes a lot of sense when connecting to a Unix server, but I'm trying to get a file called Ledger.Dat, located in c:\\access, imported into Microsoft Access. Therein lies my problem. >>> "Wallick, Steve" <swallick@harris.com> 11/25/98 10:15AM >>> Wow, you are really mixing apples and oranges here. The UNIX files are of type Informix SE and the NT box supports IDS type. Completely different way of doing buisness. You will need to reincarnate your UNIX session and unload the data to flat files then import them into your NT informix session. Good Luck steve > -----Original Message----- > From: DC@SEVERSON.COM (Temp Nine) [mailto:dc@severson.com] > Sent: Wednesday, November 25, 1998 12:34 PM > To: informix-list@iiug.org > Subject: Using ODBC to access Informix from Win95 > > > Can you access Informix files which were copied from the > UNIX system and put on an Win95 hard drive? And if so, how > do you configure the ODBC driver to do this? > > We are in the process of migrating a proprietary > Informix-based application from Unix to our NT platform. > The entire system, including the UNIX box, is an unknown > quantity to the in-house staff, so we FTP'd the dat, idx, > and h files off the UNIX box and onto my local hard drive. > The Informix ODBC drive insists on having information like > Server and Host which are no longer applicable (I tried > telnetting into myself and failed). > > Please reply to > DC@SEVERSON.COM > and thank you > > > > > > > > > > > > > > >