XProfan

under [...]  is a example, How one SQL with the ListView under Profan using.

Hello

I have the network a Apache-Webserver with of/ one MySql data base walk and would like me with Profan 7.5 with the data base contact for a Adress Program To write. can me there someone with Examples helpful his.

with friendly greet

Tilo Mayer

WIN XP, Profan 7.5

Hello Tilo,
the goes on the simplest viy ODBC. The there as Setup on MYSQL.de or.
MYSQL.com.

The Verbindungsaufbau must about so looks:

link to DB produce
y%=@sqlinit(DSN=MYSQL;UID=User;PW= Passwort;DATABASE=Datenbankname)
if Y% = 0
print can No link to DB produce,DATE$(0),time$(0)
EndIF

hope the helps you moreover.

Greeting Axel

Hello Axel

thanks for your speedy response

I have the Setup of Mysql.com launched. it opens itself one mask Connector/ODBC there have I any data registered and the link tested and a Verbindiung get. whom DSN Eintag have I MYSQL called, I get with SQLinit no link there.

I knows not what there noc wrong make ??

Greeting

Tilo

Moin,

y%=@sqlinit(DSN=MYSQL;UID=User;PWD=Passwort;DATABASE=Datenbanknam e)

at that Password is not PW separate PWD

so ought to it weg.

Greeting Matthias

Profan2MySQL [...]  User: profane / Pw: profane

Hello Tilo,
with Progs with ODBC/SQL set I at develop and testing whom
@Set(ErrorLevel, n) on 1.
then go with ODBC-Fehlern these too outputted. the ought to
too with Profan 7.5 functions.

mfg Axel

Hello

i want me for Answer thank.

Matthias : I have PRFellow installs

could unfortunately not sooner Answer.

I have whom Error found I have time whom ODBC driver 2.5 taken and already has it worked, lying probably on the new driver.

Tilo Mayer

Moin,

by me functions the MySQL ODBC driver 3.51.06 fine too with Profan. (under XP SP2 and WIN2000 SP4)

Greeting Matthias