XProfan

- Page 1 -

E.T.

Dietmar

would be it there not less umständlich, if you you your fat USB-Stick into Hosentasche stick or around the neck hang and mitnimmst, or the on the way benötigte stuff To dwell already on The HD the Laptops copy?

Yes already, only Have I
a) the Notebook not always with
b) my Stick for on the way mostly already fully
c) can I so of each Browser from grab, if I no FTP have
d) be Betriebssystem-independent, You points Yes self, what with one 8GB-Stick under WIN
small XP so everything happens (or even neither)
e) I can me of home (almost) anytime data recharge let
f) my Router langweilt not and the Stick has too its Daseins-Legitimacy

integrally To silence, the my son the too uses, there it in the teach none USB-Stick infect can (must) and so its data nevertheless into school and inverse get...

Grüße aus Sachsen... Mario
WinXP, Win7 (64 Bit),Win8(.1),Win10, Win 11, Profan 6 - X4, XPSE, und 'nen schwarzes, blinkendes Dingens, wo ich das alles reinschütte...

01/12/09 ▲

KHR

Hello together

.

thanks already times for The Answer. only circa it deutlicher To make. The Server home in the own networking is and should not from the outside zugänglich his. i will hereon only my try with SQL the network make. for so what shining me MySQL in the momentum on the sinnvollsten?????

.

whom SQL course of RGH Have I already since 2 Meet through, rumgespielt Have so did i already well then goes it with the ask first correctly. go:

5) I work presently over ODBC with dbase. somewhere Have I red, that the NDX-Files earlier not very tenable foreseen get and it over ands over again Problems with one fehlerhaften index given. therefore should these with of/ one Reorganisation over ands over again new prepares go.

How is the now with the Use over SQL? mandatory I the self into hand take? power the ODBC? mandatory I me over The quality and Stabilätät of INdex-Files care make?

6) what happens, if I withal ODBC on The DBF directly access and what change. (No I mean not later for a finished Applikation - I mean now in the Lern- and Testphase) mandatory I then too around the aktualiierung the NDXe concern or Done the ODBC with the next Start of SQL

7 ) can I by SQLEXEC inquire, whether a scheduler or one INdex existing or should I simply new lay out and Error intercepting?

8 ) tactic-question: If I in a dbase-File with several 10.000 Sätzen flaking wants, spring I of set To set and show whom on. Sql is yes a other principle and it would very umständlich always only a set along or backward reading. remaining means The alternative a) entire scheduler wander and ne Save file and then flaking or b) a part z.B. 100 Sätze To into Memory fetch and then with want recharge. What is there sinvoll. Gibts it a others Vorgehensweise?

hopefully I'm going you with my ask not The nerves - i think, there go yet some come

Gruß
Karl-Heinz
WIN XP home/Pro / XPROFAN 11 / P2CPP
ATMEL + BASCOM Fan

01/12/09 ▲

Sato
Pinto

Hello

I stand to whom equal trouble. have some my programs with dbase Files and greife by sql command
circa into tables what to search or To write. wished not longer dbase Files make circa it safer
To make and the network To benefit, but somehow have I yet no light Solution found, everything what
I to date above red have is To komplex.

greeting
Sato

Sato Pinto
WIN XP Home
XPROFAN 11

01/13/09 ▲

Michael
Wodrich

XAMPP (see first hits with Date)

X (W / L) windows / Linux
A pache (Server)
M ySQL (data base)
P erl (Script Language)
P HP (Script Language)

is even little more drin in this pkg. there it for Linux and Windows available is,
can too well offline with the data works. a Dump (Backup) can with the
encompassed phpMyAdmin very slight create and on the each others system einpflegen.
thereby can the Backup too The entire data base-structure mitspeichern/lay out.

XAMPP self is a Developersystem (sperr-angel-far-open) but To Apache-MySQL-PHP
there pages in the network, a very detailed guide give How to the abstellt.

Best wishes
Michael Wodrich

Programmieren, das spannendste Detektivspiel der Welt.

01/13/09 ▲

Michael
Wodrich

for so what shining me MySQL in the momentum on the sinnvollsten?????

To 5.)
The Reorganisations-orgy is well the reason Why so many of dBase on others (right) Databases change.

circa itself these care To save should You MySQL or PostGres benefit. me personally gefällt MySQL rather. there position one once one which boxes Indexfelder are and then ists well.

To 8.)
SQL can with the amendment NEXT x integrally simply with bites bypass.

look you too time SelfSQL on (is a PDF).

Best wishes
Michael Wodrich

Programmieren, das spannendste Detektivspiel der Welt.

01/13/09 ▲

- Page 2 -

KHR

Hello Michael,

.

thanks for your Notes. so slow becomes the mist something durchscheinender.

.

Hello Sato

but somehow have I yet no light Solution found, everything what
I to date above red have is To komplex.

i think, you are something moreover as i in the Gewirre. in the momentum be I yet guter items, that I with Help the Documentations from the network and of/ one row nerviger ask here ans Forum my lane To and through SQL find can.

found have I SQL in 21 Meet - PDF
SQL - A Practical Introduction.pdf
and the SelfSql - Tipp of Michael

so wurschtele I now to me there and verdrehe The eyes if as response only Error or what Wrong comes ;)

first Have I time ne simple - in XProfan selbstgestrickte - Address (based on Text files) in SQL (ODBC-dBase) umgestrickt. the Result is weder beautiful yet well and functions neither so right - but the was Yes not the target. I Have thereby but recognized, which Problems itself aufzeigen can.

my Erkenntnis:
In dbase or in Text-Files seek You something and erhälst a or several Datensätze. In Sql position You ne question and get Answer everybody can understand, digest and process must. principle: stupid question = stupid response incorrect question = no response

as ungelernter hobby-code-Lines-criminals Have I naturally so well How no Anhnung of Programmiertechniken and Vorgehensweisen for a trouble To solve. means consider I me hold what Have I and what custom I and try a lane to find the weder umständlich yet costly is. These tactics and Strategien are with SQL naturally quite different than what I me yet beigebracht have.

One further trouble is the task everybody can itself position or set get.

is tappt im dunkeln To heavy or To komplex becomes the nix with the selbstlernen
is tappt im dunkeln To simply bringts neither plenty
no task and only rumprobieren bring quite nothing, there one The route on difficult to put simply leave can and where differently again begins To one too there again to The Wand runs.
means best small suitable and übersichtliches proposition - the a really interested(very important) - and dran stay

my Vorgehensweise is

whilenot ready_programm

- try, testing, try, try, testing, try, try, testing, try
- on The Schnauze entrapments
- profane language
- Documentation search
- internet search
- Forum with question nerves
- - - hurrah It's all right still - error located between ears of user

endwhile

i think it'll nobody give, whom one (with hope on ne sinnvolle response) ask can: How are SQL

this is so like Subclass or Subproc or API-functions ....... most here know what this is and ask only to the How. others - as well as I - having not yet time vestanden what this is and what the well his can. means becomes it already very heavy his, The right Question to put. And then are The Answer How: mach the still with subclass More motvationstötend How helpful.

Diejenigen, The The response on your question give could, are often so far over Your Level, that tappt im dunkeln itself none present can, on which plain your trouble lying and How terminable your Vorkenntnisse sid. mostly think The: The is go ahead rotten to that cogitate and wants finished code of me/us.

and daselbe threatening you and me with SQL. ;)

.

Gruß
Karl-Heinz
WIN XP home/Pro / XPROFAN 11 / P2CPP
ATMEL + BASCOM Fan

01/14/09 ▲

KHR

Hello together

so slow becomes SQL for me something durchsichtiger and already building itself in the remoteness new Nebelbänke on.

what I yet made have:

- with xProfan SQL over ODBC with dBase-Files betrieben - has worked.

- first try in the program made - has worked

- ODBCView Version 3 as additional access To SQL instelliert - works lovely.
can now any command already time to that testing directly on SQL Send and get The Answer

- MYSQL Essentials on the notebook installs - has worked

- nothing so make can, because XProfan no link To MYSQL found has

- MYSQL-Admin installs, User laid out, Parameter tuned - XProfan talking still not MYSQL

- ODBC-driver for MYSQL installs - has worked and XProfan talking with MYSQL - lovely

- too ODBCView Version 3 talking with MYSQL - dank ODBC-driver - lovely

and now my actually ask:

was the lane correctly. or there ne others(better) Possibility link between XProfan un MYSQL produce?

If now MYSQL sometime on my Server home installs is, How make I since the link between XProfan and the Server? again over The ODBC-interface?

with us in the firm be allegedly time MYSQL for NEN Test on irgendeinem Server installs been. really ought to the still walk. Have even The Passwörter get. mere how can I MYSQL find?
(The Admin, ders well arranged has is gone, whom new interested not - because no idea)

Yes I know, that I a part the ask in the incorrect Forum place but I hope nevertheless on Your Help.

Gruß
Karl-Heinz
WIN XP home/Pro / XPROFAN 11 / P2CPP
ATMEL + BASCOM Fan

in the Taskmanager the betreffenden computers (strg+old+ under ticket processes you see to alphabetischer Sorting with m whom daemon mysqld-debug (or a ählichen without -debug, z.B. with -prod) walk. alternatively could it too as service launched go - then helps you Systemsteuerung - management - Computerverwaltung (pub) - services and Applications moreover. I use ODBC-driver, be but neither sure whether it not yet what better gives...
Greeting
P. woodpecker

KHR: look time whether You into Settings a HOST indicate can. there koennte now z.B. localhost stand and there koennte then z.B. a target-IP/address indicated go. How You then staendig on The IP the Zielrechners come, is a Unterproblem*.

*) Perhaps. because the Zielrechner its IP staendig self verraet (so I do) or You z.B. a fremdanbieter-dyndns-service uses.

KHR

Hello together

Have whom SQL-Server found. i know of course not, where The box now really standing - but I can with it on MYSQL talk.

The Solution was simply - the draufkommen already plenty schwerer.

I Have with nem Portscanner the whole networking on the Port 3306 durchgekämmt and already has it itself betray!

Gruß
Karl-Heinz
WIN XP home/Pro / XPROFAN 11 / P2CPP
ATMEL + BASCOM Fan

The Port must too from the Walls released go if you of outer grab moechtest.

Michael
Wodrich

I use too whom ODBC-driver of MySQL.
whether the for each Client necessary is white I do not but in the network one reads over ands over again of difficulty at Kontaktieren. always was install the ODBC-driver of MySQL The Solution.

I had ne while Access to a MS-Server 2003 with MySQL-data base. now use I MySQL by XAMPP-pkg daheim and on one 1&1-Vereins-Account. No Problems.

Best wishes
Michael Wodrich

Programmieren, das spannendste Detektivspiel der Welt.

01/18/09 ▲