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?

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)

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)

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)

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

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)