Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Asp.net page into a vfp db
Message
 
To
16/06/2011 07:34:03
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
ASP.NET
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Web
Miscellaneous
Thread ID:
01514343
Message ID:
01514644
Views:
30
>>Thanks Michel, the ASP pages are on. I think that the real problem is registering the odbc driver on the server.
>
>First think I would do is to make sure that the site can respond to .asp pages. Simply do a hello page with no data access. If it works, that you can proceed to step 2 to investigate on the data access.

I've just checked and if I take out the data access parts it will work fine.
at the top of the asp page I have this line
-#include file="connection.asp"
and in the connection.asp page
Dim objConn, ConnStr, dbLoc
Set objConn = Server.CreateObject("ADODB.connection")
dbLoc=server.mappath("\portal\dbfinfo\agweb.dbc")
ConnStr= "Driver=Microsoft Visual FoxPro Driver; " + _
      "UID=;SourceType=DBC;SourceDB=" + dbLoc
objConn.Open ConnStr
~M
Go raibh maith agat

~M
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform