XProfan

English

dbHelper.pcu

These Unit is for >= XProfan 10
Namensräume go supported (z.B: db.) and should uses go!

The Hauptaufgabe this Unit is the create and Remove of/ one DSN
circa OnTheFly by ODBC on Databases grab to, without these
by the user arrange To let.

Desweiteren is it possible a vain Access-data base to create, circa
these moreover To benefit (DSN becomes automatically laid out)

Examples and further functions go follow!

a couple standard-coachman names find itself in the dbHelper.ph

Funktionsbeschreibung: (take db. as Namensraum in the Description)
bracket clinging mark optionale Parameter
Defaultwerte:
User$ =
Password$ =
coachman$ = Microsoft Access coachman (*.mdb)

DSN$ = Db.AddDSN (DataBaseName$, [User$, [Password$, [coachman$]]])
Fügt a DSN-Sign in whom Benutzerdatenquellen one
DSN$ is in the Fehlerfalle one Leerstring, otherwise can this String for further
command the XProfan ODBC-interface uses go!

Result% = db.RemoveDSN(DSN$, [coachman$])
removes DSN-entry from whom Benutzerdatenquellen
Result% is 1 in the erfolgsfalle, otherwise 0

DSN$ = db.CreateMDB(DataBaseName$, [User$, [Password$]])
prepares a vain Acces-Database and fügt a DSN-entry hinzu

PS: The DSN-names go prepares from XPRF + Datenbankname without way and Extension

Feedback, Bugmeldungen etc. erwünscht

If the a or others another couple Examples create would, would very nice

dbHelper.zip	26 kB

Kurzbeschreibung:	Beta 0.6

Hochgeladen:	10/09/06

Downloadcounter:
		Download

09/30/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

- Page 1 -

Michael
Wodrich

Access to Access works, but How I get Access to a MySQL-File?

Programmieren, das spannendste Detektivspiel der Welt.

10/01/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

[quote:817fe34677=Michael Wodrich]Access to Access works, but How I get Access to a MySQL-File?[/quote:817fe34677]
MyODBC must installs his, as address then z.B. whom localhost indicate. (127.0.0.1) and coachman = MySQL ODBC 3.51 coachman
Habs but not yet tested, ought to but weg, if MySQL pub runs

10/01/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Update Beta 0.5

any 3 function having now a additional optionalen Parameter. If this on 1 staid is, becomes the DSN-Sign in whom Systemdatenquellen prepares, or. deleted. there having too others User the Systems grabbed on The DB

PS: who some nice Examples post could, the sustain of me by PM whom Source, the but not relayed go must. means dive in

10/03/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Michael
Wodrich

XAMPP has whom MyODBC well not used. The driver is by me not at all installs, fetch I straight to.

white someone where with XP Home The hosts. and lmhosts. very hingehören so tappt im dunkeln correctly ausgewertet go? I have on my system difficulty with the localhost indicated - The lead constantly in that vain. I help me with 127.0.0.1.

The Templates lying under WindowsSystem32Driveretc
hosts.sam and lmhosts.sam.

Best wishes
Michael Wodrich

Programmieren, das spannendste Detektivspiel der Welt.

10/04/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

After system32/Drivers/etc

only rename, means extension lane

MySQL goes too without ODBC, because one The DLL libmysql.dll directly uses. but for ODBC is MyODBC necessary!

10/04/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Michael
Wodrich

I schaff it simply not. Access-Files no trouble but MySql will not. or have I with *.myd The incorrect File on the roll.

there are *.myd, *.myi, *.frm to selection.
d=datenbank, i=index ?!!

prepares have I The data base How always: with phpMyAdmin - so work I really only. but one Programmzugriff via XProfan would naturally well...

Best wishes
Michael Wodrich

Programmieren, das spannendste Detektivspiel der Welt.

10/04/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

- Page 2 -

Have time MySQL tested, can but not plenty make, Have none Localen Webserver installs

Have the StandardAttribut APServer with MySQL time on localhost staid. somehow are missing me yet Info The right data base anzugeben, it forbid me whom grabbed.

can Yes time a morsel of with the modified PCU play, Perhaps findeste yet suitable Info. I work really longer SQLite3.

to that testing Have I subesquent Source uses:

Compile Mark Separation

 $H dbHelper.ph
 $u dbHelper.pcu = db.
Declare DSN$
cls
DSN$ = db.AddDSN(mysql, ODBC, , ~DRIVER_MYSQL, 1)
Print DSN$
WaitKey
Print db.RemoveDSN(DSN $)
WaitKey

becomes too everything correctly. registered, except for The data base, or. any fehlender rights. before You a Button press simply time into Sytemsteuerung: Datenverwaltung-ODBC / SystemDSN look over.
The Test-PCU in the attachment.
Perhaps kannste me Yes yet whom right hint give

PS: If you everything so there einträgst ought to The data base too functions, solely The Unit kanns for MySQL not yet.

dbHelper_test.zip	23 kB

Kurzbeschreibung:	testversion

Hochgeladen:	10/05/06

Downloadcounter:
		Download

10/05/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Have in Version 0.6 time a *.def added

deference: in the momentum go only The ODBC-driver of M$ supported, means *.mdb, *.xls etc.
On the work I yet, can but nothing promise.

10/09/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

have You, the .def manually machine?

10/09/06 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

[quote:52b3572166=iF]have You, the .def manually machine?[/quote:52b3572166]
No, wieso? is tappt im dunkeln not so How tappt im dunkeln his ought to? white Yes not wozu the well is, be only Your piece of advice followed. only The Unit Have I subsequently again without XPSE prepares, circa 1 KB size To save