|
You're confused by how Management Studio is presenting the information. The master database and the other system databases are placed under System Databases in the tree to keep them out of the way of your user databases, to both reduce noise and to slightly reduce the risk of accidental damage. As far as the server itself is concerned there is no separation, there is only a single namespace for all databases.
If you cannot log on to a database that is loaded into SQL Server but can log on to other databases, it typically means that you don't have permissions in that database. I haven't got space or time for a full treatment here, but basically your Windows user account or SQL Server logon has to have a logon to the server (under SQLEXPRESS\Security\Logons) and then a user account has to be mapped (under SQLEXPRESS\Databases\yourdb\Security\Users). The exact permissions for what you can do depends on the server roles that the logon is a member of, and the database roles that the user is a member of.
I also note you're using User Instances. This effectively creates a private instance of SQL Server just for this user. My understanding is that you cannot then see databases loaded by the parent instance, only ones loaded into the private instance using AttachDBFilename. I suspect that you want to remove the User Instance parameter from the connection string.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Mike... I already had all the permissions set up. Apparently the last thing you said about the user instances, that worked. I turned it to false and I connected up to the database. THANK YOU!
You are an amazing help, and I don't know why I didn't think of that before. I'm trying to learn C# and databases currently to supplement my C# studies, and this was something that was bugging me.
Much appreciated! Sometimes the most frustrating problems can be caused by the most simple of mistakes.
|
|
|
|
|
hello every1;
i have problem in connecting access with java
heres my code :
public class ElectronicCookBook extends javax.swing.JFrame {
private String url;
private Connection connect;
/** Creates new form ElectronicCookBook */
public ElectronicCookBook() {
initComponents();
try{
url="jdbc:odbc:cook.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
try {
connect=DriverManager.getConnection(url,"","");
} catch (SQLException ex) {
ex.printStackTrace();
System.out.println(ex.getMessage());
}
}catch(ClassNotFoundException ex){
ex.printStackTrace();
}
}
code throws following exception :
database name not found or no default driver specified.
i am a newer and working in netbeans
my project is a desktop application
please help me out
thanks all
|
|
|
|
|
These forums are primarily for Microsoft-based technologies. You would be better off asking your question on a Java forum.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I need help w/ setting DataTable.DataType of nvarchar
System.Nvarchar does not exist... does anyone know how to do this?
bulkCopy.WriteToServer throws an exception because it cannot put a string into nvarchar...
dc.DataType = System.Type.GetType("System.Nvarchar");
private void StartImport()
{
Stopwatch sw = new Stopwatch();
sw.Start();
SqlBulkCopy bulkCopy = new SqlBulkCopy("Server=ServerName;Database=test;Trusted_Connection=True;", SqlBulkCopyOptions.TableLock);
bulkCopy.DestinationTableName = "dbo.testSQLBulkCopy";
bulkCopy.WriteToServer(CreateDataTableFromFile());
sw.Stop();
txtResult.Text = (sw.ElapsedMilliseconds/1000.00).ToString();
}
private DataTable CreateDataTableFromFile()
{
DataTable dt = new DataTable();
DataColumn dc;
DataRow dr;
dc = new DataColumn();
dc.DataType = System.Type.GetType("System.Int32");
dc.ColumnName = "c1";
dc.Unique = false;
dt.Columns.Add(dc);
dc = new DataColumn();
dc.DataType = System.Type.GetType("System.Int32");
dc.ColumnName = "c2";
dc.Unique = false;
dt.Columns.Add(dc);
dc = new DataColumn();
dc.DataType = System.Type.GetType("System.Int32");
dc.ColumnName = "c3";
dc.Unique = false;
dt.Columns.Add(dc);
dc = new DataColumn();
dc.DataType = System.Type.GetType("System.Int32");
dc.ColumnName = "c4";
dc.Unique = false;
dt.Columns.Add(dc);
StreamReader sr = new StreamReader(@"d:\work\test.txt");
string input;
while ((input = sr.ReadLine()) != null)
{
string[] s = input.Split(new char[] { '|' });
dr = dt.NewRow();
dr["c1"] = s[0];
dr["c2"] = s[1];
dr["c3"] = s[2];
dr["c4"] = s[3];
dt.Rows.Add(dr);
}
sr.Close();
return dt;
}
|
|
|
|
|
Firstly, to get a type object for a built-in type is more simply expressed as just:
typeof( int ) I don't see why using typeof(string) wouldn't work for your requirement, but if you do have trouble, consider using System.Data.SqlTypes.SqlString instead.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Hi all,
I have populated treeview control based on logged in user's credentials under forms authentication. I have used cookies management. The next step is how to render the populated report on reportviewer control. I have tried with following code
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://servername/Reports");
ReportViewer1.ServerReport.ReportPath = "/" + Request["Path"];
Can any one help me please ?
|
|
|
|
|
MSinha wrote: Can any one help me please ?
With what? You haven't stated what your problem is. What is wrong with the code you have posted? Are you getting an error?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Problem is with rendering of the report from tree view nodes to reportviewer control. I gets this error:
The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportExecution2005.asmx">here</a>.</h2> </body></html> --.
|
|
|
|
|
Hi, I am trying to update my local Access DB with data retrieved from my Sybase server. I use this ADO query under the Access ADO connection:
"SELECT * INTO LocalTbl FROM OPENROWSET('ODBC','DATABASE=DB';'UID=USER';'PWD=PWD';'DSN=SYBASE_DSN','SELECT T1.M_SE_LABEL AS BASKET_NAME,T2.M_SE_BSK_COM AS MX_SECURITY, T2.M_SE_BSK_WEI AS WEIGHT FROM SE_MKTOP_DBF T1 ,SE_BKC_DBF T2 WHERE T1.M_SE_INUM = T2.M_SE_INUM AND T2.M_SE_RTYPE = 'INSTR'')"
but get Error number -2147217900 (Syntax error ner FROM)
Can anybody help me with this?
Thanks in advance
|
|
|
|
|
does the Openrowset wrok in your computer?
CodeProject,Your Code, Your Porject!
|
|
|
|
|
Sure, I´ve tried with two Access DBs.
The thing is that I am not sure OPENDATASOURCE/OPENROWSET works with ODBC connections (wonder if someone can clear this up to me). I think I should use OLEDB instead, but have no OLEDB driver installed for Sybase.
|
|
|
|
|
Sorry, I'm a liar. I checked with two Access connections and I still get the same Error (-2147217900). Any idea?
Thanks in advace
|
|
|
|
|
How to create a stored procedure in MySql using:
1.create query
2.insert query
|
|
|
|
|
Have you tried reading the documentation[^]?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi all,
declare @str1 varchar(500)
declare @str2 varchar(500)
declare @str3 varchar(500)
declare @str4 varchar(500)
select @str1=ud_id from cm_tb_002 where username='admin';
select @str3=role_id from cm_tb_012 where tb012_id=@str1;
select @str4=tb001_id from cm_tb_001 where menu_activ = 1 and child_lvl = 0 and [15]='1';
select tb001_id from cm_tb_001 where menu_prnt=@str4;
Here i want to pass @str3 to a this query
select @str4=tb001_id from cm_tb_001 where menu_activ = 1 and child_lvl = 0 and @str3='1';
but the @str3 column is an bigint column. ex. 15 i.e column name
In sql sever this value is storing as [15] as column name. Now i want to
pass this value to this query
select @str4=tb001_id from cm_tb_001 where menu_activ = 1 and child_lvl = 0 and @str3='1';
Please help me on this.
i want to join this group
|
|
|
|
|
You would need to construct your SQL statement as a string and execute it using the EXEC statement.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hai all
In my table i have some records with serial number
ex:
1
2
3
4
5.
if i delete 3 means 4 should be decremented as 3 and 5 should be decremented as 4.
Plse give me a logic to do this.
Thanks in advance.
With regrds
Lijo Rajan
|
|
|
|
|
Lijo Rajan wrote: Plse give me a logic to do this.
What have you tried? Show that you have made a serious attempt to solve the problem and I'll help you.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I dont know the logic.I am requesting u to give me logic or sql statement to do this
|
|
|
|
|
Lijo Rajan wrote: I dont know the logic.I am requesting u to give me logic or sql statement to do this
I don't give code to people, especially when they haven't demonstrated that they have tried to solve the problem themselves.
I'll give you a hint though - use an UPDATE query to decrement all serial no. values greater than the one being deleted. Your biog states that you are a professional software engineer, so you should be able to figure out how to implement this.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
UPDATE IPMS_TBL.VDR_WO_LINE_ITEM SET serialnumber=serialnumber-1
WHERE WO_ID=@WOId AND WO_LINE_ITEM_ID>@WOLineItemId
@WOLineItemId=id which i deleted
|
|
|
|
|
I assume that you mean that you have an identity column that you want to reorder on a delete. You should know that this is a dangerous thing to attempt. For a start, suppose that you have 10,000,000 records in a table and you delete record number 3. That leaves 9,999,996 records being updated just to keep this in sync. More importantly, if you have this fields as a PK and there are foreign key relationships then you also need to reorder all of those foreign keys. Please rethink this strategy before you attempt to go any further.
|
|
|
|
|
If you really need the records to be sequentially numbered in the output of a query, and you're using SQL Server 2005, consider sorting the output using ORDER BY and using the RANK function to get the sequential numbering.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
there is 2 table named table 1 and table 2 in the db
where both table have a comman coloumn named employee_code.
let table1 conatain emplyee_code-1,2,6,8,9
and table2 contain employye_coce-2,4,6,7,8
now i want a sql statement which will give me the out put as follows
i want to check(let say employee code1) wather a particular employee_code
present in table 1 and not present in table2 .if it run succesfully it should give massage emplyee code exists else
doesn't exists.
means if i select emp_code 1 then the message would be "emplyee code exists"
i select emp_code 2 then the message would be "emplyee code doesnt exists"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
