Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unhappy Unanswered: data shaping on dBASE tables

    hi there people!

    please do help me...
    i'm trying to use VB 6's data reports to display data from dBASE tables.
    i understand to use the grouping functions, i need to do a shape on the
    recordset but i keep getting this error...

    [runtime error -2147217805
    Format of the initialization string does not conform to the OLE DB specification.]

    here's my code..

    Dim cn as new ADODB.Connection
    cn.open (Provider=MSDataShape; Data Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\dbaseFolder; Extended Properties=dBASE IV;)

    please help!!!

    or is there any other way of doing the same thing and to use
    the data reports to displayed grouped data?

    thanks a million!
    Sze Huat
    =(

  2. #2
    Join Date
    Jan 2003
    Location
    New York
    Posts
    160
    Try this
    Data Source=C:\dbaseFolder\filename.dbf;
    instead of
    Data Source=C:\dbaseFolder;
    Beyond Limitation

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    Originally posted by vextout
    Try this
    Data Source=C:\dbaseFolder\filename.dbf;
    instead of
    Data Source=C:\dbaseFolder;
    thnks for replyin...
    but i still get the same error...

    =(

  4. #4
    Join Date
    Jan 2003
    Location
    New York
    Posts
    160
    sorry

    i started trying it out, i got the same error

    have no solution

    i have to do something with dbase as well

    export sql to dbase from vb (w/o dts)

    trying alternatice ways
    Beyond Limitation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •