Search found 42 matches

by DiZzyDmon
Thu Oct 11, 2018 5:48 am
Forum: PrimalSQL
Topic: Version 4.4.65 unable to execute queries
Replies: 10
Views: 2477

Re: Version 4.4.65 unable to execute queries

In the PrimalSQL application, I click "New Database Connection". The "Database Connection" popup defaults to "SQL Server" (which is what I want). Here's how I fill in the five fields: Server: our SQL Server server\instance Authentication: Windows Authentication Login: (leave empty) Password: (leave ...
by DiZzyDmon
Mon Oct 01, 2018 1:43 pm
Forum: PrimalSQL
Topic: Version 4.4.65 unable to execute queries
Replies: 10
Views: 2477

Re: Version 4.4.65 unable to execute queries

"Can you provide a sample connection string without confidential information?" Data Source=<server>\<instance>;Initial Catalog=<the database name>;Integrated Security=True;User ID=;Password= (things inside <> are substitutes for the actual values) "And what version of SQL Server are you using?" Our ...
by DiZzyDmon
Thu Sep 27, 2018 2:10 pm
Forum: PrimalSQL
Topic: Version 4.4.65 unable to execute queries
Replies: 10
Views: 2477

Re: Version 4.4.65 unable to execute queries

I've never used the "Visual Query Builder", I always "Query with SQL Text".
by DiZzyDmon
Thu Sep 27, 2018 9:15 am
Forum: PrimalSQL
Topic: Version 4.4.65 unable to execute queries
Replies: 10
Views: 2477

Re: Version 4.4.65 unable to execute queries

1. What type of database connection are you using? I have 9 different database connections, all Microsoft SQL Server. All of them exhibit the same problem. 2. Do you get any messages in the log panel when you open the application or attempt to expand a database node in the browser? No messages or er...
by DiZzyDmon
Thu Sep 27, 2018 8:21 am
Forum: PrimalSQL
Topic: Version 4.4.65 unable to execute queries
Replies: 10
Views: 2477

Version 4.4.65 unable to execute queries

Primal SQL version: 4.4.65.0 Operating system: Windows 10 1803 64-bit Yesterday I upgraded to both of my computers to Primal SQL release 4.4.65.0. I am no longer able to run any of my saved queries. When I open any of my saved queries, the "Execute Query" button is greyed out. Yesterday, sometimes, ...
by DiZzyDmon
Wed Jan 18, 2017 9:04 am
Forum: PowerShell Studio
Topic: Writing scripts to x64\<whatever>.exe failed, error code 87
Replies: 3
Views: 1526

Re: Writing scripts to x64\<whatever>.exe failed, error code 87

I've attached the .psbuild form from a failed build (of the form I am actually working on). I had to add an extra .txt file extension to get this website to accept the attachment.
by DiZzyDmon
Wed Jan 18, 2017 8:59 am
Forum: PowerShell Studio
Topic: Writing scripts to x64\<whatever>.exe failed, error code 87
Replies: 3
Views: 1526

Writing scripts to x64\<whatever>.exe failed, error code 87

Product: PowerShell Studio 2016 v5.3.131, 64-bit Operating system: Windows 10 Enterprise version 1607 build 14363.693, 64-bit PowerShell Version: 5.1.14393.693 This is my first time attempting to package a form using PowerShell Studio. No matter what form type I choose, no matter what's in it (even ...
by DiZzyDmon
Wed Dec 07, 2016 12:42 pm
Forum: PrimalSQL
Topic: Can't install PrimalSQL on computer with no internet access
Replies: 6
Views: 4898

Re: Can't install PrimalSQL on computer with no internet access

Sorry, the new installer (PQL16Setup_4.2.55_120716_x64.exe) didn't make any difference - it failed the same way, first the prerequisites, then the main install. I've attached the .MSI logs, if that's any help. A few days ago I gave up and installed "Microsoft SQL Server Management Studio" 16.5. It w...
by DiZzyDmon
Fri Dec 02, 2016 5:47 am
Forum: PrimalSQL
Topic: Can't install PrimalSQL on computer with no internet access
Replies: 6
Views: 4898

Re: Can't install PrimalSQL on computer with no internet access

I followed the steps in the article you referenced. The Certificate window > Certification Path tab for all three of the signed files (PQL16Setup_4.2.54_080516_x64.exe, PrimalSQL 2016.msi, disk1.cab) looked like "Trusted Certificate.png", with Certificate status "This certificate is OK". I tried ins...
by DiZzyDmon
Thu Dec 01, 2016 12:54 pm
Forum: PrimalSQL
Topic: Can't install PrimalSQL on computer with no internet access
Replies: 6
Views: 4898

Re: Can't install PrimalSQL on computer with no internet access

Darn, "Allow software to run or install even if the signature is invalid" didn't work. I then tried opening things up even more under Internet Options > Advanced > Security (screenshot attached), restarted, verified that Group Policy didn't revert any of my changes, tried the install again. It took ...