Re: ODBC or Import Flat Files?
Posted in 1998
Hi, I don't think the connection should be slow. I use Informix 7.2 and get the data through ODBC. It is pretty fast. Did you check the network traffic. Try using some other tool besides Access and see if there is any difference. Imran. Edward Villalovoz wrote: > > I set up my odbc connection between my access97 database and my informix > server 7.2 and the connection is so slooooooow that i could probably manual > input the data faster. Can anyone tell me if this is slow performance is > normal for an odbc connection? Should I import the flat files or stick with > the odbc connection? What are the pros and cons? Thanks in advance. -- =========================================== Imran Hussain MCP, MCSD imranh@summitdata.com http://www.summitdata.com/imranh ===========================================