ADO DSN-Less Connection to a Dbase IV dB

I was wondering if anyone might be able to help. I am a newbie and am trying to experiment with ADO connections to a dBaseIV database. I have tried using the help but I think I am a bit thick!! Thanx in advance!
VivekGAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Commented:
Try this as the connection string.

cnnConnection.ConnectionString = "CollatingSequence=ASCII;DefaultDir=<pathname>;Deleted=0;Driver={Microsoft dBase Driver (*.dbf)};DriverId=277;FIL=dBase IV;FILEDSN=C:\Program Files\Common Files\ODBC\DataSources\db4.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=600;SafeTransactions=0;Statistics=0;Threads=3;UID=admin;UserCommitSync=Yes;"
0
 
VivekGAuthor Commented:
Thanx!! It has been driving me absoloutly nutz for ages!! :)
0
All Courses

From novice to tech pro — start learning today.