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
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?
Who is online
Users browsing this forum: [Ccbot] and 0 guests