Re: SQL Server CE to other databases

ODBC and OLE.DB are not available for informix on Windows CE.Net. The only connector is a JDBC driver. Savio Pinto (s) wrote: > sqlserver 2000 can connect to informix and oracle using odbc and ole db, here are the details for ole db connections using linked servers > > informix: > - select "IBM Informix OLE DB provider" in the Product Name > - in Data Source enter "database_name@instance_name" > - for this to work, you need to create few oledb tables in the sysmaster database. > - if you don't have the details about the oledb tables that need to be created in informix database let me know, i will email you the script. > > oracle: (for oracle 9i) > - select "Microsoft OLE DB provider for Oracle" in the product name > - in Data source enter oracle database name > - enter "MSDAORA" in provider string > > > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of No one > Sent: Friday, April 15, 2005 9:20 PM > To: informix-list@iiug.org > Subject: SQL Server CE to other databases > > > As anyone had success hooking Microsoft's SQL Server 2000 CE to any > other database other than MS SQL? How about say to Oracle or Informix? > It cliams to be able to connect to any OLE DB. So far I've not > found this to be true. Anyone else?? > > Thanks in advance > > sending to informix-list