p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: How do establish a connection to a FoxPro table?


Message #1 by Tara Hull <taradawnhull@y...> on Thu, 14 Dec 2000 08:28:45 -0800 (PST)
I am very new to ASP and I am trying to connect to a

Foxpro table (.dbf)



This is the code I tried:



objConn.Open "Provider=SQLOLEDB;" & _

               "Data Source=C:\Lois\Probills.dbf;" & _

               "Persist Security Info=False"



Can someone please help me!



Thanks



=====

Tara D. Hull

Greenberg & Associates

MicroComputer Programmer/Application Developer

Mobile/Voicemail/Pager  (xxx)xxx-xxxx





--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #2 by "Mike H." <mhaining@p...> on Fri, 15 Dec 2000 17:12:16 -0000
Hi Tara,

I am using a Visual FoxPro database, but I am connecting to it via ODBC.

This is supposedly somewhat slower, but I have not been able to find a

connection string to go thru OLE-DB directly. Here is what I use:



dim strData, connData

strData = "Provider=MSDASQL.1;" & _

			"DATABASE=DataBaseName;" & _

			"DSN=VFPSystemDSNname;" & _

			"User ID=adminid;" & _

			"Password=adminpw"

set connData = Server.CreateObject ("ADODB.Connection")

connData.Open strData



Hope this helps some.

Mike H.



--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com


  Return to Index