RE: SQL Server CE to other databases

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