database connection

[mb_chris]

hi everyone

I have a really tough problem to figure out. The problem is that I would like to create some sort of web app that would be only able to query a sql server or oracle database. The database engine would be running on a different server than the web server that would be running the app. its hard to explain but if you dont understand please let me know and i'll try to explain it better. The problem I have is that I dont know what to do this in. I thought of doing a Java Servlet and then I read some documentation on asp and maybe an active x control. I have alot of web development experience but this one is really making me think. If anyone has any input on how I should develop this please let me know.

Thanks

[rdoekes]

If both servers are in the same domain or workgroup or otherwise within one local area network, this is not a problem.

Just point your DSN to this other server and the connection should work.

If your database server it outside your domain located on a remote location, this is a little bit more complex. You could think webservices, or otherwise XML transfer between the two locations.

Hope this helps

-Rogier Doekes

[Ribeyed]

hi,
not tried and tested this but i have configured a simillar senario. My thinking is creating a VPN between the Database server and the web server, then connect through ODBC.