DMXzone Server Connect Support Product Page

Solved

Data Not Showing

Reported 22 Dec 2017 06:39:44
1
has this problem
22 Dec 2017 06:39:44 Tom Straw posted:
I am having terrible trouble with some ASP pages on my website which use a database connection I call "DataLibConn." This DB connection references the ASP file located here relative to my root directory: /dmxConnect/Datalib/Datalib.asp

I am getting no error messages on the pages using this DB connection; the data simply does not display. This also happened suddenly, without my touching any of the code on these pages.

When I open /dmxConnect/Datalib/Datalib.asp in Live View in Dreamweaver, it does display a 500 Internal Server Errror. This is true of all other ASP files in the dmxConnect directory which reference the DataLibConn connection. ALl other ASP files in that directory work fine.

Within Dreamweaver, I run successful Test Connections with DataLibConn from within the Server Connect interface, but again, the pages using this connection do not show any data. Just one example of such a page is:

www.spcregion.org/data_datalib.asp

The relevant code sections are the following in the head tag:

<script type="text/javascript" src="ScriptLibrary/jquery-latest.pack.js"></script>
<script type="text/javascript" src="ScriptLibrary/dmxDataBindings.js"></script>
<script type="text/javascript" src="ScriptLibrary/dmxServerAction.js"></script>
<script type="text/javascript" src="ScriptLibrary/dmxDataSet.js"></script>

And this just before the close body tag:


Please, please help me with this problem. I am going crazy trying to figure this out!

Replies

Replied 22 Dec 2017 06:40:20
22 Dec 2017 06:40:20 Tom Straw replied:
I tried to enclose the code from the Datalib.asp, but I got a WEbKnight refusal!! Ugh!!
Replied 22 Dec 2017 08:47:32
22 Dec 2017 08:47:32 Teodor Kuduschiev replied:
Hi Tom,
Yes our firewall does not allow pasting long lines of code in the messages.
I checked your page but i see an internal server error, which could be anything. Please enable detailed error reporting on your server and then enable debug mode in server connect so i can see the exact error: www.dmxzone.com/go/32354/debugging-problems-in-dmxzone-server-connect/
Replied 22 Dec 2017 14:57:00
22 Dec 2017 14:57:00 Tom Straw replied:
many thanks for the response. I enabled the error reporting, so let me know what you find out. When I ran it, it pointed me to line 4155 of the file jquery-latest.pack.js, which is this:

f.send(a.hasContent && a.data || null),

But let me know if you find the same thing, and what it all means! Again, I appreciate your help. trying to solve this on my own nearly put me in a strait jacket!!
Replied 22 Dec 2017 14:59:02
22 Dec 2017 14:59:02 Teodor Kuduschiev replied:
Please enable detailed error reporting on your server. The error is not showing detailed description now:

Replied 22 Dec 2017 15:18:33
22 Dec 2017 15:18:33 Tom Straw replied:
OK, the only thing I could find in my admin interface for my host server was a checkbox called "Custom error documents." I checked it, but it's still returning the generic 500 error in the browser. I need to open a ticket now with my host, and when they get back to me, I will get back to you! Thanks.
Replied 22 Dec 2017 15:20:19
22 Dec 2017 15:20:19 Tom Straw replied:
Their trouble ticketing page is down now, as well.
Replied 22 Dec 2017 16:21:24
22 Dec 2017 16:21:24 Tom Straw replied:
I figured it out! Thanks for all your help. it's good to know you guys are here and responsive when needed! :-)
Replied 19 Apr 2018 13:57:47
19 Apr 2018 13:57:47 KATHLEEN SHURYN replied:
What did you do to fix your problem?

Reply to this topic