Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC-ASP-ODBC-Data
Message
From
22/09/2002 10:19:28
Fausto Garcia
Independent Developer
Lima, Peru
 
 
To
05/09/2002 15:52:34
Fabian Belo
Independent Developer
Argentina
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00697239
Message ID:
00703157
Views:
17
Hi Fabian,

When I started developing web apps that worked with VFP data I faced several really *weird* problems similar to the one you refer. A friend told me once to try working with a DSN-less approach, something like:

1) Define an application variable to store the connection string the web app will use:
Sub Application_OnStart
   Application("APP_ConnStr") = _
      "Driver={Microsoft Visual FoxPro Driver}; SourceType=DBC;" & _
      "SourceDB=X:\Path_where_your_VFP_Data_Resides\YourDB.Dbc;Exclusive=No;"
End Sub
2) Refer to this application variable wherever you need to stablish a connection, for example:
   'At any ASP page place...
   Set loCnn = Server.CreateObject("AdoDb.Connection")
   loCnn.ConnectionString = Application("APP_ConnStr")
   loCnn.Open
   '...
HTH,
Solo se que nada se

Fausto J. Garcia Pino - MCSD.NET
.NET, Oracle, Tronador & Fondismo!
Previous
Reply
Map
View

Click here to load this message in the networking platform