Connecting To Mysql

[SupportTeam]

Bhagirath wrote:

 

I am using VoiceGuide, Version 4.8.45 and I am still having problems.

Please help. I have tried to read and re-read the online help.

If you know the solution then please give an example.

 

Thanks in advance (bhtgui@yahoo.com in US)

 

 

I am on Windows XP,

trying to use MySQL and have downloaded and installed MyODBC

 

My database is---> C:\mysql\data\ivrbtv1_db

 

In the ODBC Data Source Administrator dialog I have set the following

in the User Data Sources table

Name Driver

---------------------------------

ivrbtv1_db MySQL

 

 

Selecting Configure... on the above selected entry I get a dialog titled "TDX mysql Driver default configuration" and the settings in its are as follows:

 

Windows DSN name: ivrbtv1_db

MySQL host (name of IP): localhost

MySQL database name: C:\mysql\data\ivrbtv1_db

User: bhtgui

Password: *****

Port (if not 3306):

SQL command on connect:

 

 

 

In the Interactive Voice Guide script I have set the following in the Query dtabase dialog:

 

Database or ODBC Data Source:

ivrbtv1_db

 

Connect String: ( I have tried several combinations but none worked)

MYODBC

MYODBC;user=bhtgui;password=real password

MYODBC;database=C:\mysql\data\ivrbtv1_db;user=bhtgui;password=real password

 

 

 

Thanks

[SupportTeam]

Best to consult the online manual for MySQL ODBC. It can be found at:

 

http://www.mysql.com/products/myodbc/manual_toc.html

 

One of the connect strings used in demonstrations in that manual:

 

DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;UID=venu;PWD=venu;OPTION=35

 

but I suggest consulting the manual to find the correct connection string for your system.

 

Note: The name of the DRIVER used must match the name of the drivers that is being used on your system - this can usually be found in your "ODBC Data Source Administrator"

 

Related post:

 

http://katalinatech.com/forums/index.php?a...act=ST&f=2&t=16

[SupportTeam]

Bhagirath wrote:

 

After putting all the hints together I finally managed to put the connecting string together.

 

The solution is: (for using MySQL, MyODBC Version 02.50.38)

 

ODBC;DRIVER={MySQL};server=localhost;database=dbName;user=userName;password=user

assword;port=3306;