VoiceGuide IVR Software Main Page
Jump to content

Bd

Recommended Posts

Hi

- I have a DB in SQL, and in "ODBC Data Source Administrator " -> User DSN , I have the name abonados, what name should I put in the module "Database query"-> "Database or ODBC Data Source"??

- how do I use the module "Database query"-> "Connect String"

 

regards

José

Share this post


Link to post

"Database or ODBC Data Source" should contain "abonados"

 

"Connect String" should contain whatever connect string your database recommend that you use in order to successfully make an OBDC connection.

 

If this was an Access database that you connect through ODBC the connect string may be:

 

ODBC;DRIVER={Microsoft Access Driver (*.mdb)}

 

for an Oracle database connect strings look something like this:

 

ODBC;DSN=Production;UID=user;PWD=password;SRVR=t:machine:p66;

 

for a MSSQL database you may use:

 

ODBC;UID=sa;PWD=;

 

It all depends on your configuration of course - if somebody else has set up the database then maybe you should ask them to see what they recommend you use for the connect string.

 

A few other users have commented that they needed to include the DRIVER specification in the connect string before they could connect successfully. The contents of the driver name inside the {} brackets should be a direct copy of what you can see in the ODBC Data Source Administrator's 'driver' column - just to the right of "abonados".

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×