Re: SQL Server CE to other databases

Jean Sagi wrote: > Ouch... > > I didn't see that you mention SQL Server 2000 CE... > I've done it with SQL-Server 97 and 2000 (The servers) and with the OLE > DB provider for odbc. It should be with the Informix OLE-DB provider but > I can't make it work. > > If I suppose 2000-CE is similar to 2000-Server they are similar then the > following may help you: > > 1. Check you have or install Informix Connect or CDSK on the machine you > hace Sql-Server. > > 2. Create an odbc system data sourtce to your Informix database and test > it connect sucsessfully. > > 3. In Sql-Server in security add a new linked server: > * the provider is OLE-DB provider for ODBC > * choose a name for the linked server ie: IFX_LNKD_SER > * Specify the name of the data source you created in step 2 > * And specify the connect string for ODBC. > I don't remember the connection string but DBping helps you here. > (If you have IDS-10 sorry CDSK 2.9 doesn't have Dbping) > * And accept it. > > If all goes well you can see the lists of tables when you clik on the > new created linked server. > > More or less there is the same procedure to other data sources, in books > online it states that you can link this way to oracle. > > Finally you can use openquery to access remote tables, for example > > select * > from sql_server_table a > inner join > openquery( IFX_LNKD_SER, 'select * from informix_table' ) as b > on (a.pk = b.pk)> go > > Cool isn't it? > > > J. > > > > > No one wrote: > >>Jean Sagi wrote: >> >> >>>Yes it is possible >>> >>>No one wrote: >>> >>> >>> >>>>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 >> >> >>Care to enlighten me a bit? >> > > sending to informix-list Informix has limited support on the Windows CE platform. There is only a JDBC driver for CE. I ended up putting the ADO.Net access on the server and wrote Web services to do the database needs. The .Net client on the CE.Net machine uses and consumes the Web services.