Activity overview
Latest activity by jolthoff
Thanks! I put a request in to get those permissions changed... I'll keep you posted! / comments
Thanks! I put a request in to get those permissions changed... I'll keep you posted!
I have also found that on some machines I have needed to specify the custom property of RG_WARNING to supress the warning of MDAC 2.8. I have MDAC 2.8 installed, but for some reason, there are a few machines giving this error.
My install line now looks like this: MSIExec /i "SQL Prompt.msi" RG_LICENSE=000-000-000000-0000 RG_WARNING=False
I also found the following...
I grabbed the msi from the Temp Files location, and just pulled the "SQL Prompt_3.9.0.43" folder out from that location. It contained another folder called "Red Gate". I found that I needed to create a script to copy this folder and it's contents to C:\Windows\Temp\ for the install to work properly. I have noticed I only needed this to be done if I was upgrading only. Below is a simple vbs script I use to accomplish this: 'On Error Resume Next
Const OverwriteExisting = True
Const DONOTOverwrite = False
Set WshShell = WScript.CreateObject("WScript.Shell")
Set objFSO = CreateObject("Scripting.FileSystemObject")
sTEMPSource = "\\Server\share\RedGate\SQL Prompt_3.9.0.43\*"
sTEMPDest = "C:\Windows\Temp\"
objFSO.CopyFolder sTEMPSource , sTEMPDest , OverwriteExisting
Hope this helps everyone else out!
Thanks again
Jeff / comments
I have also found that on some machines I have needed to specify the custom property of RG_WARNING to supress the warning of MDAC 2.8. I have MDAC 2.8 installed, but for some reason, there are a f...
Schema Retrieval Failed
Just upgraded to SQL Prompt 3.9... Had 3.6 before this. We just switched to using SQL 2008, thus the reason for the upgrade.
All my SQL 2008 users are getting the following errors (I say errors, ...
You are a genius! It worked just fine!
I also appreciate the tip for the License Activation! You have no clue how long we've been trying to figure this out for this product!
Thanks a million!
Jeff / comments
You are a genius! It worked just fine!
I also appreciate the tip for the License Activation! You have no clue how long we've been trying to figure this out for this product!
Thanks a million!
Jeff
Silent Install Possible???
I'm looking to see if anyone can help me install SQL Prompt v3.9 silently? I have tried all the switches I can think of to get this to go, but with no luck. Is there a special switch that I can u...