|
Prev Next
Back to the top of the FAQ
Q.
Beginner's Step by Step with ODBC.
A.
If you are running the software for the first time, here are the steps
you need to take to protect a directory using an ODBC datasource:
First make sure you can access the directory you wish to protect freely (via http://...),
without any IIS/NTFS protections. Use Netscape for this, since IE will sometimes
log you in with your current login without telling you.
Make sure Basic Authentication is
turned OFF in IIS Management console,
otherwise it will conflict with AuthentiX Basic Authentication. Make sure
Allow Anonymous is ON. NTCR (Integrated Windows Authentication in Windows 2000) can be ON or OFF.
-
Run the AuthentiX Windows dialog on the console.
-
You will see this screen
-
Click Access,
then Add the directory to be protected.
You will see this screen.
[http://www.flicks.com/authentix/discover/access/accedit.htm]
-
Click on the "By ODBC" tab. Check the Enabled checkbox, and click the "By Select Statement" button.
-
Click the Datasource button and select the DSN. Make sure it is a system DSN, by picking
from list in the Machine Data Source tab, and not the list in the File Data Source.
Here is how to set up a system DSN.
[http://www.flicks.com/fbeta/systemdns.htm]
If the DSN is not working, because for instance you are trying to access a database on another machine,
go here to see how to use SQLOLEDB.
-
Set the Table, Username and Password fields.
-
Click Test to make sure it works.
OK,ok,ok etc. Even if this Test passes, if you did not use a
System DSN
[http://www.flicks.com/fbeta/systemdns.htm]
IIS authentication will fail.
-
Use a browser to go to the URL that the directory is accessed from,
using IIS. It should prompt you for your username and password in the database.
-
Type a username and password in the database to gain access.
-
Refer to the
ODBC FAQ.
Also see here.
Note: You can administer and setup ODBC via a webbrowser
using the remote administration. However you need to know
the structure of the database, and the exact form of the Connect String for the System DSN.
Selecting the Connect String from the console is conveniently easy and
straightforward.
Set up the DSN from the console, or have your ISP do it for you.
Back to the top of the FAQ
Prev Next
|
|