Devart Forums

moppelstroppel

Hello support,

I’m using the version 10.1.1 and I try to connect to an FTP server with SFTP.
If I put the component on form an try to connect everything fine.

But if I try to implement
UnicodeString path = ".";
TScSFTPFileHandle* fHandle = ScSFTPClient1->OpenDirectory(path);

I get this error
[C++ Error] Unit1.cpp(22, 23): no viable conversion from 'System::DynamicArray<System::Byte>' (aka 'DynamicArray<unsigned char>') to 'Scsftputils::TScSFTPFileHandle *' (aka 'DynamicArray<unsigned char> *')

If I try to implement the OnDirectoryList I get an error by double click (IDE is generating the function)
The IDE shows "Error in modul Unit1: wrong decalaration of method in class TForm1"

I try to do the following.
1. Connect to an FTP server
2. Read the files in the directory
3. Download all jpg files from FTP server
4. Delete all downloaded files
5. Disconnect from FTP server

Thanks
Thomas

moppelstroppel

Hello all,
I'm using Windows 11 with C++Builder 11.
The resolution is 3840x2160 and I'm not able to read the SQL statement due to to small letter.
I have to copy the statement into Notepad.

moppelstroppel

Sorry my fault. A TRIGGER was the real problem.

moppelstroppel

Hi support,

if I try to udpating more the one row I get the error

#42000Result consisted of more than one row

I'm using a
MySQL 8.0.19
MyDAC 10.4.03
C++Builder 10.3

I tried
- TMyQuery with StrictUpdate (true / false) and/or QuoteNames (true / false)
- TMyCommand
- TMyScript

Thanks
Thomas

moppelstroppel

Hi Victor,

do you need more information or only more time?
My customer asked me for finishing the connection to the DB :-)

Thanks
Thomas

moppelstroppel

Hi Victor,

it is not working
see

www.cratemaker.de/Download/DevArtErr01.jpg

I need this also for C++Builder 10.3

Thanks
Thomas

moppelstroppel

Hi Viktor,

in the HTML file is written I have to use mydacsbridgeXX.bpk for C++Builder
I have only this directory
C:\Components\DevArt\MyDAC10_4\Demos\TechnologySpecific\SecureBridge\Delphi27

But there is no bpk file located.

I have installed all options.

Thanks
Thomas

moppelstroppel

Hi support,

any news for me?
I bought the secure bridge and need this functionality.
Otherwise I don't need other funcionality - right now.

Thanks
Thomas

moppelstroppel

Hello support,

I switched to the new version from 10.2.x to the newest version and the behavior of TMyConnection is different.
At design time I add all information to the component.
At runtime I set the Server and Port. If I try to connect I get the error Connection parameter name is unkown localhost.

The server was before localhost and I set the server again to localhost due to user action but the error appears.

If I set all these paramters by code/runtime and delete the connectionstring it is working.

this is not working

Code: Select all

	DbMyCratemaker->Server = server;

this is working

Code: Select all

        DbMyCratemaker->ConnectString = "";
	DbMyCratemaker->Server = server;
	DbMyCratemaker->Username = "cratemaker";
	DbMyCratemaker->Password = "maker";
	DbMyCratemaker->Database = "p_cratemaker";

But during login the user has only to select the server an port.

Thanks
Thomas

moppelstroppel

Hi support,

I tried to connect to a database via SSH.
But I was only able to established a SSH conection but could not reach the databse.

I checked your demos but all are in delphi or a not working C++ Builder project.
I noticed that I have to use the TMySSHIOhandler but this I didn't found. In the help topic I also didn't find anything.

I have the hostname, user and password for the SSH Server and the
user and password for the MySQL database.

How can I connect to the database?

Thanks
Thomas

moppelstroppel

Sorry, but both is not working.
I don't know the number of parameters and I tried with macro. But I can only use a string lile

"1, 5, 7, 99, 12"

and then also this wil be between ' '.

I create the SQL statement on my own and it is working.

moppelstroppel

Hello all

I have the following statement

"SELECT * FROM WHERE n_id IN (:ids)"
UnicodeString idList= "12, 15, 30";
Query->ParamByName("ids")->AsString = idList;

The executed statement is
"SELECT * FROM WHERE n_id IN ('12, 15, 30')"

MySQL returns only one record n_id = 12

I need this statement.
"SELECT * FROM WHERE n_id IN (12, 15, 30)"

Thanks
Thomas

moppelstroppel

After upgrading to V8 the application is working as expected.

moppelstroppel

Hello support,

I have a problem at customer site. Thye are uisng database MySQL 5.1.
I cannot reproduce in my system with MySQL 8.1.

Is the problem existing with MySQL 5.1 and AutoInc value after INSERT command?

TMyQuery with "Update SQLs" page I defined

Code: Select all

INSERT INTO &MainTableName
  (n_id, c_nr)
VALUES
  (:n_id, :c_nr)

UnicodeString id = q->FieldByName("n_id")->AsString;

id is empty.

Thanks
Thomas

moppelstroppel

Hello support,

I'm using
C++Builder 10.4.1
MySQL 8.x
MyDQC 10.3.2

If I set the server my appliaction shows the error

Connection parameter name is unkown localhost.

and stop.
I switched back to version 10.2.4 everything works fine.

Did I miss something?

Thanks Thomas

Devart Forums

Search found 19 matches

Version 10.1.1 not working in C++Builder XE5 or Alexandria

Editor to small with high resolution

Re: Error updating more the one row

Error updating more the one row

Re: Connection via SSH with C++Builder

Re: Connection via SSH with C++Builder

Re: Connection via SSH with C++Builder

Re: Connection via SSH with C++Builder

Connection parameter name is unkown localhost

Connection via SSH with C++Builder

Re: Parameter without Inverted Commas

Parameter without Inverted Commas

Re: AutoInc with MySQL 5.1 not working

AutoInc with MySQL 5.1 not working

Connection parameter name is unkown localhost.