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

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Can I change ODBC Data Source Configon the fly? *Got it*
Posted: Sat Sep 02, 2017 03:07 AM

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.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: Can I change ODBC Data Source Configuration on the fly?
Posted: Sat Sep 02, 2017 03:43 AM

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.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: Can I change ODBC Data Source Configon the fly? *Got it*
Posted: Mon Sep 04, 2017 07:03 AM

I Use

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

Maurizio

www.nipeservice.com

Maurizio
www.nipeservice.com

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: Can I change ODBC Data Source Configon the fly? *Got it*
Posted: Mon Sep 04, 2017 09:39 AM

Maurizio wrote: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?

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: Can I change ODBC Data Source Configon the fly? *Got it*
Posted: Mon Sep 04, 2017 12:49 PM

look at

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

Maurizio

&&&

Maurizio
www.nipeservice.com

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: Can I change ODBC Data Source Configon the fly? *Got it*
Posted: Mon Sep 04, 2017 01:16 PM

Thanks once again, Maurizio

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: Can I change ODBC Data Source Configon the fly? *Got it*
Posted: Mon Sep 04, 2017 02:45 PM

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

Maurizio
www.nipeservice.com

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: Can I change ODBC Data Source Configon the fly? *Got it*
Posted: Tue Sep 05, 2017 12:50 AM

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

Maurizio wrote: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

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

FiveTech Support Forums

Continue the discussion