Results 1 to 2 of 2

Thread: data1 - Connect via ODBC

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    127
    Dear all at the moment I'm connecting to a db using the code below and the data component, normally
    called data1.

    I have been trying to conect to another db but this time using OBDC, but this time without success, also
    I'm using DAO 3.6.

    =============== Current Code ==================
    Data1.DatabaseName = "c:\windows\desktop\mydb.mdb"
    Data1.Connect = Access
    Data1.RecordSource = Me.txtSQL.Text
    ' We make the results visible
    DBGrid1.Visible = True
    Data1.Refresh
    ASPWIZARD

    http://www.aspwizard.co.uk

  2. #2
    Lively Member
    Join Date
    Jan 2000
    Location
    Dallas, TX
    Posts
    89

    data1

    What does your SQL look like? And also if you're using the data control, you can set it's properties at design time. And you don't neccssarily have to do it in code.
    ande211
    VB6 SP3

Posting Permissions

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



Click Here to Expand Forum to Full Width