|
I have found what the problem was.
In my access database I had a field with a reserved name, and the command builder didn't sourounded it between []. So afther changing the field's name all things went ok.
protected internal static readonly ... and I wish the list could continue ...
|
|
|
|
|
in reply of moving database in sql Colin Angus Mackay once wrote :
Two ways I can think of.
1. Detach the database move the files and then attach at the other end. (You'll then have to wire up the logins again as the login ids will be different because they are stored in the master db)
2. Create a backup of the database, move the backup file to the new system, then restore the backup (you'll again have to wire up the logins to accounts for the same reasons given above).
now i'm havg same problem(i'm using sql server 2005 express edition), i hav tried both ways but at second server when i click database diagrams then it gives masseage that no valid owner of this database exits so can't work with database diagrams, in database properties i tried to enter different owners but didn't worked so what should i do??
further more what does this mean "(You'll then have to wire up the logins again as the login ids will be different because they are stored in the master db)" i just cant get it?
May God help u solv ur problems as well,thx in advance!!
|
|
|
|
|
|
what about this problem???
"now i'm havg same problem(i'm using sql server 2005 express edition), i hav tried both ways but at second server when i click database diagrams then it gives masseage that no valid owner of this database exits so can't work with database diagrams, in database properties i tried to enter different owners but didn't worked so what should i do??
further more what does this mean "(You'll then have to wire up the logins again as the login ids will be different because they are stored in the master db)" i just cant get it?"
May God help u solv ur problems as well,thx in advance!!
|
|
|
|
|
|
is owner of database and login same??
i made a database in lab and i want 2 work on same db 8 home(ofcourse the servers r differnt!), now when i attached the db(8 home) using object explorer then it normally attaches but "Database Diagrams" are not shown and cannot be worked with because it gives error that there is no owner of this database.
now i went to properties of the database then files and here i entered the same owner which is the default owner of database created at this server(8 home), but it doesn't accepts it and gives error of unregistered owner!!i tried other owner option that comes with browse button on that screen bt it didn't worked, so what should i do??
May God help u solv ur problems as well,thx in advance!!
|
|
|
|
|
shaz jazz wrote: 2
You mean "to", "too" or "two"?
shaz jazz wrote: 8
Are you really that lazy that you cannot type "at"? (It is the only word that fits, but it took me quite a few seconds to figure that out - Do you really expect a prompt reply when it takes people an unnecessary amount time to figure out what you are writing?!
shaz jazz wrote: r
"are" - You know how difficult it is to read this crap?!
shaz jazz wrote: u
Another weird abbreviation - Or are you now speaking Dutch?
shaz jazz wrote: ur
"your" or "you're"?? C'mon if you want to be taken seriously don't write this SMS style crap.
shaz jazz wrote: thx
THX is a quality standard for sound repoduction in cinemas and home cinema surround sound systems.
|
|
|
|
|
shaz jazz wrote: is owner of database and login same??
I don't know - that depends on your database.
If the user in the database has db_owner rights then the user will be the owner of the database, and that user must be associated to a login.
shaz jazz wrote: there is no owner of this database
Find out which user or users are marked as the database owners (they have db_owner rights on the database, or sysadmin rights over the whole server) and apply them on your database at home.
shaz jazz wrote: but it doesn't accepts it and gives error of unregistered owner
I've never seen this error before, So I'm guessing that you have to use the same user as the owner as where the database was created. You need to use ensure that user has a valid login and that user is granted the db_owner rights on your server at home. As it is a lab experiment, you might want to elevate that to sysadmin rights (which will give that user the right to do anything on the server, not just the database).
Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog
|
|
|
|
|
|
"(You'll then have to wire up the logins again as the login ids will be different because they are stored in the master db)" i just cant get it?
"
If you restore a db with its security context (It has users). You have to delete them from the db then add then again. If the users don't exist on the SQL box you have to create them.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
I have a dataview then i use rowfilter on htis dataview.
now i want to convert this filtered dataview to datatable or to dataset.Is there any method or i have to write my own logic.
Rickey
|
|
|
|
|
OK your slightly unclear here.
You can create a new datatable in your current dataset and "copy" the data from the dataview in there.
or
Create a new dataset, create a new datatable in the new dataset and you guessed it "copy" the data from the dataview in there.
DataSets are collecton holders of Tables, Views etc.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Hi Everybody,
I have a problem with the ADO.NET Connection which i use in my coding in VB.net 2005, to connect to the SQL Server 2000.
This connection works properly on a local machine , when i set the servername as localhost. but when i set the servename as the name of the server on which the SQLServer is installed, it doesn't work. whereas the ADO Connection does.(Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=" & ServerName)
The ConnectionString I'm using is "Data Source=" & ServerName & ";Initial Catalog=DatabaseName;Integrated Security=true"
Thanks, in advance
Regards,
Myra
|
|
|
|
|
|
hi,
the error is :
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Regards,
|
|
|
|
|
|
the connection timeout is equal to 15.
but how can I manage this error?
thanks,
|
|
|
|
|
|
thanks a lot for you.
I tried to add to the connection string : "Connect Timeout=30", and it worked.
|
|
|
|
|
I have two table with one-many relationship
table1 has 2 fields:type(int,PK),name
table2 has 4 fields:id(PK),type(int,FK reference field type of table1),content,shortDesc
How to write a SELECT statement that return rows from table1 join table2(via type field) but each row has a different value of type.
Result example:
--------------------------------------------------
| table1.type | name | content | ShortDesc | <--- FIELDS NAME
--------------------------------------------------
| type1 | name1 | content1| shortDesc1 | <---VALUE( ROW )
--------------------------------------------------
| type2 | name2 content2| shortDesc2|
Can anyone help me.Thanks in advance
|
|
|
|
|
|
Sorry but the statement don't return what i expected
Example:
type1 |Id1 | name1...
type1 |Id2 |name2...
because there's a one-many relationship between 2 table
Thanks anyway
|
|
|
|
|
ali33 wrote: Sorry but the statement don't return what i expected
However, it does return what you asked for.
You asked for: | table1.type | name | content | ShortDesc |
The SELECT statement returns: table1.type, table1.name, table2.content, table2.shortDesc
name only exists on table1, content and shortDesc only exist on table2
You are now asking for something with an example output of:
type1 |Id1 | name1...
type1 |Id2 |name2...
This is not possible because name is on table1. Therefore any output row that contains type1 must also contain name1. An output row containing type1 cannot contain name2
ali33 wrote: because there's a one-many relationship between 2 table
Yes, I know that - That is what I gave you. I suspect that either you did not give the full information when you asked the question or you do not understand the implications of the join scenario.
Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog
|
|
|
|
|
oh!sorry . I have a mistake
When I run your SQL statement the result return is:
type1 |Id1 | name1...
type1 |Id2 |name1... <---(sorry not name2)
But the result I expected is:
type1| Id1 |name1...
type2| id2 |name2...
type3| Id3 |name3....
(each type return only one ID of table 2,for all type)
Sorry for the mistake and can you help me.Thanks
|
|
|
|
|