How To Define Database In Ado.net

[invoso.com]

Hi,

 

typically I use ODBC to connect to database.

 

Now I use ADO.NET to test dialer functionality, but I don't know how to use it in Database Query module.

<Dialer>

<OutDialQue_ADODB_Provider>Npgsql</OutDialQue_ADODB_Provider>

<OutDialQue_Database>vgDb</OutDialQue_Database>

<OutDialQue_ConnectString>Server=IP;User Id=user;Password=pass;Database=database;</OutDialQue_ConnectString>

<OutDialQue_SqlPrefix>SELECT</OutDialQue_SqlPrefix>

<OutDialQue_SqlSuffix>LIMIT 1</OutDialQue_SqlSuffix>

<OutDialQue_PortToUse_LinkField></OutDialQue_PortToUse_LinkField>

</Dialer>

 

I use different IP addresses and databases and put it all in $RV[connection_string] so I need to change connection string:

e.g. ODBC; Driver=PostgreSQL Unicode; Server=$RV[server]; Port=5432; Database=$RV[database];UID=user;PWD=pass;

 

How to address ADO.NET like above?

How to fill out database module to reach same result.

 

Can You describe difference between ODBC and ADO.NET? Performance or other?

[SupportTeam]

To connect to PostgreSQL from VoiceGuide's Database Query module you can use the Npgsql ADO.NET Data Provider.

 

(provided here: http://voiceguide.com/forums/index.php?showtopic=9424&view=findpost&p=36136)

 

The Connect String should be something like this:

 

Server=myip;User Id=myuser;Password=mypass;Database=dbname;

 

Would recommend using ADO.NET Provider before trying ODBC.

 

 

 

NB. Setting up ODBC to Postgres is outside scope of this forum. Best to check with PostgreSQL support regarding ODBC.