Vista xampp mysql ctd15

General discussion forum about all databases other than SqlBase.
Jsfmllr
Germany
Posts: 69
Joined: 17 Nov 2019, 16:08
Location: Munich, Bavaria, Germany

Vista xampp mysql ctd15

Post by Jsfmllr » 08 Apr 2011, 20:43

hello,
i have a xampp installed on vista. phpmyadmin provides me all its features: create databases, create table, fill tables, run SELECTs in every way.
the purpsoe of all this is to convert two external databases, from where the data had been exported to CSV-files. these data-sources have to be joined and a new mySql-database has to be filled.
so i intend to code a ctd-application, read the CSV-files, perform some converting and write fill the (xampp-)mySql-tables.
i already have installed the ODBC-datasource. how can i establish a connection from Centura to mySql? AFAIK i have to set some keywords in sql.ini. I cannot find enough information about this.

i hope, anyone can help

thank you in advance
sepp

Jeff Luther

Re: Vista xampp mysql ctd15

Post by Jeff Luther » 11 Apr 2011, 20:16

There's the CCOD manual/ODBC section you can look at for info.

P.S. I don't know if an ODBC connection this will work for MySq way back with CTD v1.5, though...
You do not have the required permissions to view the files attached to this post.

Jsfmllr
Germany
Posts: 69
Joined: 17 Nov 2019, 16:08
Location: Munich, Bavaria, Germany

Re: Vista xampp mysql ctd15

Post by Jsfmllr » 12 Apr 2011, 16:10

Hello Jeff,

thanx for reply ... like before, it showed me the way, that i had to go ...

it works now ... after i realized, that "DSN" stands for "DataSourceName" ...

the next step is to find out, what things i have to set, so that all German SpecialCharacters are handled properly.
I think i have to handle with things like UTF-8 and SqlSetParameter(..) and NLS-characterSet ... the next task for some rainy sundays ...

or can anyone give me new hints?

so long
Sepp

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests