|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Accessing data via a web server |
| Author |
Message |
|
|
| Posted : 2006-07-19 18:27:39 |
I am in the process of trying to ease various headaches we have to do with the way the data is accessed by our customers via our web site.
Currently our database resides on a Novell server, and we have no plans to change that.
The current web server is IIS 4 - which I would like to upgrade to IIS 6.
All the users who can get access are registered on the web server (Username / Password) and at present they also need to be set up on the Novell server, with the same UID / PWD. This is proving to be an administrative burden, and it also means that the user has no control over the password and uses additional licenses on the database server.
I am trying to configure the FlexODBC driver / ASP pages / IIS / anything else that might have a hand in the authentication system between servers, to use a single "back end" UID / PW.
(Note : If I set the Anonymous Access user to a suitable user, it works, but we have to authenticate our users, to give each customer specialised pages and a different view into the data).
In summary, I want to force the ODBC driver to use a single UID /PWD to gain access to the database on a separate server, when running on an IIS server and called from an ASP page / script, regardless of who the logged in user to the web server might be. I can use DSN, or DSNLess connection strings (we use DSNLess at present). |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-07-19 23:38:49 |
| Once you upgrade to Windows Server 2003 and IIS 6.0 you will need to move the DataFlex datafiles to the web server. From there is just a matter of setting the security of the FlexODBC program folder to all rights for the authentication users group. The Windows OS will then perform the task of authenticating the user and allowing access to the DataFlex ODBC driver. |
|
|
|
|
|
| Posted : 2006-07-21 22:25:52 |
I'm sorry, but I think one of the major points here has been missed. I cannot simply move the data files to the web server as they form the basis of our internal call control system. I have to find a way to access them from where they are at present.
It seems to me I should be able to set the FlexODBC user to someone with the correct rights in the ODBC control panel settings (the DSN settings) - but when I try this, regardless of the user name I pick, I get a refusal to access any data at all from the driver.
A clue as to why is seen when using a DSN set up with a username / password to look at data with the C++ demo program. If I try like this, I get the login box up, and again, regardless of which user I try, I get the login box back. If I remove the user / password (make them blank) I can get at the data.
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-07-22 10:12:09 |
I suggest you copy the datafiles to the web server and get everything going first. You can then try to do whatever you want, however the point of using Windows authentication is so the user doesn't need to login into FlexODBC and use a password.
See: How do I use FlexODBC Security? for more on using passwords. |
|
|
|
|