Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2004
    Location
    Biddeford, Maine, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Where is the SqlClient data provider (VB .NET)

    I keep reading that there are two alternative data providers for SQL:
    OLE DB for SQL and the SqlClient. But, when I go to create a connection
    only the OLE DB for SQL provider is available.
    Do I need to purchase some other Microsoft product?
    Where is the data provider for SqlClient ?

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is the SqlClient data provider (VB .NET)

    System.Data.SQLClient (See graphic of Object Browser)

  3. #3
    New Lounger
    Join Date
    Feb 2004
    Location
    Biddeford, Maine, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is the SqlClient data provider (VB .NET)

    Thank you, I am very pleased to have someone to talk to.

    I have object browser and I can find
    SqlClient and I have used SqlConnection in developing a little program in Visual Studio .NET / VB .NET
    on my development machine ( Windows XP ). Howumsoever, when I try to deploy my program to
    a Windows 98 target machine ( on which I have installed MDAC 2.8 ) - it runs - but it fails to open
    the MS SQL internet hosted database service that we are renting commercially.
    In trying to troubleshoot this problem - I have downloaded "SqlPad" onto the target Windows98 machine
    and I am trying to connect this. When I try to create a connection on the target machine the only
    provider that is offered is "OLE DB for SQL" - and when I try to set this up and test it - it fails -
    it can't open the internet database either!.

    Now, this got me thinking - so I went back to my development
    machine - and in the VB code - I have done the Import SqlClient and coded (VB.NET)
    SqlConnection and SqlDataAdapter and SqlDataAdapter etc - and it runs on the development
    machine - I have uploaded/downloaded records to our hosted database on my development
    machine. But, when I look on my development machine at the connection - I find I have
    used "OLE DB for SQL" - even on my development machine - this is all that is offered!
    So this is the impetus for my question. Even though the VB code is using SqlClient classes,
    the connection provider driver - still seems to be "OLE DB for SQL" - there is nothing
    else in the Wizard offered list that seems to relate to an MS SQL server at all.
    Shouldn't there be another provider/driver - specific to supporting the SqlClient classes?
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is the SqlClient data provider (VB .NET)

    Wow, Mike - that's a tricky one!

    The vast majority of my .NET experience is with web applications so I'm not very familiar with some of the challenges you're experiencing with VB.NET.

    I'm curious - which connection list are you referring to? Do you mean the "Data Link Properties" dialog, used for building Connection strings? If so, I believe this is correct - the SQLClient uses the OLEDB for SQL driver. There should not be any additional drivers needed.

    As for your Windows98 box still not talking to SQL, this sounds like a driver version issue. You may want to check with the MSKB to see if there are any known issues with Win98 and SQL Server.

    (By the way, I assume you've checked the .NET Framework on the Win98 box to make sure it's the same version - i.e. 1.1.4322?)

    Hope this helps!

  5. #5
    New Lounger
    Join Date
    Feb 2004
    Location
    Biddeford, Maine, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is the SqlClient data provider (VB .NET)

    Hi, Mark: Thank you - I am happy to have you say that you think that
    the "OLE DB for SQL" provider ( yes I am talking about the: "Data Link Properties"
    dialog, used for building Connection strings ). This gives me reinforcement
    that I haven't missed something - that this is the only SQL provider available
    for the SqlClient (SqlConnection, SqlDataAdapter, and SqlCommand) classes.
    And !!! More good news !!! I've got past my problem of SqlPad and my
    development program not being able to connect to my MS SQL host !!!
    It turned out to be our Firewall ! I've been working this morning with our
    ITS Firewall guru - and he has enabled ports 1433 TCP and 1434 UDP
    for our whole installation - ( outgoing connections can be made but
    incoming connections are still - intentionally - blocked ).
    And, now SqlPad and my test program are both working !
    Hoo-rah !!! Hoo-rah !!!
    Thanks,
    from Mike
    <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where is the SqlClient data provider (VB .NET)

    Mike - I'm glad to hear it was something "simple" like the Firewall. (I always find myself looking for the most complicated explanations when the problem is often caused by something much more obvious...)

    It's always exciting to work through these little challenges. Congratulations!!

Posting Permissions

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