Обсуждение: Ayuda con el scrip de coneccion por ODBC vs progress

Поиск
Список
Период
Сортировка

Ayuda con el scrip de coneccion por ODBC vs progress

От
Claudia Rocio Diaz Toro
Дата:

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

От
Michael Paquier
Дата:



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