Informix SE linked tables through MS SQL 
Author Message
 Informix SE linked tables through MS SQL

Dear Group,

I have my Informix SE database linked via ODBC in MS SQL 2000.  I've created
views on the linked tables but the queries take some time to run and some
cause my asp page to expire.  I know in MS SQL 2000 you can create an index
on a view but it doesn't allow me to create indexes for views whose base
tables are linked tables.  Does anyone know how to work around this?  I've
downloaded the latest Informix SDK and I'm using the ODBC drivers from that.

P.S. I know this should be a question more for an MS SQL user group but I've
grown up with Informix and this user group and all the other resources I've
tried has proved fruitless.

TIA

Austin



Fri, 11 Jun 2004 09:30:43 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. INFORMIX ODBC 3.34 / MS-ACCESS / INFORMIX SE ( Solaris 7 )

2. NT MS-SQL 6.5 Vs UNIX Informix SE 5

3. linking an MS-Access based table from within an MS-SQL database

4. #DELETED in all rows when using MS Access 2000 table linking with Informix

5. Linking SQL Server Table to MS Access Table

6. SQL-Links with Oracle or MS SQL: Can not write to tables

7. Informix SE - MS-DOS and Hyperscript

8. Informix SE ODBC Errors using MS Access #-201 Syntax Error Occured

9. Informix SE 7.12 --> MS-ACCESS 7

10. Informix SE for MS Windows

11. Informix SE, MS Access, ODBC

12. Informix SE/Esker/MS query


 
Powered by phpBB® Forum Software