Results 1 to 2 of 2

Thread: using sqldataadapter

  1. Oct 29th, 2003, 05:03 AM #1
    martialdc
    martialdc is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2002
    Location
    Pilipinas
    Posts
    441

    using sqldataadapter

    I use SqlDataAdapter to my VB.NET project.

    I drag a SqlDataAdapter1 to a Form and I configure it.

    The default OLE DB Provider of SqlDataAdapter is Microsoft OLE DB Provider for SQL Server but I select Microsoft Jet 4.0 OLE DB Provider as my provider but I encounter this message!

    "The connection you have created does not work witht he current adapter."

    My PC is not connected with network. Kindly help me what do? Can I still use Microsoft Jet 4.0 OLE DB Provider?
    Reply With Quote Reply With Quote
  2. Oct 29th, 2003, 06:37 AM #2
    nswan
    nswan is offline
    Fanatic Member
    Join Date
    Oct 2000
    Location
    Reading, UK
    Posts
    870
    use oledbdataadapter for connecting to access database's. SQLdataadapter is only for connecting to SQL 2000 and SQL 7 databases.
    www.vb-tech.com
    .Net Freelance Development
    http://weblog.vb-tech.com/nick
    My blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width