Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting

Post new topic   Reply to topic
How To acces a .DBF database without DSN
View previous topic :: View next topic  
Author Message
oki
Newbie


Joined: 20 Sep 2005
Posts: 2

PostPosted: Sep 20th, 2005 02:21 AM    Post subject: How To acces a .DBF database without DSN Reply with quote

HI there..

There is anyone can help me.., i have some little problem with accesing database. i want to know how to accesing .dbf database without dsn procedure or with dsn but in sintax...
Back to top
View user's profile Send private message
dougthomas
Moderator


Joined: 27 Jul 2005
Posts: 271
Location: Essex, UK

PostPosted: Sep 28th, 2005 04:36 AM    Post subject: Reply with quote

Hi,

You could use something like:
Code:

Set db = New ADODB.Connection

strCon = "Provider=VFPOLEDB.1;Data Source=<your database.dbf>;Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE"

db.Open strCon


Regards
Doug
_________________
If you can see the light at the end of the tunnel, it probably means there's a Train coming.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Visual Basic Forum runs phpBB | Forum Template © iOptional
VB Resources | SSL | Visual Basic