[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Uploading FP2000 database

I have created a simple database that works fine on my PWS/Win98 but does not work when uploaded to my remote IPP. They use a Zeus with ASP support but say they cannot give ODBC connection. Hence I have been told to connect 'on the fly'. I understand I must insert some code - but what and where (is it in the global.asa file?) I don't know. The database I'm connecting to is Access.

Thanks your help

Noel K Tulley
0
noeltulley
Asked:
noeltulley
  • 2
1 Solution
 
jgoodierCommented:
are you using a dsn on your home pc?
are you using front page 2000?
what is your connect string?
you don't have to use a global.asa.
0
 
noeltulleyAuthor Commented:
1. No - my IPP does not support ODBC conexions (though it does support ASP - (I've checked it with the <%=now()%> function).
2. Yes, I use fp2000
3. fp_sDataConn="Database1" (i assume this is the connex string)
4. Ok

What I really need to know is:

should FP2000 put it all together for me so that when I upload it should work. Thats the impression I get and nowhere does it say in the manual that extra code has to be added. Is it perhaps just my IPP thats at fault?

Thanks for your interest in my plight...

noel tulley
0
 
jgoodierCommented:
It sounds like you just need front page to add the databases connection to the web server.  
Open front page, go to open web, and type in your url.
then, find your access database on your local drive and copy and paste it to front page.  It should prompt you to "create a connection"
If this doesn't happen, your ipp does not support fp 2k extensions.  then you will have to use a dsnless connection and learn a bit of asp.
Let me know if  you want that code for asp.
0
 
zs6phdCommented:
Try this code from www.activeserverpages.com:  It contains more than you asked for but the code dealing with the database may help you:

<html><head>
<TITLE>securityloginrespond.asp</TITLE>
</head><body bgcolor="#FFFFFF">
<%
dbname="/learn/test/secret/customsecurity.mdb"
myname=request.form("username")
mypassword=request.form("userpassword")
set conntemp=server.createobject("adodb.connection")
cnpath="DBQ=" & server.mappath(dbname)
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
sqltemp="select * from users where user='"
sqltemp=sqltemp & myname & "'"
set rstemp=conntemp.execute(SQLTemp)
If rstemp.eof then%>
      we don't have a user named <%=Myname%> on file!<br>
      Try <A href='securitylogin.asp'>Logging in</a> again
      <%response.end
end if
If rstemp("Password")=mypassword then
      session("name")=rstemp("user")
      session("securitylevel")=rstemp("securitylevel")
      response.write "Security Level=" & session("securitylevel")
else%>
      Password Unrecognized<br>
      Try <A href='securitylogin.asp'>Logging in</a> again
      <%response.end
end if
rstemp.close
conntemp.close
set rstemp=nothing
set conntemp=nothing
%>
</body></html>

0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now