DMXzone Database Connector ASP Support Product Page

This topic was archived by Teodor Kuduschiev on 1/19/2021 7:27:24 AM
Under investigation

Error Using This Database Connection - ASP/SQL

Reported 27 Jun 2014 01:00:43
5
have this problem
27 Jun 2014 01:00:43 Rob Smither posted:
I continue getting the "Error using this Database Connection!" - Server Response: 500 - Internal Server Error. For ASP/SQL connection - I have tried 3 different SQL server connections and they all get the same error. I can successfully connect to database through my Windows ODBC connection and even can connect with Dreamweaver CC Database connection.

Replies

Replied 13 Jun 2016 14:50:35
13 Jun 2016 14:50:35 MX Addict replied:
Yes Windows 10 with office 2013 (32 bits). Before reinstall my system I used office 2013 (64 bits). But none of the connections works.
Replied 13 Jun 2016 14:53:10
13 Jun 2016 14:53:10 Teodor Kuduschiev replied:
This might be the issue. I have 64bit Office installed, and all is fine. Maybe 32bit drivers are missing on your system - i will try to replicate this locally.
Replied 13 Jun 2016 15:06:07
13 Jun 2016 15:06:07 MX Addict replied:
I have had a conversation about this with Miroslav.

I did create a 32-bits and a 64-bits to create a ODBC system DSN connection but both did fail




translation:
the driver and the application architecture does not match the specified dsn
Replied 13 Jun 2016 15:34:31
13 Jun 2016 15:34:31 Craig A replied:

Chat on dmxzone.com
Conversation started on : Monday, June 13, 2016, at 14:00 (GMT+0)
[14:16] Craig A: Department : Sales & General Support

Your Name : Craig A
Email :
Question : I need help I cant connect ( using database connector) to MSSQL Express 2014 Ver 12.0.2269 x64 using windows 10 Home OS Build 10586.318 with 8GB RAM. If I user MSSQL management console or Windows native System DNS ODBC I have no issues.

The error I get is Error using this database connection, IIS 10.0 Detailed Error 404.3 - not found "The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, ad
[14:17] Miro has joined the conversation
[14:17] Miro: Hello Craig
[14:17] Miro: is that remote or local?
[14:18] Craig A: local
[14:25] Craig A: Are you there??
[14:26] Craig A: If you need to logon I can share a session using join.me
[14:30] Craig A: Miro are still online??
[14:30] Craig A: Miro are you still online ?
[14:43] Craig A: Miro, you do not answer I will close and Re-Open the Chat



Replied 13 Jun 2016 15:55:15
13 Jun 2016 15:55:15 Teodor Kuduschiev replied:
Please do not turn the topic into a chat room.
Craig, your request will be answered by Miro, via email.
MX Addict, i will check this and then i will let you know what might be causing this issue.
Replied 24 Aug 2016 06:54:51
24 Aug 2016 06:54:51 MX Addict replied:
Hi Teodor,

More than two months further is there still progress with this topic problem??

And when will be the Server Connect Formatter released??

QuoteTeodor Kuduschiev 

Replied 2 months ago
The data bindings formatter, as it name suggests, does only work with data bindings, not with the server connect.
The Server Connect Formatter will be released in a couple of weeks, and then you will be able to format the inserted date format, directly in the insert/update record steps.

The whole issue seems to be caused you are trying to insert dates, in a format different than the default one for your DB.


Thanks

Reply to this topic