XProfan

BDE_Verwaltung2.jpg Preview

33 kB

Hochgeladen:

01/11/09

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

01/11/09 ▲

RGH

Hello Dietmar,
User and password must XP in the Init with indicated go. whom dialog to input of password and User there XP evident not any more. (is me already negative noticed.)
so ought to it weg:
Compile Mark Separation

VAR sql& = @SQLInit(DSN=Firebird;UID=Username;PWD=Passwort;DATABASE=Datenbankname)

whether in Your drop DATABASE used becomes, white I do not, I me with Firebird not yet befaßt have.

Greeting Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

01/11/09 ▲

Dietmar
Horn

thanks, Roland,

i'll the naturally try (I faith however, that I these Variante in between already -zig time ergebnislos tested having).

I had anyhow vermutet, that here in the Community not allzuviele SQL-Profis on the way are.

On any Cases I will the proposition (hopefully with further allude from ours XProfan-Community) in 1 - 2 - 3 weeks somehow running catch.

i'll first time another couple PMs, z.B. one (of my former) XPRF-Schülers to wait it out, because z.B. Thomas Z. (meanwhile case-Informatiker for Irgendwas-DingsBums) has me with its SQL-Kenntnissen already now something integrally beautiful weitergeholfen.

certainly is the again only one klitzekleines SQL-Problemchen, which not yet To in my small stupid-Hörnchen-Hirn vorgedrungen is ...

further Notes and Hilfestellungen To my actually SQL-trouble are naturally Welcome.

Greeting and thanks beforehand
Dietmar

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

01/11/09 ▲

Dietmar
Horn

Hi,

SQLInit me supply now finally lever back, after I In the Control Panel under management -> Datenquellen (ODBC) a available demonstration-data base namens Employee.fdb registered have.
Compile Mark Separation

var DB1& = SQLINIT(DSN=Firebird;)
messagebox(str$(DB1&),,4160)e>

with
Compile Mark Separation

VAR DB1& = @SQLInit(DSN=Firebird;UID=Username;PWD=Passwort;DATABASE=Employee)

runs by me yet yet quite nothing. I can means always only with of/ one only vorhandenen data base works, or must I for each available data base a new Sign in the Systemsteuerung lay out? the would Yes terrible!

with
Compile Mark Separation

SQLExec SELECT * FROM Employee,0
SQLExec SELECT * FROM Employee,1e>

wished I me now whom Tabelleninhalt Show let. but only always Messagebox ODBC-Error with some kryptischen characters afterwards (but always the same komischen characters, alike I with SQLEXEC eintrage).

the lay out of/ one new scheduler with CREATE TABLE works yet genausowenig.

The next steps wären then the Reading einzelner boxes and the add / Change of Datensätzen.

Roland, know You over again council, or anyone else?

If I there through be, then be I certainly ripe for Klappse. so, How me this Firebird-SQL-Zeugs now already geschafft has, would the still not time my XProfan-Kursteilnehmer create - neither with 16 hours course on the day on 7 Meet in the week.

but somehow must I the into next weeks hinkriegen, alike How.

I have times the demonstration-Database and The ODBC-Error Message with appended.

Greeting
Dietmar

EMPLOYEE.ZIP

90 kB

Hochgeladen:

01/12/09

odbc_fehler.jpg Preview

8 kB

Hochgeladen:

01/12/09

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

RGH

Hello Dietmar,
even if SQL created watts, circa as many as possible Databases uniform abzufragen, there unfortunately then still oftmals swell and small differences.
myself have XProfans SQL-skills bislang free from problems with dBase-Files (pub), MySQL (pub and removes), ZIM (pub and removes) and Oracle (removes) inserted. removes means, that The Datenbak on one Server in the companies-networking or quite over TCP/IP on one computer in a others network was.
with Firebird have I bislang yet nothing To do had. circa you moreover To help should I FireBird yourself install.
which FireBird-Version using You?
Can it pub install and then too pub hereon grab? (on the web page standing of what Classic installation and SuperServer. which have You using?

Greeting
Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

Dietmar
Horn

Hello Roland,

I have The Version Firebird 2.1.1.17910 installs - Superserver (means any standard-tick in the Setup-Program so let) and it as service launched.

one can Firebird naturally pub install and then too pub hereon grab.

I faith, moreover need one too yet whom ODBC-driver, I slopes it time with on (I had to it anyway by me first yet install).

my Program should possible not The Kommandozeilen-Tools of Firebird benefit, separate everything by SQL of XProfan from.

Greeting
Dietmar

SetupOdbcJdbc.zip	493 kB

Hochgeladen:	01/12/09

Downloadcounter:
		Download

Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]

Windows 95 bis Windows 7
Profan² 6.6 bis XProfan X2 mit XPSE

Das große XProfan-Lehrbuch: [...]

E.T.

i'm Yes the opinion, the one these API benefit ought to

:

Firebird-guide

The Firebird client library provides on Application Programming interface (API) with functions for connecting to servers and working with databases. The library functions communicate with the server(s) using a dedicated Firebird client/server protocol that sits on top of the general network protocol provided by the OS.

All client applications and middleware must use the API in some way to access Firebird databases.The Firebird API is backwardly compatible with the InterBase API. The InterBase API Guide (available at [...]

contains extensive documentation on the use the API in applications. Additional features available in the Firebird API are documented in the Firebird release notes.

Client filenames
The Firebird client library files are fbclient.dll (windows), libfbclient.so (Linux network client) and libfbembed.so (Linux local client with embedded engine, Classic only). In order hardship to break certain existing applications, a copy of fbclient.dll with the old name gds32.dll can be installed on windows machines. On Linux, legacy libgds* symlinks are installed automatically.

one belehre me one better...

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...

RGH

Hi,
installs have I The story and the SQLInit works too lovely.
to that further Vorgehen another question. The supra attached Testdatenbank from you is EMPLOYEE. How is The scheduler or. hot The tables, The in this data base are?

Greeting
Roland
(power but first tommorrow moreover. good night!)

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

E.T.

RGH

...The supra attached Testdatenbank from you is EMPLOYEE. How is The scheduler or. hot The tables, The in this data base are?...

EMPLOYEE.FDB
under Firebird is everything !!! in of/ one data base, the can data, Videos, Images or anything else his...

there becomes everything in a db (u.u. with Giga-Size)gepackt, therefore my Info moreover supra, The API To benefit. Normales SQL becomes there, think I, not far come, there Yes The .fdb of someone auseinandergenommen go must.

P.s. : I red not only schlau, I seat self too drann, the Dingens to that walk To 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...

RGH

Hello and good tommorrow!

now, i think time, if it a ODBC-interface gives, becomes one on The data over these somehow grab can. I go though still of it from, that The data in a rDatenbank in anybody point in tables organisiert are, as with others Databases, with exception of Clipper/dBase and Konsorten*, normally is. or lie I here wrong.
and a data base contains a or several tables. and these include a or several Datensätze, The widerum one or several boxes include.
(whether The whole data base now as here physical in a File lying, or How about with mySQL or ZIM on several distributed is, ought to for grabbed no role play.)

Greeting
Roland

* Since there it really only single tables. under ODBC go The tables, The in the equal directory lying, as data base viewing.

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

RGH

appendix:

Please not data base with scheduler confuse! an dbf-File is z.B. a scheduler and no data base, not more than part of/ one data base.

EMPLOYEE.FDB is the data base. These contains tables. and How I with the very lovely Tool IBView now found out have, are it following tables: COUNTRY, CUSTOMER, DEPARTMENT, EMPLOYEE, EMPLOYEE_PROJECT, JOB, PROJECT, PROJ_DEPT_BUDGET, SALARY_HISTORY and SALES. and naturally The Systemtabelle, The any Info over tables, Indices, etc. contains: RDB$RELATIONS.

unfortunately I get bislang each attempt on these access, The of Dietmar beschriebene Error Message. The Access to The data base yourself succeed by me free from problems with folgendem SQLInit-Statement:
Compile Mark Separation

var sql& = sqlinit(DSN=Employee;DBNAME=D:\Dokumente\FireBird\EMPLOYEE.FDB;)

or without Passworteingabe with:
Compile Mark Separation

var sql& = sqlinit(DSN=Employee;UID=SYSDBA;PWD=masterkey;DBNAME=D:\Dokumente\FireBird\EMPLOYEE.FDB;)

one ahnt it already: by me lying The EMPLOYEEE.FDB on D

okumenteFireBird.

Greeting
Roland

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4

RGH

BEI MIR GEHT ES JETZT!

what have I made? not The veralteteten ODBC-driver from Your (Dietmars) Posting uses, separate here the latest stabile Release gotten: [...]

(whom obersten entry, Version 1.2 Full Install)

The following Program functions now correct:
Compile Mark Separation

cls
var sql& = sqlinit(DSN=Employee;UID=SYSDBA;PWD=masterkey;DBNAME=D:\Dokumente\FireBird\EMPLOYEE.FDB;)
print sql&
ClearList
sqlExec select * from EMPLOYEE,1
listbox$(EMPLOYEE:,2)
ClearList
sqlExec select * from CUSTOMER,1
listbox$(CUSTOMER:,2)
odbc1.jpg   38 kB
Kurzbeschreibung:  Konfiguration
Hochgeladen: 01/13/09
Downloadcounter:  
Download
odbc0.jpg   57 kB
Kurzbeschreibung:  Systemsteuerung/management/Datenquellen ODBC
Hochgeladen: 01/13/09
Downloadcounter:  
Download

Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4