Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to PostgreSQL
Message
 
 
À
23/02/2012 11:26:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01536288
Message ID:
01536290
Vues:
52
Wrong function, SQLSTRINGCONNECT should be used
m.nConn = SQLSTRINGCONNECT(m.lcConnectionstring)
>I am able to manually create an ODBC DSN and test it successfully.
>
>I am also able to create a new connection in my VFP project and that displays the "connection successful" message.
>
>However, if I try this:
>
>TEXT TO m.lcConnectionString NOSHOW TEXTMERGE
>DRIVER={PostgreSQL ODBC Driver(ANSI)};
>DATABASE=Pawnshop;
>SERVER=localhost;
>PORT=5432;
>UID=Pawnshop;
>PWD=******;
>CA=d;
>A6=;
>A7=100;
>A8=4096;
>B0=255;
>B1=8190;
>BI=0;
>C2=dd_;
>CX=1c502bb;
>A1=7.4
>ENDTEXT
>m.nConn = SQLCONNECT(m.lcConnectionstring)
>
>
>Which is an exact copy of the connection string from the connection in my project (except of course I've starred out the password just for posting here).
>
>I get this error:
>
>[Microsoft][ODBC Driver Manager] Data source name too long
>
>My Googling hasn't helped. Any ideas what I'm doing wrong?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform