database question as400 - sql

[QTip]

Hellow,

I have to make a website (application) where the data has to come from an AS400 database. I already tried a direct connection (ODBC and OLEDB) via Client Access between AS400 and the asp page. I notice that when my sql statement becomes more complex, the request for data is very slow. Too slow to use.
A second option is a third-party tool to synchronize the as400 database with a sql-server database.

Does anybody have any experience with this? Do you guys use a direction connection to AS400? Or do you have that kind of tool between as400 and another database (like SQL server).
Tell me what are your opinions?

Thnx!

 

[QTip]

hmm... doesn't anybody have any idea about this?

 

[onpnt]

are you trying to query multiple PF's instead of utilizing logical files?

_____________________________________________________________________
[sub]Where have all my friends gone to????[/sub]

http://www.onpntwebdesigns.com

 

[QTip]

No, I'm using logical files. But even on the most simple query (select [data] from

) it's very slow.

Any solutions?