|
hi
I connect to a mssqlserver2000 database(windows authentication or user name and password)
The connection is OK.
But when I try to generate a dataset I receive the following message.
"Invalid object name 'dbo.employee'"
I tried each database installed with sqlserver2000 and I also created a simple database but it is in vain. Each time I received the same message.
In query analyzer I can use sql statements and I can query the data. There is no problem here.
The problem is between vb.net and sqlserver.
I use querybuilder button in data set generating wizard,then I select the fields and then I click the next button and I receive these message.
"Invalid object name 'dbo.employee'"
Would you please help me
xp pro servicepack2
sql server 2000
mdac 2.8 sp1
thanks
|
|
|
Here is the Connection string connecting the SqlServer
Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=;Initial Catalog=;Data Source=
Password->if you set password for the database just give the password here
User ID ->It is taken from from Users in SqlServer,Just check out the users from the users
Initial Catalog -> DataBase Name
Data Source -> SqlServer Name
|
|
|
|
|
|
|
|