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 01 Jul 2014 08:47:18
01 Jul 2014 08:47:18 Teodor Kuduschiev replied:
Hello Rob,
Please provide the exact error messages from your server logs as the 500 - Internal Server Error can be anything.
Replied 25 Aug 2014 15:00:00
25 Aug 2014 15:00:00 MX Addict replied:
I have thw same problems. I'm still waiting several months for a solution. Paid a lot of money and still I can't use this extension. See my topic.

www.dmxzone.com/support/22084/topic/59025/
Replied 28 Sep 2015 16:50:41
28 Sep 2015 16:50:41 Stephen Brown replied:
I'm getting the same error shown below. Could it be the driver? You show only the 5.2 ODBC and we are 5.3 ODBC. Also, I can connect to the database with Sequel Pro using the same credentials.

Error using this Database Connection!

500 - Internal Server error.

Server Error

500 - Internal server error.

There is a problem with the resource you are looking for, cannot be displayed.

Please use the back arrow or try again later.
Replied 13 Jun 2016 01:53:45
13 Jun 2016 01:53:45 Craig A replied:
I have the same problem as many more, I cant connect using your tool that I just purchased. Please get back to us as a courtesy and let us know what is happening on your end to get this resolved. I can connect with no problem using other tools, MS SQL management console, and the native Widows System ODBC but not with your tool. Regards Craig ( you have our email address on file so I hope to hear from you I the next 24 hours please!
Replied 13 Jun 2016 07:03:51
13 Jun 2016 07:03:51 Teodor Kuduschiev replied:
Hello Craig,
It is not really easy to guess what the issue on your server is, unless you provide exact versions of the server, your OS, your DW version. Please contact our live support chat in order to get help resolving your issue, as it requires some debugging. If we are not online, just leave a message with the requested information and our agents will contact you, regarding your ticket.
Replied 13 Jun 2016 07:41:47
13 Jun 2016 07:41:47 MX Addict replied:
Hi Teodor,

I still facing problems connecting to ms access database. I bought this extension in 2014 and never get a succesfully connection tot access. In february I had a long chat with the live support. But it is now June and still can't connect to a ms access database. I totally reinstalled my computer to sort out the problems.

My OS is WIN 10 with Office 2013 32bits. I even downgraded from 64 bits to 32 bits. But still can't connect to access database.

I tried to connect through all datatypes but none off them worked:

access
access ODBC
ODBC system DSN
custom

custom connection is the one I like tot work with remote and local:

Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Inetpub\Users\[somename]\[www]\database\database.mdb

I set read/write permissions
Replied 13 Jun 2016 08:33:36
13 Jun 2016 08:33:36 Teodor Kuduschiev replied:
Hello MX Addict,
Strange for me, there are many users out there still using Access db for web applications and they are using the Server Connect / DB Connector / DB Updater for this, without any issues.

If you are using the ASP version of the extension, there should not be any issue connecting to Access DB.
I will test this locally and check this with the developers to see what is the issue.
Replied 13 Jun 2016 08:58:49
13 Jun 2016 08:58:49 Teodor Kuduschiev replied:
Actually, i just tested this with a custom connection string, and it appears to be working just fine. Most probably your connection string is wrong.
This is how the connection string should be looking, for an Access 2013 db:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\test.accdb;Jet OLEDB:Database Password=1234;

Here is the result:

prntscr.com/bfr5um
Replied 13 Jun 2016 10:08:42
13 Jun 2016 10:08:42 MX Addict replied:
Hi Teodor,

This doesn't work local. unable to connect



First of all my hosting provider doesn't support the connection string you mentioned above. Instead I need a working Microsoft Access ODBC Driver connection string

Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Inetpub\Users\???\???\database\database.mdb

Replied 13 Jun 2016 10:15:37
13 Jun 2016 10:15:37 MX Addict replied:
Other errors



ODBC connection





Replied 13 Jun 2016 10:17:20
13 Jun 2016 10:17:20 Teodor Kuduschiev replied:
Why are you using a .mdb database, when you mentioned you are using Access 2013? The connection string i provided is for .accdb database.
Is this access 2000 db or access 2002-2003 one?
Replied 13 Jun 2016 10:22:31
13 Jun 2016 10:22:31 MX Addict replied:
Hi Teodor,

I use Office 2013 (32-bit) on my computer. My current databases are still *.mdb

Access 2002-2003 mdb
Replied 13 Jun 2016 10:25:08
13 Jun 2016 10:25:08 MX Addict replied:
The connection I can make is to SQL Server database



Replied 13 Jun 2016 10:26:06
13 Jun 2016 10:26:06 Teodor Kuduschiev replied:
Please change the custom string to:


Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\Inetpub\Users\???\???\database\database.mdb

As yours has some syntax issues. Make sure to copy and paste it exactly as i provided it especially the part before Dbq.
Replied 13 Jun 2016 10:40:32
13 Jun 2016 10:40:32 MX Addict replied:
Hi Teodor,

custom string is not working

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\Inetpub\Users\???\???\database\database.mdb

Error says: (translate from dutch to english)

Unable to connect. Name of the source has not been found and no driver specified
Replied 13 Jun 2016 10:52:58
13 Jun 2016 10:52:58 MX Addict replied:
And one other thing.

I can connect to the *.mdb databases with the Dreamweaver Database connection through custom connection string or Data Source Nam DSN. Both work perfect.
Replied 13 Jun 2016 10:59:18
13 Jun 2016 10:59:18 Teodor Kuduschiev replied:
DW server behaviors are something totally different, so they cannot be really compared with the Server Connect tool.
Are you sure there are no issues with your own hosting provider? Both:

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\Inetpub\Users\???\???\database\database.mdb

and
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\test.accdb;Jet OLEDB:Database Password=1234;

Are perfectly working locally and on the remote server with both .mdb and .accdb files.
Replied 13 Jun 2016 11:37:12
13 Jun 2016 11:37:12 MX Addict replied:
Through 32 bits ODBC I have a DSN that works fine.




Last month I did a clean install on my computer to be sure the whole system was fresh. But still giving this annoying errors. The errors does not exactly tell what is wrong.


Are there no issues with WIN10 and your extension? How can we investigate further?
Replied 13 Jun 2016 11:47:48
13 Jun 2016 11:47:48 Teodor Kuduschiev replied:
Everything i test is on Win 10. Tested on both 64 and 32 bit with the custom strings i provided it works perfectly.
Replied 13 Jun 2016 12:33:41
13 Jun 2016 12:33:41 MX Addict replied:
Can you tell me where to investigate further to get the right settings.WIN10, IIS8.5, Dreamweaver CS6, etc.

All the connections other than DMXZone Database connection does work. The only connection that works in DMXZone Database connection is SQL Server custom connectionstring
Replied 13 Jun 2016 12:36:24
13 Jun 2016 12:36:24 Teodor Kuduschiev replied:
First - please try locally creating two: .mdb and .accdb files, adding some dummy data inside them.
Do they work using the two connection strings i provided above?
Replied 13 Jun 2016 12:55:16
13 Jun 2016 12:55:16 MX Addict replied:
Both files created with some dummy data. Both strings not working

Replied 13 Jun 2016 13:01:38
13 Jun 2016 13:01:38 Teodor Kuduschiev replied:
Could you please translate the error message in English?
Replied 13 Jun 2016 13:06:50
13 Jun 2016 13:06:50 MX Addict replied:
The provision can not find. possibly this is not installed properly [google translation]
Replied 13 Jun 2016 14:13:18
13 Jun 2016 14:13:18 Teodor Kuduschiev replied:
So are you using a 64bit windows with 32bit version of MS Office/Access?

Reply to this topic