- Thank you received: 0
Classic ASP / VBscript
- h0tw1r3
- Topic Author
- Visitor
-
14 years 3 weeks ago #80
by h0tw1r3
Classic ASP / VBscript was created by h0tw1r3
I am attempting to make a connection to a local install of pg 8.4 using ASP under IIS 7 (windows 7).
File: test.asp
Results in an infinite loop. The script never returns and I must kill the application pool. I turned on debugging, but nothing shows up.
I then decided to test a connection using the command line.
File: test.vbs
Run: cscript /nologo test.vbs
This time I get a popup dialog asking if I agree to the license (trial), I select agree, and the script continues successfully.
My problem lies in the fact that "I agree" is not saved and therefor the dialog pops up every time the dll is loaded. This is a problem when trying to evaluate your product on IIS as it suppresses the dialog and enters an infinite loop waiting for me to select "i agree", which is simply not possible.
Is there any way to work around this problem? I am currently using the open source pgoledb, but would prefer a commercially supported product.
File: test.asp
Code:
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=PGNP.1;Data Source=localhost;Initial Catalog=postgres;User ID=postgres;Password=admin;"
objConn.Open
Results in an infinite loop. The script never returns and I must kill the application pool. I turned on debugging, but nothing shows up.
I then decided to test a connection using the command line.
File: test.vbs
Code:
Set objConn = CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=PGNP.1;Data Source=localhost;Initial Catalog=postgres;User ID=postgres;Password=admin;"
objConn.Open
Run: cscript /nologo test.vbs
This time I get a popup dialog asking if I agree to the license (trial), I select agree, and the script continues successfully.
My problem lies in the fact that "I agree" is not saved and therefor the dialog pops up every time the dll is loaded. This is a problem when trying to evaluate your product on IIS as it suppresses the dialog and enters an infinite loop waiting for me to select "i agree", which is simply not possible.
Is there any way to work around this problem? I am currently using the open source pgoledb, but would prefer a commercially supported product.
Please Log in or Create an account to join the conversation.
- Moderator
-
- Offline
- New Member
Less
More
14 years 3 weeks ago #81
by Moderator
Replied by Moderator on topic Re: Classic ASP / VBscript
Are you using Vista with UAC enabled? Then launch the test from command prompt with Administrator permissions. In this case the dialog will be shown only 1 time a day.
Another reason is that the IIS application is running under different user account (Local System, etc.) than your current session. Dialog is shown per user.
If none of the above helps, please PM us and we'll send you a trial build without the reminder dialog.
Another reason is that the IIS application is running under different user account (Local System, etc.) than your current session. Dialog is shown per user.
If none of the above helps, please PM us and we'll send you a trial build without the reminder dialog.
Please Log in or Create an account to join the conversation.
- h0tw1r3
- Topic Author
- Visitor
-
14 years 3 weeks ago #83
by h0tw1r3
Replied by h0tw1r3 on topic Re: Classic ASP / VBscript
1. The IIS application pool is running under my local, logged-in user account.
2. Running the script from WSH command line results in the dialog every time i execute the script, regardless of what user I run it under (my account, administrator, etc).
3. Using a tool such as AnySQL Maestro and creating a connection through your driver produces the same results.
UAC was/is disabled on the machine throughout all tests.
Since I am using Windows 7, which is yet to be released, I also tried the above tests on Windows XP.
The results were exactly the same. A dialog for every new connection.
These tests would lend my to conclude that the problem is not specific to me, but perhaps the downloads available on the site are faulty. (note, I also tried all tests with the 1.3 beta download).
2. Running the script from WSH command line results in the dialog every time i execute the script, regardless of what user I run it under (my account, administrator, etc).
3. Using a tool such as AnySQL Maestro and creating a connection through your driver produces the same results.
UAC was/is disabled on the machine throughout all tests.
Since I am using Windows 7, which is yet to be released, I also tried the above tests on Windows XP.
The results were exactly the same. A dialog for every new connection.
These tests would lend my to conclude that the problem is not specific to me, but perhaps the downloads available on the site are faulty. (note, I also tried all tests with the 1.3 beta download).
Please Log in or Create an account to join the conversation.
- h0tw1r3
- Topic Author
- Visitor
-
14 years 3 weeks ago #84
by h0tw1r3
Replied by h0tw1r3 on topic Re: Classic ASP / VBscript
I was able to fix the problem on both machines by creating the registry key, HKCU\Software\PGNP.
Apparently the installer, or the dll, never properly creates the key which causes the subsequent dialog answer to never be saved.
You can reproduce the problem by uninstalling the driver, deleting all PGNP registry keys, and reinstalling.
Apparently the installer, or the dll, never properly creates the key which causes the subsequent dialog answer to never be saved.
You can reproduce the problem by uninstalling the driver, deleting all PGNP registry keys, and reinstalling.
Please Log in or Create an account to join the conversation.
- Moderator
-
- Offline
- New Member
Less
More
- Thank you received: 0
14 years 3 weeks ago #85
by Moderator
Replied by Moderator on topic Re: Classic ASP / VBscript
I've checked the code... Yes, the issue occurs when the key does not exists!
We'll add code to create the key.
Thank you so much for letting us know!
We'll add code to create the key.
Thank you so much for letting us know!
Please Log in or Create an account to join the conversation.
Time to create page: 0.151 seconds