vs.net problem


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: vs.net problem

Hybrid View

  1. #1
    onderaydogan Guest

    vs.net problem


    i am not quite sure this is the place to ask this question and don't know
    whether it is a stupid question but anyway...

    i am trying to get familier with vs.net and i am trying to prepare a dataset
    with Data Adapter Configuration Wizard. I am following the steps from the
    Help of vs.net.
    i select the pubs database of a remote sql server ( i have been developing
    a lot of applications against that sql server and no problem up to now! )
    and i build the sql statement but i get an error saying

    Invalid object name 'titles'

    i did everything i can foresee like trying dbo.titles but noway!

    Anyone faced this thing?

  2. #2
    Paul Clement Guest

    Re: vs.net problem

    On 24 Sep 2002 23:53:17 -0700, "onderaydogan" <oaydogan@borusan.com> wrote:


    i am not quite sure this is the place to ask this question and don't know
    whether it is a stupid question but anyway...

    i am trying to get familier with vs.net and i am trying to prepare a dataset
    with Data Adapter Configuration Wizard. I am following the steps from the
    Help of vs.net.
    i select the pubs database of a remote sql server ( i have been developing
    a lot of applications against that sql server and no problem up to now! )
    and i build the sql statement but i get an error saying

    Invalid object name 'titles'

    i did everything i can foresee like trying dbo.titles but noway!

    Anyone faced this thing?

    Could this be a case-sensitivity issue with respect to the table name or perhaps a permissions issue
    for the user that you are authenticating with?

    You might want to indicate which data provider you are using.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    onderaydogan Guest

    Re: vs.net problem


    i am using sqldataprovider and i am using the same connection properties that
    i use with VB6 data environment! Everything is okay with that.
    The Sql Server that i am trying to connect use 'sa' as a uid and no windows
    authentication.
    strange problem! i do not know if it is related but the pc i am using for
    this test is a Turkish Win2000 Prof. box.

    Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote:
    >On 24 Sep 2002 23:53:17 -0700, "onderaydogan" <oaydogan@borusan.com> wrote:
    >
    >
    > i am not quite sure this is the place to ask this question and don't know
    > whether it is a stupid question but anyway...
    >
    > i am trying to get familier with vs.net and i am trying to prepare a dataset
    > with Data Adapter Configuration Wizard. I am following the steps from

    the
    > Help of vs.net.
    > i select the pubs database of a remote sql server ( i have been developing
    > a lot of applications against that sql server and no problem up to now!

    )
    > and i build the sql statement but i get an error saying
    >
    > Invalid object name 'titles'
    >
    > i did everything i can foresee like trying dbo.titles but noway!
    >
    > Anyone faced this thing?
    >
    >Could this be a case-sensitivity issue with respect to the table name or

    perhaps a permissions
    >issue
    >for the user that you are authenticating with?
    >
    >You might want to indicate which data provider you are using.
    >
    >
    >Paul ~~~ pclement@ameritech.net
    >Microsoft MVP (Visual Basic)



  4. #4
    Paul Clement Guest

    Re: vs.net problem

    On 25 Sep 2002 12:06:28 -0700, "onderaydogan" <vb.@127.0.0.1> wrote:


    i am using sqldataprovider and i am using the same connection properties that
    i use with VB6 data environment! Everything is okay with that.
    The Sql Server that i am trying to connect use 'sa' as a uid and no windows
    authentication.
    strange problem! i do not know if it is related but the pc i am using for
    this test is a Turkish Win2000 Prof. box.

    Yeah, language versions sometimes show odd problems. Have you tried any other tables in the pubs
    database (or any other SQL Server database)?

    Can you connect via VB.NET code?


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  5. #5
    onderaydogan Guest

    Re: vs.net problem


    yes Paul, i can manage the same things within VB code with ADO.NET
    i am quite sure, there is something about Visual Studio!

  6. #6
    Paul Clement Guest

    Re: vs.net problem

    On 2 Oct 2002 00:08:11 -0700, "onderaydogan" <vb.@127.0.0.1> wrote:


    yes Paul, i can manage the same things within VB code with ADO.NET
    i am quite sure, there is something about Visual Studio!

    Did you confirm whether it was just the Titles table or does it happen with all tables?


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center