|
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
|
|
| How do I use FlexODBC over the Internet? |
| Author |
Message |
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-02-26 13:06:42 |
Give read and write rights to the FlexODBC folder (normally C:\Program Files\FlexODBC Driver for DataFlex\) to the Anonymous web user IUSR_, ASPNET user and INTERACTIVE. This allows for creation and update of FlexODBC trace and message logs. To get access to the security tab do the following:-
-
In Windows Explorer go to "Tools | Folder Options..."
-
Select the "View" tab
-
In the list with "Advanced Settings", de-select "Use simple file sharing (Recommended)"
- Select "Ok"
- Now you can give the Anonymous IUSR_machinename all rights to the C:\Program Files\FlexODBC Driver for DataFlex\ folder using the Security tab.
Under My Computer | Control Panel | ODBC32, Choose the User DSN tab, select the DataFlex Test32 to Configure, copy the DFPATH entry, then exit the panel, choose the System DSN tab, choose Add, Choose DataFlex Driver then Finish, create a DSN called "DataFlex Test32" with the exact same path as the same name DSN under the File tab.
Copy the ASP script below into the c:\inetpub\scripts directory as df.asp.
Load Internet Explorer with the URL:
http://localhost/scripts/df.asp
You should see the list of dealer names from the ODBC sample files included with FlexODBC. If this is not what you see, please let us know.
<HTML><HEAD>
<TITLE>Flex/ODBC Live Data Demo</TITLE>
</HEAD><BODY>
<H2>Simple Example Query using a fetch loop</H2>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DataFlex Test32"
sql="select name,country,phone from dealers"
Set RS = Conn.Execute(sql)
%>
Here are the results from the query:<BR><I><B> <%=sql%></I></B><P>
<TABLE BORDER>
<% Do While not RS.eof%>
<TR>
<TD><% = RS("name") %></TD><TD><% = RS("country") %></TD><TD><% = RS("phone") %></TD>
</TR>
<%
RS.MoveNext
Loop
RS.close
Conn.close
%>
</TABLE>
</BODY></HTML> |
|
|
|
|