Re: Very basic question from a beginner

On 04/08/2012 07:03 AM, Jean MAURICE wrote:
> HI,
>
> I am very new to PostGreSql and ODBC but an 'expert' in Visual Foxpro. I
> wanted to try VFP as a client of PostGres. My laptop is under W7-64. I
> 'installed' the ODBC driver via Stack Builder. All things seemed to work
> well but nothing appears in th ODBC Sources Manager (I apologize I must
> guess the english names from the french ones ...).
>
> What have I missed ?

In my experience the ODBC driver is found under the Drivers tab in the 
ODBC Data Source Administrator. To make it available you create a DSN 
under either the User DSN or System DSN tab, where the data source is 
available either to the user that created it or to the system, 
respectively. This assumes you have the appropriate user privileges. The 
DSN creation process allows you to choose the correct driver from those 
listed in the Drivers tab.

>
> Thanks in advance.
> Best regards
> The Foxil
>

-- 
Adrian Klaver
adrian.klaver <at> gmail.com

--

-- 

Re: Very basic question from a beginner

Am 08.04.2012 16:03, schrieb Jean MAURICE:
>
> I am very new to PostGreSql and ODBC but an 'expert' in Visual Foxpro. 
> I wanted to try VFP as a client of PostGres. My laptop is under W7-64. 
> I 'installed' the ODBC driver via Stack Builder. All things seemed to 
> work well but nothing appears in th ODBC Sources Manager (I apologize 
> I must guess the english names from the french ones ...).
>
> What have I missed ?

As Adrian explained you would see defined Datasources (DSN) in the 
Source Manager.
In such a DSN is all the information needed to reach a database.
So you create a DSN "my data" and describe there what driver to use, 
host-address, db-name, user, password ...

Later in VFP you should be able to select one of the defined DSNs and 
VFP knows all neccesary details.

BTW there are 3 types of DSN.
File based ... there is a textfile somewhere that holds the informations.
System DSN ... the admin defines a DSN that all users of the system can 
access.
User DSN ... the user defines a DSN that only he himself can access.

Probaply you might be interested to figure out how you can access the 
db-host without a pre defined DSN.
You can stuff all the details into a connection string and use this 
instead of a DSN.
Basically that should be the same as what the DSN-Manager is doing for you.

Re: Very basic question from a beginner