VMware and ODBC

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues

Bessi Adalsteinsson — Wed, 14 Jul 99 10:04:12 GMT — source: Informix-list mailing list archive (1991-1998)

Is it possible to connect from a Win98 client, running in a virtual machine (VMware) under Linux, to Informix SE running under Linux on the same physical machine, using Informix-CLI 2.5, ODBC driver 2.12? I have got various error messages but seem to be closest to my target when I get the following: InformixAttempt to connect to database server (laptop) failed. Connection refused. As far as I know this scenario is not supported, but could it work? Anyone? Regards, Bessi Adalsteinsson bessi@lexis.hi.is Institute of Lexicography University of Iceland Neshaga 16, 107 Reykjavik ICELAND

↪ replying to Bessi Adalsteinsson

Gregg Berkholtz — Wed, 14 Jul 1999 13:23:54 -0700 — source: Informix-list mailing list archive (1991-1998)

I have done this before with PostgreSQL and Win95 ontop of Linux (Debian/GNU 2.1). Works well. How is your networking setup for your virtual machine? Is it bridged or something else? Regards, Bessi Adalsteinsson wrote: > Is it possible to connect from a Win98 client, running in a virtual > machine (VMware) under Linux, to Informix SE running under Linux on the > same physical machine, using Informix-CLI 2.5, ODBC driver 2.12? > > I have got various error messages but seem to be closest to my target > when I get the following: InformixAttempt to connect to database server > (laptop) failed. Connection refused. > > As far as I know this scenario is not supported, but could it work? > > Anyone? > > Regards, > Bessi Adalsteinsson bessi@lexis.hi.is > Institute of Lexicography > University of Iceland > Neshaga 16, 107 Reykjavik > ICELAND

↪ replying to Gregg Berkholtz

Bessi Adalsteinsson — Fri, 16 Jul 99 14:53:45 GMT — source: Informix-list mailing list archive (1991-1998)

Networking is brigded, yes. Pinging, ftp, etc. works fine between them. Regards, BA In article <378CF1D9.62320F76@yoshida.com>, Gregg Berkholtz <gregg.berkholtz@yoshida.com> wrote: >I have done this before with PostgreSQL and Win95 ontop of Linux >(Debian/GNU 2.1). Works well. > >How is your networking setup for your virtual machine? Is it bridged or >something else? > >Regards, -- Bessi Adalsteinsson bessi@lexis.hi.is Institute of Lexicography Tel.: 525 4438 Neshaga 16 Fax: 562 7242 107 Reykjav'k

↪ replying to Bessi Adalsteinsson

Jing Liu — Wed, 21 Jul 1999 21:48:04 -0700 — source: Informix-list mailing list archive (1991-1998)

Hi there, Has anyone used Geodetic DataBlade Module? I can not insert values into GeoLineseg and GeoPoint and so on. The system always told me there is a parse error about geotimerange part. For example, if I use "any" for geotimerange in geolineseg, it inserts ok. However, when I use specified values like "1999-7-21 3:11:23:23533" for geotimerange in geolineseg, it fails. In fact, if I insert that value into some geotimerange field itself, not part of geolineseg, it works ok. I don't know what's the matter. Is there anyone who can give me a correct example to insert a value for geolineseg with specified timerange? Thanks a lot! Jing

↪ replying to Jing Liu

Robert Uleman — Tue, 27 Jul 1999 16:31:52 -0700 — source: Informix-list mailing list archive (1991-1998)

Jing, The datetime format is important, and it is governed by the database locale, possibly overridden by the GL_DATETIME environment variable on the client. You don't specify in your mail exactly what input format you were trying to use, but for a database in the standard US English locale with GL_DATETIME not set, you need to use "YYYY-MM-DD HH:MM:SS". Your example would become (with arbitrary values for the non-timerange parts): "GeoPoint((12.45,67.89),any,(1999-07-21 03:11:23.23533))". Note that you need leading zeroes in your month and hour specifications, and that the separator between seconds and the decimal fraction is a dot, not a colon. Note also that the time range is enclosed in parentheses (they are omitted only if a range is equal to the keyword ANY or NULL). This example has a single datetime value (begin = end); an example with a true range would be: "GeoPoint((12.45,67.89),any,(1999-07-21 03:11:23.23533,1999-07-22 13:22:56.12345))" Beware of the fraction: the default format does not include support for the decimal point and fraction, and the precision is lost in processing. If you insert these values into a table (it will let you do that) and then select them, you will get the time ranges back without fractions. To fix this, you can set the GL_DATETIME variable; see the discussion in theGeodetic DataBlade User's Guide: "Setting Date and Time Precision" on pages 2-11 through 2-16. -Robert Jing Liu wrote: > Hi there, > > Has anyone used Geodetic DataBlade Module? I can not insert values into > GeoLineseg and GeoPoint and so on. The system always told me there is a > parse error about geotimerange part. > For example, if I use "any" for geotimerange in geolineseg, it inserts > ok. However, when I use specified values like "1999-7-21 3:11:23:23533" > for geotimerange in geolineseg, it fails. In fact, if I insert that > value into some geotimerange field itself, not part of geolineseg, it > works ok. I don't know what's the matter. > Is there anyone who can give me a correct example to insert a value for > geolineseg with specified timerange? Thanks a lot! > > Jing ------------------------------------------------------------------------ Robert Uleman uleman@informix.com Manager, Geospatial DataBlade Engineering Informix Software, Inc. (510) 628-3971 voice 300 Lakeside Drive, Suite 2700 (510) 628-3880 fax Oakland, CA 94612 http://www.informix.com ------------------------------------------------------------------------