XProfan

English

Jochen
Wicklein

Hi,
i want with Profan over ODBC on MySQL grab.
These Variante succeed me unfortunately not. well but the Access to Access and dBase via ODBC, so that i think, that I the grundsätzliche Vorgehen understood have.
On The MySql-data base can I too of Access from grab, therefore is the driver too correctly installs.
what me for Profan missing, is evident The korrekte Syntax for SQLINIT.
I use whom driver MyODBC 3.51.
How must in this Konstellation the Initialisierungsstring looks?
About a Tipp would I very grateful.

with friendly greet
J. Wicklein

05/23/05 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Matthias
Griesbach

Moin,

first thing ought to In the Control Panel/management/ODBC
or with Perform: odbcad32.exe
one system-DSN entry prepares go. Z.B. MySQL

indicated for Host, User, values), Database prompt.

the tick with :
Dont optimize column width
ought to staid his, the remainder not.

The Profan-row sounds then:

@SQLINIT(DSN=MySQL;UID=root;PWD=root;DATABASE=database)

One @SQLINIT(DSN=MySQL) ought to too functions,
but sure is sure.

Greeting Matthias

Profan2MySQL [...]