|
I believe that how changes are gathered varies a lot.
But in your case, why do you separate different modifications to different files instead of gathering all modifications to a single file? That way you could ensure that everything is run (only once) and that the execution order is correct (sometimes this can be an issue for example with foreign keys, triggers etc). This script cold be run using osql.
|
|
|
|
|
I'm trying to connect to my sql 2000 database "mydatabase" using JDBC for SQL Server 2000, but I failed.
I'm using IReport to connect to the database and I added the driver for sql server 2000. I made sure it runs under mixed mode (i.e: windows and sql server authentication)
I created a login user (ASPNET) user and granted permissions to him on the database (without any passwords).
The url that I use for connection is jdbc:microsoft:sqlserver://localhost:1433/mydatabase
username:ASPNET and I don't enter any passwords.
error: Login failed for ASPNET. The user is not associated with a trusted sql server connection.
When I don't enter any username or password, he tries to connect using my computer's credentials but also fails.
I don't know what's wrong.
I tried everything but I failed to connect to it.
I even installed sql server 2000 sp3 on the computer but to no avail.
Am I missing something?
How am I supposed to connect to the database?
sorry for taking so long..I hope someone could help me out.
modified on Monday, February 23, 2009 7:27 AM
|
|
|
|
|
I think what you're seeing here is a trusted connection issue. You're not connecting to Sql Server using a username and password but instead using your windows account. You'll need to add the domain account as a user to SqlServer.
Also, its worth just making sure your account isn't locked (3 wrong log-ins etc) as this produces exactly what you describe.
Regards,
Rob Philpott.
|
|
|
|
|
ok, I've just created a login user with my computer name and its domain and I specified the authentication as Windows Authentication coz otherwise a password will be required and I set the default database as "mydatabase".
This time the error is: cannot establish connection. Cannot open database requested by login. Login failed for user domain/username
Should I restart sql server or what?
|
|
|
|
|
I think its your domain and the logged on account you want to add, not the computer name. You'll then need to add that user to the Sql Server so they can access the server, and add the permission to the database you're using as well.
Regards,
Rob Philpott.
|
|
|
|
|
oh I'm sorry, I meant to say the logged on account (mine is the same as the computer name) I'm sorry for mixing things up.
Anyways, I did that, but still login failed.
Any ideas why??
|
|
|
|
|
hi
i have a report viewer containe parameter, i tried to get the parameter values from a web service but i could not because the web service return a sxd:schema not dataset. So i decide to pass those values into the parameter from regular aspx page and it worked, but i still have small problem
the dropdown list is selecting all values sperated by ','
what should i do to prevent this
thank you
|
|
|
|
|
Since this is ASP related problem, I believe that you would get much better help in ASP.NET forum[^]
|
|
|
|
|
Good Day All
i have a table that carries a Field that has data like this
10101010101010
Now the Function that adds this 1's and 0's is working like this. If its selected insert "1" else "0", So if i can interpret the above if will be
1 3 5 7 9 11 13
the only thing that am interested in is "1's", if i can display their Position in a SQL Query i will be happy
i want to take these Values from a SQl table and Bind them to a Gridview. Remember the Number of Zeor's can increase , but the Limit is 63 including the "1's" and "0's".
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
If possible, I think you should change the structure and use a child table to represent those values. It would be then far easier to handle the data.
However, if you want to have all 63 possible values in columns where the correspinding bit is on, you could use something like:
select convert(int, substring(data.field, 1, 1)) * 1,
convert(int, substring(data.field, 2, 1)) * 2,
convert(int, substring(data.field, 3, 1)) * 3,
convert(int, substring(data.field, 4, 1)) * 4,
convert(int, substring(data.field, 5, 1)) * 5,
convert(int, substring(data.field, 6, 1)) * 6,
convert(int, substring(data.field, 7, 1)) * 7,
convert(int, substring(data.field, 8, 1)) * 8
...
from (select convert(varchar(63), 10101010101010)
+ replicate('0', 63-len(convert(varchar(63), 10101010101010))) as field
) data
|
|
|
|
|
hi Mika
Thank you for your response, i have came with the Following and it seems to work.
declare @S as nvarchar(63)
set @S = '10101010101010'
declare @NS as nvarchar(128)
set @NS=''
declare @Len as int
SET @Len = LEN(@S)
declare @Counter as int
SET @Counter = 1
WHILE @Counter < = @Len
BEGIN
if (SUBSTRING(@S,@Counter,1)='1')
set @NS = @NS + ' ' + convert(nvarchar,@Counter)
SET @Counter = @Counter + 1
END
select @NS
What do you think about it
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
That should be okay. The idea is the same as in the statement I posted and if you can use T-SQL instead of plain SQL, using a loop is easier.
|
|
|
|
|
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
You're welcome
|
|
|
|
|
Dear all,
I am accessing a database which is running on an SQL Server 2008 machine via SQL Server Management studio 2008 from a remote machine. I am using SQL authentication and I am able to do all the query and database management work.
However when I try to make use debugging I get an error stating unknown username or bad password. I did not manage to find any solution for this error. Have you ever encountered such a thing?
Any potential solutions will be greatly appreciated!
Many thanks
|
|
|
|
|
|
Hi evryone
I need Websit that compare between SQL server - Oracle - Access
(Query...Connection...SP.. )
than'k for any help
|
|
|
|
|
Try googling 'Comparison of relational database management systems'
Regards
David R
|
|
|
|
|
Just posted a link to a wiki article: 'Comparison of relational database management systems'
|
|
|
|
|
|
Thank's
but i need more SQL Query's Comparison
|
|
|
|
|
Since you know what you're looking for, why don't you google with those keywords that are interesting to you.
It's impossible to give you similarities or differences between three different databases. For example Oracle SQL reference is ~1500 pages and I think that over 50% differs from SQL Server (in one way or another).
|
|
|
|
|
I've recently arrived at a firm that has well over 30 databases for various applications. The downside is that there has been no documentation on any of the systems. I've tried to encourage the DBAs and developers to proactively document the purpose of tables, stored procs,etc.. but this has been slow and coming. I've been looking at a few tools from RedGAte, but I'm not sure what else is available. Is there a good process or set of tools that can be used to document a database along with the means to inventory the details for a CMDB?
Thanks.
DrMaltz
"The Code King"
|
|
|
|
|
I believe this situation is quite familiar to many (most?) of us The only good process I know is exactly what you mentioned, do it proactively when everything is clear in mind. Doing the documentation later is always somewhat gathering the pieces.
About the tools, I think RedGate makes good products, but also this: http://www.dbdesc.com/[^] could be worth to look at.
There are few areas these tools don't cover so if you use a tool to generate the documentation, I would still try to manually include for example:
- E/R diagrams per subsystem (especially in larger dtabases)
- if a table/view has enumerated values etc. in a column, what do they mean
- same for procedures
- privilege/role maps and so on
Hope this helps,
Mika
|
|
|
|
|
hi everyone , im using sqlite and i have a problem where, well i use a lot of delegates to make updates or inserts in the database and sometimes they collide and the database locks itself when writing is being done
i managed to "fix" this by using a lot of labels so everytime i get the exception "database is locked" i thread.currentThread.sleep, for 3 seconds and then my label sends it to the beginning of the try statement, kinda like this
retry:
try
{
}
catch
{
System.thread.currentThread.sleep(3000);
goto retry;
}
so with this i got it to work "kind of " simultanoulsy but i went here http://www.sqlite.org/faq.html[^]
and i see this sqlite3_busy_handler and SQLITE_BUSY stuff, i have read it like 100 times and still i dont have a clue how to use it or how to get it or anything about it, anyone of you can point me in the right direction?? appreciate the help
Im using c sharp application by the way
|
|
|
|