<i><font color="#663300">
2. What will the remote views use to access the data if the connection in the database does not have the required userid and password fields?</font></i>
<i><font color="#663300">
Two answers here...
1. If your views are set to share a connection, once they are logged in, the connection is established, there are no futher connections/logins needed.
2. If you use NT Authentication (which is the best choice) then the user never sees the SQL Login, nor is an ID/Passwd needed and SQL server asks the domain controller to authenticate the user. Once SQL recieves this authentication it grants rights to the user accordingly. (Here you should also use shared connection views.
There are some other options, espesially with 7.0, but I'll wait till you ask me those questions.
BOb
</font></i>
I use the userid and password that the user submits to establish the connection with a SQLCONNECT. I store the connection handle in a varaible that is accessible throughout the application. Is it somehow possible to use this handle number with the views?
I am trying to understand what you are getting at. This is what I have done.
I went into the Tools>Options>RemoteData and checked the share connection check box.
I created a system datasource, with the userid blank.
I created a database connection which uses that datasource, but also leaves the userid and password blank. (the idea being not to store this information anywhere)
I create new views (with the new sharing connection checked), two using the connection and two using the data source. When creating a view using the connection or the datasource, the Oracle ODBC Driver Connect dialog box appears and asks me for the userid and password. I enter the userid and password and add whatever tables suit my fancy.
I execute a SQLCONNECT, with a good handle returned..
I try to browse one of the views and am confronted by the same Oracle ODBC Driver Connect dialog that appears during the creation of the views.
I add the userid and password information. I try to browse the next view, and again am confronted by the Oracle ODBC Driver dialog.
So, I am completely unclear about what you are saying should be happening. How do I get the remote views in my VFP database to use the connection established with the SQLCONNECT?
The choice of authentication techniques is not mine.
Devman
mdevlin .AT. ajdebruin .DO.T com
©2002 Mike Devlin |
