Devart Forums

Thomas J.

Sorry, but the problem occurs on the customer machine. Now I changed it to MySQL components and it works.
So I cannot provide you any information right now.

Thanks
Thomas

Thomas J.

UniDac 6.1.3
C++ Builder XE5 Update 2

Thanks
Thomas

Thomas J.

Hello all,

today I installed my application first on a windows system (database and client). Everything worked fine.
Then the admin exported the database to a Linux system. Also here worked everything fine except of executing a TUniStoredProc.
An assertion is thrown without any information. Did someone use also the TUniStoredProc component with database located on a Linux system?
When I execute the statement "Call ProcedureName(-1, -1, -1, -1)" in NaviCat everything works fine.
What could be the problem?

Thanks a lot for your help
Thomas

Thomas J.

Hello support,
I cannot use any component like "Data Access Components for MySQL" or "UniDac".
I have an empty form compile and the appliactions starts.
I put e.g. TMyQuery on the form compile. And the apppliaction stip with an AV.

The XE3 version 17.0.4770.56661 (Update 2)

I'm using also XE with your components without problems.

Thanks for your help
Thomas

Thomas J.

Hello all,

in C++ (VCL) I'm using TMyQuery to process SQL commands and the method ParamByName to access the parameters.
I cannot find the method.
Only the simple index method like

Code: Select all

sqlCommand.Parameters[0].Value = 60;

Thanks
Thomas

Thomas J.

Hello all

I have a join like this (MySQL)

Code: Select all

SELECT a.*, f.n_status
FROM t_auftrag a
     LEFT JOIN t_auftrag_user_flag f ON a.n_id = f.n_auftrag_id

and I want tot change the value of field n_status.
These lines of code are forcing the error "Cannot change field"

Code: Select all

	DsAuftrag8->DataSet->Edit();
	DsAuftrag8->DataSet->FieldByName("n_status")->AsInteger = 8;
	DsAuftrag8->DataSet->Post();

The same with TMyQuery is working. Where ist the problem in TUniQuery?
I will write the value manually to the database in case of that the user has changed the value of n_status, but right now the user is not even able to change the value.
Thanks
Thomas

Thomas J.

Now it is working.

I dont't need a App_Licenses.dll and file licenses.licx has to be only on the development machine and also not on the IIS Server.
And the main problem was that I don't have copied the NEWEST .dll from VS2010 project to the IIS Server.

So I add the "Devart.Data.MySql.MySqlConnection, Devart.Data.MySql" to the licenses.licx file compiled the project and copied the new .dll to the IIS server.
The project is an ASP.NET Web Application.

Thomas J.

Hello all,

some addtional information
In "License Information..." is written
"License is not needed. The library does not have reference to Devart.Data.MySql."

And here http://www.devart.com/dotconnect/mysql/ ... nsing.html
is written, that "License is automatically added to project when you drop a MySqlConnection component ..." I don't have this component, but I'm using the "MySqlDataSource"

Thanks for your help
Thomas

Thomas J.

Hello

I have read a lot of threads regariding this issue, but without success.
This is my first contact with VS2010, .NET and IIS.
All test products including yours.

I'm using .Net 4 on IIS.
The Web application is running fine in VS2010.
But if I copy the directory and the dll
- Devart.Data.MySql.Web.dll
- Devart.Data.MySql.dll
- Devart.Data.dll
I have also copied the file licenses.licx in the wwwroot, in application and sub directory. I still get the erroro regarding Licensing.

I don't have the App_Licenses.dll

What did I missed?

Thanks
Thomas

Thomas J.

Hello all,
I do my first steps in ASP.NET.
I have a WebForm in VS2010 with a MySqlDataSource and the connection string I assign in the Page_Load method. But this I have to do for every page. This is not fine.

In C++Builder Desktop application I have a Connection component and this I assign to the several datasources once via designer and not every time via source.

Is this also possible in ASP.NET with your component.

Right now my code is below

Code: Select all

        protected void Page_Load(object sender, EventArgs e)
        {
            // ConfigurationSettings.AppSettings("CratemakerDB");
            NameValueCollection names = ConfigurationManager.AppSettings;
            String value = names.Get("CratemakerDB");
            MyDsFirma.ConnectionString = value;
        }

Thanks
Thomas

Thomas J.

[INIT|OK]
[START|Default:1001|TCP port mapping|OK]
[CLIENT|127.0.0.1|ACCEPTED|0]
[PEER|127.0.0.1|OK]
[0|TRANSFER|127.0.0.1->166]
#####h#######MyDAC monitoring is started### S:\Cratemaker10\.\Cratemaker.exe###########h#######MyDAC monitoring is started### S:\Cratemaker10\.\Cratemaker.exe
[0|TRANSFER|127.0.0.1->4]
###
[0|TRANSFER|127.0.0.1->836]
########h###
##^SQL Execute: SELECT * FROM t_event_calendar
WHERE (n_status >= 0 AND d_start >= :startDate AND d_start = 0 AND n_erledigt = 0
:startDate(Date)=16.04.2010
:endDate(Date)=17.04.2010###ôC
éË`###TbTerminKalender######TMyQuerya™ð###MCModuleTerminkaender######
TMyConnection##SELECT * FROM t_event_calendar
WHERE (n_status >= 0 AND d_start >= :startDate AND d_start = 0 AND n_erledigt = 0 ###### startDate###Date#######
16.04.2010###endDate###Date#######
17.04.2010####
[0|TRANSFER|127.0.0.1->4]
###
[0|TRANSFER|127.0.0.1->470]
########h###
##^SQL Execute: SELECT * FROM t_event_calendar
WHERE (n_status >= 0 AND d_start >= :startDate AND d_start = 0 AND n_erledigt = 0
:startDate(Date)=16.04.2010
:endDate(Date)=17.04.2010###ôR############## startDate###Date#######
16.04.2010###endDate###Date#######
17.04.2010####
[0|TRANSFER|127.0.0.1->4]
[0|TRANSFER|127.0.0.1->20]
########h###
##Q
[0|TRANSFER|127.0.0.1->784]
SQL Execute: SELECT *
FROM t_event_calendar
WHERE ((n_internal_event_type = 100)
AND d_start >= :startDate
AND d_start = 100)
AND d_start >= :startDate
AND d_start 461]
###########h###
##QSQL Execute: SELECT *
FROM t_event_calendar
WHERE ((n_internal_event_type = 100)
AND d_start >= :startDate
AND d_start 4]
[0|TRANSFER|127.0.0.1->1460]
[0|TRANSFER|127.0.0.1->1852]
lungsart_id IS NULL, 0, 1) AS n_ispm,
IF (vnr.d_fertig IS NULL, 0, 1) AS n_fertig, vas.c_nr AS verp_nr, c.d_start, vz.d_datetime AS erstellt
FROM t_verpackung_zeiten vz, t_auftrag_posten_sonstige vas, t_auftrag a, t_verpackung_nr_list vnr LEFT JOIN t_event_calendar c ON vnr.c_abhollief_termin = c.c_id
WHERE vz.n_type_id = 0 AND vnr.n_status = 0
AND vas.n_typ_id = 1
AND vz.n_verp_id = vas.n_id AND vz.n_verp_sub_id = vas.n_auftrag_id AND vz.n_verp_typ_id=150
AND vz.n_verp_id = vnr.n_verp_id AND vz.n_verp_sub_id = vnr.n_verp_sub_id AND vz.n_verp_typ_id=vnr.n_verptyp_id AND vz.c_nr = vnr.c_nr
AND vas.n_auftrag_id = a.n_id
AND vnr.n_verrechnet = 0
GROUP BY 1,2,3,4,5,6,4,8,10,11,12,13

UNION

SELECT DISTINCT vz.n_verp_id, vz.n_verp_sub_id, vz.n_verp_typ_id, a.n_land_id,
-10 AS n_holzbehandlung_id, a.n_kunde_id, p.verp_auftrag_id, vz.c_nr_org, MAX(vz.n_type_id) AS n_type_id, p.verp_mattyp_id AS n_mattyp_id,
IF (p.verp_verpacken = 1, 1, IF (p.verp_seem, 1, 0)) AS verpacken,
0 AS n_ispm,
IF (vnr.d_fertig IS NULL, 0, 1) AS n_fertig, p.verp_nr AS verp_nr, c.d_start, vz.d_datetime AS erstellt
FROM t_verpackung_zeiten vz, t_packmittel_gebraucht_details p, t_auftrag a, t_verpackung_nr_list vnr LEFT JOIN t_event_calendar c ON vnr.c_abhollief_termin = c.c_id
WHERE vz.n_type_id = 0 AND vnr.n_status = 0
AND vz.n_verp_id = p.n_id AND vz.n_verp_sub_id = 0 AND vz.n_verp_typ_id=p.verp_typ
AND vz.n_verp_id = vnr.n_verp_id AND vz.n_verp_sub_id = vnr.n_verp_sub_id AND vz.n_verp_typ_id=vnr.n_verptyp_id AND vz.c_nr = vnr.c_nr
AND p.verp_auftrag_id = a.n_id
AND vnr.n_verrechnet = 0
GROUP BY 1,2,3,4,5,6,4,8,10,11,12,13
) p, t_firma f, t_auftrag a LEFT JOIN t_projekt pr ON a.n_projekt_id = pr.prj_id
WHERE a.n_id = p.n_auftrag_id
AND a.n_kunde_id = f.firmaKey
AND a.d_geloescht IS NULL

[0|DISCONNECT|RECV_FROM_SERVER|10054]
[0|TRANSFER|127.0.0.1->18314]
[0|DISCONNECT|SEND_TO_SERVER|10054]
[SESSION_CLOSED|0]

Thomas J.

Thomas J.

The only line which is written is
[START|Default:1001|TCP port mapping|OK]

but the log of the DbMonitor is full with lines.

for the config check
http://www.cratemaker.de/Download/NetView.avi

Thomas J.

Sorry but I don't have
Tools->NetProxy

where do you downloaded the version?

Thomas J.

I downloaded the NetView, but how to process now?
I never used such tool?

Thanks
Thomas

FYI
Also the new version of your product is not working regarding DbMonitor.
I use a Windows 7 64-Bit

Devart Forums

Search found 95 matches

Re: TUniStoredProc Linux Assertion

Re: TUniStoredProc Linux Assertion

TUniStoredProc Linux Assertion

AV with C++Builder XE3

Where is the method ParamByName from MySqlCommand

Cannot change field value of join

Licensing problem

Assign global connection string