Postgres Pro
Downloads
Home   >   mailing lists

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

Ayuda con el scrip de coneccion por ODBC vs progress

From
Claudia Rocio Diaz Toro
Date:

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.
 
 
Atentamente
 
 
Claudia Rocio Diaz Toro
Movistar  Ec 083421164
Movistar Col 3176800188

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

From
Michael Paquier
Date:



2014-04-22 2:37 GMT+09:00 Claudia Rocio Diaz Toro <cdiazto@gmail.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