ddf without file location

[sleeplessnights]

Hi,
I have got a database that has a ddf file without
locations of the tables defined, this because it has
different locations for differnet versions of the
table for instance
table name is 0001 and file is 0001_01.dat and
0001_2.dat and 0001_3.dat
when in version 1 the btrieve file is 0001_01.dat
when in version 2 the btrieve file is 0001_02 ea...

I think the file location is sent in VB to the ddf
while accesing the table could enyone tell me how
I could resolve this in VB6

Kind Regards

Kevin

 

[SQLBill]

A ddf file? What's that - it's not any SQL Server file extension that I recognize. What version of SQL Server are you using?

-SQLBill

Posting advice: FAQ481-4875

 

[sleeplessnights]

a ddf file is a file that contains the information of btrieve data files

the question is for btrieve data files under pervasive sql 2000 server odbc connection

i think it should be something like

Private Sub .....()
Dim rsPriorities As ADODB.Recordset

Set rsPriorities = New ADODB.Recordset
With rsPriorities
.ActiveConnection = "Provider='pervasive ODBC Engine interface';" & _
"DataSource='C:\Temp\0001_01.dat';"

.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Source = "SELECT * FROM 0001"
.Open
End With

 

[sleeplessnights]

But still the question remains how to edit or send or link
the 0001_01.dat file to the table 0001 in VB6 ADO
or 0001_02.dat file to the same table this in a VB prog

kind regards

Kevin

 

[SQLBill]

Thanks for the explanation. I won't be able to help as I've never dealt with btrieve data files or Persuasive.

Good luck, I hope you get your answer.

-SQLBill