General information
Category:
ActiveX controls in VFP
Title:
DSN-less connection from VFP6 to Informix under UNIX
Hello there,
Once here, I was trying to get answer on similar query but with small success. Near my back is one old SCO UNIX server with Informix database. He is out of normal daily using, but sometime we need an reports and data. In most cases, I can get all data using build-in tool "dbaccess" and fistfull of prepared SQL queries but, so received data are in raw format and uggly for presentation. One of good solutions was connection over ODBC (Informix-CLI 2.5 32 bit and Informix 3.33 32 bit) and this working fine using VFP for short time. Some changes was done on this server and connection node on server side for this type of connection has been removed. As I have still all neccessary information about data server (IP address, hostname, name of database, root and database adiminstrator privilegions...) I'm interested to know is possible using on such server so called DSN-less connection from VFP6 to this server without installed OLE DB side on server. Every day I trying to make this using this syntax and different variations (I don't know what is SERV=1984):
*
conn.Provider = "MSDASQL.1"
conn.ConnectionString = "UID=admin;PWD=summer96;DB=billing;"
conn.ConnectionString =conn.ConnectionString +"HOST=193.0.0.6;SRVR=old_server;SERV=1984;"
conn.ConnectionString =conn.ConnectionString +"PRO=olsoctcp;Driver={INFORMIX 3.33 32 BIT};DSN='';"
but without result, still an error in connections string.
Anybody has solution !? Thanks in advance.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only