Re: Ayuda con el scrip de coneccion por ODBC vs progress

2014-04-22 2:37 GMT+09:00 Claudia Rocio Diaz Toro <cdiazto(at)gmail(dot)com>:

>
> Ref: Ayuda con el scrip de coneccion por ODBC vs progress
>
>
> lo hago como se conecta excel y no lo realia que puedo tener mal
>
> ADO-CONNEC =
> "DSN=PostgreSQL35W;DATABASE=scclog;SERVER=localhost;PORT=5432;UID=postgres;;
> SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;
> RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;
> Socket=4096;UnknownSizes=0;MaxVarcharSize=255;
> MaxLongVarcharSize=8190;Debug=0;CommLog=0;Optimizer=0;Ksqo=1;
>
> UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;
> Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;
> UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;
> ByteaAsLongVarBinary=0;UseServerSidePrepare=1;
> LowerCaseIdentifier=0;GssAuthUseGSS=0;XaOpt=1".
>
>
> ObjConnection:OPEN(ADO-CONNEC, ADO-USERID, ADO-PASSWD, 0) NO-ERROR.
>
pgsql-odbc is an English-speaking list, so you should perhaps send such
messages to the Spanish lists like pgsql-es-ayuda or something like that.

Then, using some basing knowledge of Spanish, I am guessing that you are
trying to connect to a server using the connection string above through ADO
but it doesn't work. The string used seems to be fine for the Postgres ODBC
driver, however without more details it is going to be complicated to guess
what is wrong in your connection script.
Regards,
--
Michael