08-07-2017 09:54 AM
Hello Experts,
I have configured my Database on SQL Server in TestStand. I am able to read and extract data from this database in LabVIEW but having some troubles doing the same in TestStand Database Viewer as I am getting this famous error "Datasource not found and no standard driver specified". I am not able to understand what is happening here, as the Database Viewer displays all the Database information correctly like all my Tables and Views but throws this error when i try to view/edit/create any table.
Note: Database Viewer/ LabVIEW/ TestSTand installed are 32-bit versions running on 64-bit OS.
Data Source is configured in the ODBC from this path: C:\Windows\SysWOW64\odbcad32.exe
Please let me know if anyone has any idea about this also if you need any further info/scrreenshots.
Thanks
Rahul
08-21-2017 08:02 AM
Hi Rahul,
have you also tested the TestStand Viewer 64-bit if you are using the 32-bit version so far (or vice versa)?
Best regards,
Christoph
08-21-2017 08:24 AM
Hey Christoph,
Thanks for your reply.
I have been using the 32-bit version of the TestStand Database Viewer so far and not yet tested for the 64-bit version.
Do you think that the application version is the cause of problem here?
FYI: I have no problems with 'View Data' on the TestStand Results.mdb database shipped with NI TestStand.
Regards,
Rahul
03-22-2018 03:27 PM
I'm having the same issue. Were you able to figure out the issue?
05-24-2018 03:48 PM
There could be an mismatch in version 32 - 64 bits, verify if your ar running the application as Administrator, some tables could not be edited if this has a relation determined or exist some Store procedure that create a dependency.
The next article explain more about the connection
https://knowledgebase.progress.com/articles/Article/3352
I hope this information help in something .!
Regards..!
Adolfo islas
05-14-2019 08:37 AM
Hi Raul22,
Can you verify that this is not the same issue as in this post. Specifically the part where you use the Data Link Properties dialog to generate a connection string when using an ODBC driver.
Regards,
Tinu