• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

How to connect to Mysql on another server from javascript on server with no server side.

I am developing a website on an IIS server that is not allowing any server side tools.  I would like to be able to connect to a database. Most preferable is to keep every thing on this IIS server.  Would be nice to have an access database sitting in a directory somewhere on the web server, but don't believe it is possible due to no server-side.

I have another server running apache, php, and mysql I could connect to if the above is not possible.  If using this alternate route, how would I connect to the remote server to execute SQL queries?

Suggestions?
0
jrlanders
Asked:
jrlanders
  • 2
1 Solution
 
DVation191Commented:
Maybe someone else can chime in, but as far as I'm aware, it's not possible to connect to a SQL/MySQL database using javascript as js is a client side scripting environment.

As for the apache/php/mysql setup, you're still in the same situation - you're not going to be able to connect to the MySQL instance using just JavaScript from the IIS host.
0
 
jrlandersAuthor Commented:
Thanks DVation191 for your reply.

Question / Suggestion?

So if I cannot hit a data base locally or remote to the web server I am working with,  what is the best way to pull data from a file to display complex data elements?

Let me see if I can give you an example:
I need to display an image of a facility, address, staff that work at that facility, phone numbers, specific departments in that facility, and the staff in that department, details about the department, and equipment in each department!  Whew!

I can do it with XML... just it seems to messy and hard to organize the relationships.

Thoughts?
0
 
DVation191Commented:
jrlanders,
Sorry I didn't see your follow up question until now. I have limited experience with AJAX, but maybe this can help you?
http://www.w3schools.com/ajax/ajax_database.asp
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now