Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
46
Web Server - Ask For Help / Re: NetTalk and Capesoft - Thanks!!!
« on: June 23, 2013, 03:17:00 PM »
I know right ?!?
IMO - Deployment is about the most head slapping easiest thing in the world.
After doing several IIS, Apache etc. installations that have eaten up a whole day, I must say that NTWS installs are so easy that I've befuddled many an IT provider. They keep asking me for lengthy installation documents and change specs and registry settings etc., and I just say "Copy the file into a folder, any folder, then run the EXE". They simply cannot believe that you can deploy a web server like that.
IMO - Deployment is about the most head slapping easiest thing in the world.
After doing several IIS, Apache etc. installations that have eaten up a whole day, I must say that NTWS installs are so easy that I've befuddled many an IT provider. They keep asking me for lengthy installation documents and change specs and registry settings etc., and I just say "Copy the file into a folder, any folder, then run the EXE". They simply cannot believe that you can deploy a web server like that.
47
Web Server - Ask For Help / NetTalk as a service and ODBC drivers
« on: June 11, 2013, 04:40:56 PM »
Hey all,
We've got a web service here written in NetTalk that uses a combination of TPS file and CONNX ODBC drivers to get data from a legacy system.
Client wants this web app to run as a service on their main server so that it is still available after reboots etc. All fine except that when running as a service, the ODBC links just do not work at all. No data found. Running the app standalone works absolutely fine. I set up the service with the same credentials as I use on the server (when testing standalone OK) but still no dice. I've made sure the ODBC DSN is a System DSN and not a User DSN. TPS file access works fine. Just the ODBC ones that break.
Any tips for getting service based NetTalk sites to communicate nicely via ODBC ?
Thanks,
Devan
We've got a web service here written in NetTalk that uses a combination of TPS file and CONNX ODBC drivers to get data from a legacy system.
Client wants this web app to run as a service on their main server so that it is still available after reboots etc. All fine except that when running as a service, the ODBC links just do not work at all. No data found. Running the app standalone works absolutely fine. I set up the service with the same credentials as I use on the server (when testing standalone OK) but still no dice. I've made sure the ODBC DSN is a System DSN and not a User DSN. TPS file access works fine. Just the ODBC ones that break.
Any tips for getting service based NetTalk sites to communicate nicely via ODBC ?
Thanks,
Devan
48
Web Server - Ask For Help / NetTalk and MySQL - Which MyODBC version?
« on: May 28, 2013, 07:33:41 PM »
Hey all - just a general question to those of you using MySQL databases with NetTalk & Clarion.
We've been basically using MyODBC version 3 for a while here, as we had found the early releases of MyODBC 5.x to be problematic. Lately though, we have been using 5.22 on a couple of projects and it seems to be working fine. In fact, we HAD to start using 5.x because it appears that 3.x has issues with 64 bit machines.
We have one particular site that is a couple of years old, that is running MyODBC 3.11. That site is starting to experience a lot of constant GPF's, and we installed GPFReporter on that site's code, and it *appears* to be the myodbc3.dll file that is causing the crashes.
I think we will have to upgrade that site to MyODBC 5.22 as well, but I just wanted to hear what other people's experience has been with MyODBC?
Note: Oracle still releases 3.x and 5.x side by side.
Thanks,
Devan
We've been basically using MyODBC version 3 for a while here, as we had found the early releases of MyODBC 5.x to be problematic. Lately though, we have been using 5.22 on a couple of projects and it seems to be working fine. In fact, we HAD to start using 5.x because it appears that 3.x has issues with 64 bit machines.
We have one particular site that is a couple of years old, that is running MyODBC 3.11. That site is starting to experience a lot of constant GPF's, and we installed GPFReporter on that site's code, and it *appears* to be the myodbc3.dll file that is causing the crashes.
I think we will have to upgrade that site to MyODBC 5.22 as well, but I just wanted to hear what other people's experience has been with MyODBC?
Note: Oracle still releases 3.x and 5.x side by side.
Thanks,
Devan
49
Web Server - Ask For Help / Multiple lines on a column in a browse?
« on: May 23, 2013, 10:16:38 PM »
In NT7, is it possible to show more than one line in a browse column?
For instance, I have a column in which I would like to show the Customer Name in bold, the underneath that, the category in italics. In the browse procedure, column property, I place in the 'Display' field:
'<strong>' & CUS:Name & '</strong><br /><em>' & CUS:Category & '</em>'
It shows me the customer name bolded, but not the second line.
I even have a graphic in column 1 which makes the row heights much taller than one line, but still no show.
What is the trick to achieving this?
Thanks,
Devan
For instance, I have a column in which I would like to show the Customer Name in bold, the underneath that, the category in italics. In the browse procedure, column property, I place in the 'Display' field:
'<strong>' & CUS:Name & '</strong><br /><em>' & CUS:Category & '</em>'
It shows me the customer name bolded, but not the second line.
I even have a graphic in column 1 which makes the row heights much taller than one line, but still no show.
What is the trick to achieving this?
Thanks,
Devan
50
Web Server - Ask For Help / Display image on page after uploading?
« on: May 23, 2013, 09:23:40 PM »
Hi all,
Just wondering what would be the easiest way to display an image on a form after the user has uploaded it?
I am using NT7's new file upload, which begins uploading the file as soon as the user selects it. I'd like to be able to immediately display the image itself below the prompt after the upload is completed.
How do I refresh the 'Display' field for the image? I tried entering the field equate of the 'Display' field under Client-Side/Refresh on the File Upload field, but it doesn't seem to redraw it?
I am also considering having a 'Delete Image' button underneath it which will delete the image and refresh the page to remove the image from the screen.
Thanks,
Devan
Just wondering what would be the easiest way to display an image on a form after the user has uploaded it?
I am using NT7's new file upload, which begins uploading the file as soon as the user selects it. I'd like to be able to immediately display the image itself below the prompt after the upload is completed.
How do I refresh the 'Display' field for the image? I tried entering the field equate of the 'Display' field under Client-Side/Refresh on the File Upload field, but it doesn't seem to redraw it?
I am also considering having a 'Delete Image' button underneath it which will delete the image and refresh the page to remove the image from the screen.
Thanks,
Devan
51
Web Server - Ask For Help / NT7 TaskPanel formatting oddities
« on: May 23, 2013, 01:05:47 AM »
Ok - I've bitten the bullet and upgraded my development environment to NT7 now.
Just compiled a new site that we were halfway working through, which uses the TaskPanel menu on the left hand side, and immediately noticed a couple of things:
The heading on the top of each task panel section (e.g. 'Home', 'Browse' etc. are overlapping the expand/contract icons on some themes - Aristo being one of the themes affected. Not sure how to fix this.
Also, I've noticed that my login screen has now moved to the left of the screen, whereas previously in NT6 it was in the centre. I checked the form CSS and it is 'nt-fixed-center' so not sure why it has moved over in 7?
I'll try and attach a screenshot which gives more info.
Cheers,
Devan
[attachment deleted by admin]
Just compiled a new site that we were halfway working through, which uses the TaskPanel menu on the left hand side, and immediately noticed a couple of things:
The heading on the top of each task panel section (e.g. 'Home', 'Browse' etc. are overlapping the expand/contract icons on some themes - Aristo being one of the themes affected. Not sure how to fix this.
Also, I've noticed that my login screen has now moved to the left of the screen, whereas previously in NT6 it was in the centre. I checked the form CSS and it is 'nt-fixed-center' so not sure why it has moved over in 7?
I'll try and attach a screenshot which gives more info.
Cheers,
Devan
[attachment deleted by admin]
52
Web Server - Ask For Help / Re: NT WS and GoogleAnalytics
« on: May 22, 2013, 07:52:17 PM »
Hi Johan,
I just took a brief look at the site. It wouldn't work at all for me earlier today, but seems to be working now.
It looks like you have got the Google Analytics code in a separate .js file? I don't know if it will work that way. If memory serves me correctly, I think Google needs that <script> section to be embedded within the actual page, and not in a separate .js file? In any case, I cannot see the script anywhere on the home page, so perhaps in only comes up once logged in?
Also, I noticed in the source code that the line:
<script src="/scripts/googleanalytics.js" type="text/javascript"></script>
comes up TWICE in the main page - could be causing an issue if that is the case.
Hope this helps.
Cheers,
Devan
I just took a brief look at the site. It wouldn't work at all for me earlier today, but seems to be working now.
It looks like you have got the Google Analytics code in a separate .js file? I don't know if it will work that way. If memory serves me correctly, I think Google needs that <script> section to be embedded within the actual page, and not in a separate .js file? In any case, I cannot see the script anywhere on the home page, so perhaps in only comes up once logged in?
Also, I noticed in the source code that the line:
<script src="/scripts/googleanalytics.js" type="text/javascript"></script>
comes up TWICE in the main page - could be causing an issue if that is the case.
Hope this helps.
Cheers,
Devan
53
Web Server - Ask For Help / Re: SSL won't serve up pages?!?
« on: May 21, 2013, 01:18:50 AM »
SOLVED!
Gah! Rookie mistake.
I didn't realise that the port number you set (in my case port 88) was STILL the port number to use over an SSL connection !!
Immediately under the checkbox for the SSL option in NetTalk, it says "The default port for a secure server is 443". I assumed that this meant the port would AUTOMATICALLY be 443 when "Use SSL to make server secure" was checked, and the entered port number would be superflous.
Turns out I was wrong... as I often am...
Perhaps this prompt string could be reworded as: "The default port for a secure server should be 443" ?
Gah! Rookie mistake.
I didn't realise that the port number you set (in my case port 88) was STILL the port number to use over an SSL connection !!
Immediately under the checkbox for the SSL option in NetTalk, it says "The default port for a secure server is 443". I assumed that this meant the port would AUTOMATICALLY be 443 when "Use SSL to make server secure" was checked, and the entered port number would be superflous.
Turns out I was wrong... as I often am...
Perhaps this prompt string could be reworded as: "The default port for a secure server should be 443" ?
54
Web Server - Ask For Help / SSL won't serve up pages?!?
« on: May 21, 2013, 01:08:53 AM »
Hey all,
Just dabbling in my first SSL server for a project.
Using NetTalk 6.51. I've applied for a wildcard certificate from GoDaddy. All went well. I downloaded the CRT file and copied the KEY file into the app/certificates folder. I turned off the 'Supress Error Messages'. I was initially getting the error 65 because my certificate names didn't match, but I fixed that so I am not getting any errors coming up.
The NT server starts up OK (no errors) but when I try and test https://localhost, I get nothing. The NT server screen shows no traffic and my browsers time out. I've checked the DebugView logs etc. but no errors are logged. I've made sure the 4 SSL DLL files are copied into this folder as well.
I've tried a couple of different browsers, and running the server app on two different machines. Same results all around.
I've run Fiddler and am getting '502' errors when the browser is trying to connect to the local NT server.
I turn OFF the SSL checkbox and access the NT app with just http://localhost and it WORKS!
Just won't deliver anything via SSL and not telling me anything useful that points me in the right direction to try and fix it.
Help!
Thanks,
Devan
Just dabbling in my first SSL server for a project.
Using NetTalk 6.51. I've applied for a wildcard certificate from GoDaddy. All went well. I downloaded the CRT file and copied the KEY file into the app/certificates folder. I turned off the 'Supress Error Messages'. I was initially getting the error 65 because my certificate names didn't match, but I fixed that so I am not getting any errors coming up.
The NT server starts up OK (no errors) but when I try and test https://localhost, I get nothing. The NT server screen shows no traffic and my browsers time out. I've checked the DebugView logs etc. but no errors are logged. I've made sure the 4 SSL DLL files are copied into this folder as well.
I've tried a couple of different browsers, and running the server app on two different machines. Same results all around.
I've run Fiddler and am getting '502' errors when the browser is trying to connect to the local NT server.
I turn OFF the SSL checkbox and access the NT app with just http://localhost and it WORKS!
Just won't deliver anything via SSL and not telling me anything useful that points me in the right direction to try and fix it.
Help!
Thanks,
Devan
55
Web Server - Ask For Help / Capturing posted fields from a 3rd party form
« on: May 08, 2013, 03:13:40 AM »
Hi all,
We are scoping out a project whereby we need to have a NetTalk procedure that will be the ACTION procedure for third party web forms where we might not know the field layouts.
I need to be able to get the procedure to parse through all the POSTed fields to isolate the variable names so that I can cherry pick only certain field values that are to be saved to a data file.
Are there any shortcuts to this, other than parsing through the header of the request?
Thanks,
Devan
We are scoping out a project whereby we need to have a NetTalk procedure that will be the ACTION procedure for third party web forms where we might not know the field layouts.
I need to be able to get the procedure to parse through all the POSTed fields to isolate the variable names so that I can cherry pick only certain field values that are to be saved to a data file.
Are there any shortcuts to this, other than parsing through the header of the request?
Thanks,
Devan
56
Web Server - Ask For Help / Re: Server 'push' updates to refresh a browse?
« on: May 07, 2013, 03:07:05 PM »
Thanks for the extra technical info Bruce !
Thinking back through most of my sites, I am not sure that this would be a 'must have' feature in my apps at the moment, but a 'nice to have' in the future which may open up more possibilities. The app my colleague demonstrated for instance, was a manufacturing assembly line tracking system, so real time updates on the status of components etc. was critical across the shop floor.
Cheers,
Devan
Thinking back through most of my sites, I am not sure that this would be a 'must have' feature in my apps at the moment, but a 'nice to have' in the future which may open up more possibilities. The app my colleague demonstrated for instance, was a manufacturing assembly line tracking system, so real time updates on the status of components etc. was critical across the shop floor.
Cheers,
Devan
57
Web Server - Ask For Help / Server 'push' updates to refresh a browse?
« on: May 01, 2013, 04:18:21 PM »
Hey all,
I was chatting to a colleague yesterday who has developed a web based system for a mutual client using Microsoft's Azure Cloud. It is a nice web system with browses/forms etc. very similar to a NetTalk app, but one feature he showed off that he was very proud of, and that I found intriguing, was that the .NET app provided 'push' updates to the browses on different terminals.
For instance, if the operator at Terminal 'A' entered a new record into a browse screen, within seconds, operators on terminal 'B' and 'C' who had that browse open would experience an automatic refresh of the browse showing the new record.
My colleague was understandably cagey about giving away too much detail, but there is apparently some sort of add on with the Microsoft Azure cloud (where the web app is hosted) that provides this facility.
I know that 'server push' is not a standard paradigm in the web world, but I was wondering if we could replicate this functionality in NetTalk in some way? Perhaps even a client side 'silent poll' on a periodic basis that would redraw the browse if there was a change?
I was chatting to a colleague yesterday who has developed a web based system for a mutual client using Microsoft's Azure Cloud. It is a nice web system with browses/forms etc. very similar to a NetTalk app, but one feature he showed off that he was very proud of, and that I found intriguing, was that the .NET app provided 'push' updates to the browses on different terminals.
For instance, if the operator at Terminal 'A' entered a new record into a browse screen, within seconds, operators on terminal 'B' and 'C' who had that browse open would experience an automatic refresh of the browse showing the new record.
My colleague was understandably cagey about giving away too much detail, but there is apparently some sort of add on with the Microsoft Azure cloud (where the web app is hosted) that provides this facility.
I know that 'server push' is not a standard paradigm in the web world, but I was wondering if we could replicate this functionality in NetTalk in some way? Perhaps even a client side 'silent poll' on a periodic basis that would redraw the browse if there was a change?
58
Web Server - Ask For Help / Re: NT WS email to ClickATell on RackSpaceCloud
« on: April 28, 2013, 04:49:37 PM »
We have been using Amazon's SES (Simple Email Service) with great results with our NTWS apps.
We also host the apps on Amazon's EC2 and the integration is seamless. Although you DON'T have to be using the other Amazon services to use SES.
We also host the apps on Amazon's EC2 and the integration is seamless. Although you DON'T have to be using the other Amazon services to use SES.
59
Web Server - Share Knowledge / Re: Server Stability
« on: March 26, 2013, 12:57:57 AM »
This may have nothing to do with anything, but...
We had a couple of sites where the NetTalk server would GPF and shut down from time to time, for no real explicable reason, and at no particular consistent point. One site especially would call up about twice a week with an issue. Both sites were not 'heavy' users of the portals we created - only the occasional updates.
To try and be proactive (and reduce embarrassment to us) I decided to implement a monitoring solution which would let me know when the sites went down so that I could (hopefully) reset them before the client realised. I used the wonderful, free, UpTimeRobot.com site for this.
The thing is - we've had UptimeRobot running for over two weeks now, and NONE of the sites have failed. At all.
I am not sure if the 5 minute polling that UptimeRobot does tends to keep the server 'alive' and precludes the condition that causes it to crash?
Like I said - long shot, but we've certainly noticed a big improvement in stability whilst our NetTalk servers in the field get a regular HTTP hit every 5 minutes.
I'm not shilling for UptimeRobot here. It is just the site we chose to use. I am assuming any other monitoring site/solution that does 5 minute pings might work too.
If you have a problematic site - try setting up a monitor with either UTR or some other one, and see if that improves it... Worth a shot...
Cheers,
Devan
We had a couple of sites where the NetTalk server would GPF and shut down from time to time, for no real explicable reason, and at no particular consistent point. One site especially would call up about twice a week with an issue. Both sites were not 'heavy' users of the portals we created - only the occasional updates.
To try and be proactive (and reduce embarrassment to us) I decided to implement a monitoring solution which would let me know when the sites went down so that I could (hopefully) reset them before the client realised. I used the wonderful, free, UpTimeRobot.com site for this.
The thing is - we've had UptimeRobot running for over two weeks now, and NONE of the sites have failed. At all.
I am not sure if the 5 minute polling that UptimeRobot does tends to keep the server 'alive' and precludes the condition that causes it to crash?
Like I said - long shot, but we've certainly noticed a big improvement in stability whilst our NetTalk servers in the field get a regular HTTP hit every 5 minutes.
I'm not shilling for UptimeRobot here. It is just the site we chose to use. I am assuming any other monitoring site/solution that does 5 minute pings might work too.
If you have a problematic site - try setting up a monitor with either UTR or some other one, and see if that improves it... Worth a shot...
Cheers,
Devan
60
Web Server - Ask For Help / Re: Using Net:f:filename.html
« on: March 18, 2013, 03:48:56 PM »
Thanks for checking this Bruce...
Yes, I did some more testing on this after I posted the original message, and under some circumstances I *could* edit the file whilst the server was running, so the scenario you mentioned makes sense.
Thanks for making the changes in 7.07. I have kept all my sites to 6.51 at the present time, but over the next month or so, will be slowly upgrading them all to NT7...
Yes, I did some more testing on this after I posted the original message, and under some circumstances I *could* edit the file whilst the server was running, so the scenario you mentioned makes sense.
Thanks for making the changes in 7.07. I have kept all my sites to 6.51 at the present time, but over the next month or so, will be slowly upgrading them all to NT7...