Can I change ODBC Data Source Configon the fly? *Got it*

[dutch]

Dear All,

I use Crystal Report with MySql. Can I change MySql/ODBC Data source configuration such as below by our program?
- Data Source Name
- TCP/IP Address
- User
- Password

Thanks in advance.

[dutch]

I found page to update MySql ODBC by programming.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-rdo.html
How to do with FWH?

Thanks in advance.

[Maurizio]

I Use

oDSN := TDSN():Create( cODBC, "mastroODBC",cDbName ,cServer, cUser,1, 'C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3.dll', val(nPort), cPassword )

Maurizio
www.nipeservice.com

[dutch]

I Use

oDSN := TDSN():Create( cODBC, "mastroODBC",cDbName ,cServer, cUser,1, 'C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3.dll', val(nPort), cPassword )

Maurizio
http://www.nipeservice.com

Thank you so much, Maurizio. It's the one that I need. Where is TDSN Class?

[Maurizio]

look at

viewtopic.php?f=6&t=18619&p=97790&hilit=create+odbc#p97790

Maurizio

[dutch]

Thanks once again, Maurizio

[Maurizio]

Hello Dutch ,
what version of crystal report do you use ?
I use 8.5 and I have no problem creating the setup for customers .
I would like to use s 10 but I can't create the setup

Maurizio

[dutch]

Dear Maurizio,

I use CR XI R6 SP6 (11.5). Please check this site for runtime setup.
http://www.vdf-guidance.com/ContribPage.asp?Page=HOWTOPRNTCRXIRTI&ContribRecId=109

Hello Dutch ,
what version of crystal report do you use ?
I use 8.5 and I have no problem creating the setup for customers .
I would like to use s 10 but I can't create the setup

Maurizio