Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Connecting to Access v 2.00


Message #1 by "StephenB" <stephenb@w...> on Wed, 27 Dec 2000 13:47:49 -0000
From

Surfree - Dvirs [mailto:dvirs@s...]





Hello,



> My Name Is Dvir and I Work In a Bank.



> I Bought Your Book - ADO 2.5 - Refference Hopping To Find a Solution



> About Using ADO (Visual Basic Or ASP) With MS-Access Version 2.00 ,



> But I' Did Not.



> I Will Be Very Greatfull If You Could Find Me a Solution To This



> Problem (What Do I Need to Write In The PROVIDER property and



> The CONNECT STRING Property)



>



> Thank You Very Much ,



>



> Dvir Shaket.









--- 

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 Imar Spaanjaars <Imar@S...> on Wed, 27 Dec 2000 14:56:29 +0100
Check out the following site to see how you should build a connectionstring 

for your Access database.



         http://www.able-consulting.com/ado_conn.htm



Basically what you need / want is an OLEDB for JET connectionstring which 

takes the form of:



oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=\somepath\mydb.mdb;" & _

"User Id=admin;" & _

"Password=;"



HtH



Imar



P.S. Did you read the book thoroughly enough? My copy shows lots of 

examples of connection strings.





At 01:47 PM 12/27/2000 +0000, you wrote:

>From

>Surfree - Dvirs [mailto:dvirs@s...]

>

>

>Hello,

>

> > My Name Is Dvir and I Work In a Bank.

>

> > I Bought Your Book - ADO 2.5 - Refference Hopping To Find a Solution

>

> > About Using ADO (Visual Basic Or ASP) With MS-Access Version 2.00 ,

>

> > But I' Did Not.

>

> > I Will Be Very Greatfull If You Could Find Me a Solution To This

>

> > Problem (What Do I Need to Write In The PROVIDER property and

>

> > The CONNECT STRING Property)

>

> >

>

> > Thank You Very Much ,

>

> >

>

> > Dvir Shaket.

>

>

>



---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript 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