Ado.net Postgresql Connection

[invoso.com]

I have no experience in ADO.NET so I install vg7 and have problems with connection to database.

In vg6 I used connection string:

 

ODBC; Server=192.168.0.120;Database=manager5;UID=postgres;PWD=password;

 

How to change this connection string for VG7?

[SupportTeam]

Looks like you are using Postgre SQL.

 

Probably best to use a Postgre ADO.NET provider instead of connecting via ODBC.

 

The connection string would depend on the provider used

 

Please see: http://www.connectionstrings.com/postgre-sql or read the documentation that comes with the provider that you install.

 

If you still want to use ODBC then probably best to setup a data source using the Windows' ODBC Data Source administrator, and then the connection string from VoiceGuide's Database Query module would be:

 

ODBC;DSN=dsnname

 

where dsnname is the database source name.

[invoso.com]

I don't understand how to make it.

 

from file: 0110_2020_vgEngine.txt

 

202159.914 6 2 1 rv replace start [sELECT id_proj, status FROM projekty WHERE id_infolinii=(SELECT id FROM infolinie WHERE ddi='$RV[called_number]')]

202159.914 6 2 1 rv replace end [sELECT id_proj, status FROM projekty WHERE id_infolinii=(SELECT id FROM infolinie WHERE ddi='878')]

202159.914 6 2 1 db strDatabaseName=[manager_vg] strDbConnectString=[ODBC; Server=192.168.0.120;DSN=manager5;UID=postgres;PWD=password;] sAdoNetFactoriesAvailable=[|System.Data.Odbc|System.Data.OleDb|System.Data.OracleClient|System.Data.SqlClient|VistaDB.NET20|System.Data.SQLite|]

202159.914 6 2 1 db using ado.net ODBC data provider : OdbcConnection/OdbcCommand/etc

202159.914 6 2 1 t timer set 30 sec : EV_TIMEOUT_HANGUP

202159.914 6 2 1 db odbc RunQuery_Odbc [id_proj], db=[manager_vg], connect=[ Server=192.168.0.120;DSN=manager5;UID=postgres;PWD=password;], sql=[sELECT id_proj, status FROM projekty WHERE id_infolinii=(SELECT id FROM infolinie WHERE ddi='878')]

202159.914 6 2 1 odbc OdbcConnectString modified to be include DBQ parameter: Server=192.168.0.120;DSN=manager5;UID=postgres;PWD=password;;DBQ=manager_vg;

202159.914 6 2 1 odbc to use a DSN-less connection do not specify the ODBC Data Source.

202159.914 6 2 1 db odbc thread init (threadpool)

202159.914 6 2 1 db odbc thread started (threadpool)

202159.914 14 2 1 db odbc connection create call.

202159.914 14 2 1 db odbc connection open call.

202159.929 14 2 1 ERROR v7.2.3994.39528 (2010-12-08 21:57:37.35) ConnectAndRun_Odbc init : ERROR [iM002] [Microsoft][Meneder sterownikw ODBC] Nie mona odnale nazwy rda danych, a nie ma podanego sterownika domylnego

 

 

Can You write how should to look right connection string?

[invoso.com]

I found:

ODBC; Driver=PostgreSQL Unicode; Server=192.168.0.120;Database=manager5;UID=postgres;PWD=password;

[SupportTeam]

OK, thanks for letting us know that you have found the right connect string.