Received: from tribuno.virtualcom.es (tribuno.virtualcom.es [195.76.109.1]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA94025 for ; Wed, 6 Oct 1999 02:25:00 -0400 (EDT) (envelope-from SADACIA@santandersupernet.com) Received: from santandersupernet.com by tribuno.virtualcom.es (8.8.6/SMI-SVR4) id IAA02107; Wed, 6 Oct 1999 08:22:32 +0100 (WET DST) Message-ID: <37FAE9C3.D6400BA1@santandersupernet.com> Date: Wed, 06 Oct 1999 08:18:43 +0200 From: "J. Carlos Muro" X-Mailer: Mozilla 4.5 [es] (Win95; I) X-Accept-Language: es MIME-Version: 1.0 To: PostgreSQL Interfaces Mailing List Subject: Questions connecting to PostgreSQL. Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit This is my first message to the list so hello everybody !! I want to develop a database application with Borland C++ Builder. I want to access a PostgreSQL sited in a remote Linux, and I have many general questions to solve before starting: 1.- ¿What ways can I use to connect to the database? (ODBC ...¿?) I would like not using ODBC because it is too slow. I have heard about sockets connections. Ideas? Doc available? 2.- I want to transmit data in encrypted way. Is it true that ODBC doesn't send data encryted? Is there a kwown solution for it? 3.- I have asked many other people about using the socket way (I like it the most, 'cause it is the fastest way for communications, and I could encrypt data). But these people said to me that I must do the next: * Implemment a UNIX daemon listening for the data arriving in the database machine. * Immplement an application to pick the data up from this daemon and sending it to PostgreSQL. * In the Window$ side, two ways: - Develop a DLL in an application server way, implementing my own 'ODBC', that prepares data for my data controls from the VCL (Borland C++ Builder controls), ie. DBList, DBText, etc ... - Develop my own classes based on VCL components, implemmentin its own methods for data manipulating, ie. MyDBList, MyDBText, etc ... The question is: Is it true? Am I messing too much :D ? 4.- I have heard about the libpq++ classes. But, are them only for Linux, or can I use them from the Borland C++ Builder? 5.- Turning back to the question 1 (and considering the other questions), is there anything that solves what I am looking for? I suppose that I am not the first person that looks for it, so perhaps all this is already done. What am I overlooking? I would be thankfull for your help or any reference to documentation that tells this. I am really confused since I have not even configured PostgreSQL yet in my Linux. I had never installed it, so I have a long way to run :D Thanks: Juan Carlos Muro The Gseq Team