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?
09-25-2002, 09:00 AM
Paul Clement
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.
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)
09-26-2002, 10:38 AM
Paul Clement
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)?
