Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting up Postgre ODBC?
Message
 
À
27/03/2003 18:56:39
Liam O'Hagan
O'Hagan Programming Ltd
Irlande
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00770795
Message ID:
00771119
Vues:
15
>Hi Michael,
>
>Can you be a bit more specific about the trouble you're having?

Yes - when I use the following connection string in the connection designer in VFP7:
DATABASE=webconnect;SERVER=192.168.1.11; port=5432;UID=mbh;pwd=;provider=MSDASQLR;DRIVER=postgreSQL;
I get the error: "Connectivity Error: Could not connect to the server; Could not connect to remote socket."

Similarly, when I try to create a File DSN using the MS ODBC Administrator that launches the driver, I get the error "General error: Invalid file DSN"

I can ping the Linux box (In fact, I have Samab sharing a Linux directory)

>The only trouble I've ever had is trying to create remote views with the View Designer, but as I generally create my views in code this isn't a problem for me. In all other respects PostgreSQL has always worked perfectly.
>
>Regards,
>
>Liam
>
>
>
>>I have PostgreSQL set up on a new Linux box, configured to allow all network connections (for now).
>>
>>I have downloaded the ODBC driver and installed in on my Win2K box by going through the install routine, but I'm having trouble configuring it within the GUI.
>>
>>Is there a manual configuration step I've missed?
>>
>>... or perhaps some magical settings under the 'driver' or 'datasource' buttons in 'Advanced Options'?
>>
>>TIA
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform