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?