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
noeltulleyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.