more quick actions
minimize quick actions
Topic starter
Hello, everyone.
I have a question about Dream Repor.
The System configuration was , PcVue → SQL Server → DreamReport .
The arrow is the direction of travel of the data.
Now i can get date from SQL Server.
But when i set Dream Report 「Driver Configuration」.The error news display.
So, have someone have relevant experience to use Dream to link SQLServer？
BR
Posted : 09/05/2023 6:29 pm
Hello,
This is the most used driver.
You may need to use SQL Server authentication if Windows authentication is not working.
Can you connect to the database on the same machine using SSMS?
BR,
Ludo
Posted : 09/05/2023 7:28 pm
Topic starter
Hello
Thank you reply quickly.
I can use SSMS to connect to the database on the same PC by Windows authentication.
I forget i used SQL express , not is SQL Developer...
I will use Developer try again.
By the way , this driver must use to SQL server authentication?
BR.
Posted : 10/05/2023 7:22 am
Topic starter
Hello
I use SQL Developer try again. But it is useless.
I can use user "sa" to access database in same PC.
But in Dream report , user "sa" also not working. Same error display .
I thinnk i forget some setting? But i dont know which one ...
Posted : 10/05/2023 9:24 am
Hi Bian,
Could you translate the message in english please?
nico
Posted : 10/05/2023 6:05 pm
Topic starter
Hello Nico and other one .
Thank your reply.
The error news translate to english was ：「ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified」
The problem was sloved.
The reason was not have PcVue Driver.
You have to manual install the driver , use data「sqlcli_11_x86」or「sqlcli_11_64」 from path C:ODSDream ReportUtilities.
BR
Posted : 11/05/2023 7:38 am