|
Hi,
I want to connect a computer with a remote sql database ( in a local network).
I wrote an application which opens a SQlConnection with the help of a connection string.
When I run this application at the server, there is a connection to the database.
When I run this application on my client, it says: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I tried to change my connection string many times, but it won't work. The two computer can reach each other with ping.
Can you help me?
code snippet:
string strDatabase="_Hanna1";
string strServer="IS65PJ11\\WinCC" ;// this is the name of my server
strConnectionString = "Integrated Security=SSPI;" +"Persist Security Info=False;User ID=sa;Initial Catalog=" +strDatabase + ";Data Source=" + strServer;
// I tried the connection string also without "User ID=sa", but than its the same error
SqlConnection SQLCon = new SqlConnection(strConnectionString);
thanks in advance!
|
|
|
|
|
Hi,
Generally DataSource should be an IP address or Machine name of the SQL Server. Try to connect to database using SQL Enterprise Manager. Then you will know correct machine name, user id and password.
Harini
|
|
|
|
|
Hi Harini!
thanks for you answer!
I finally found the mistake, I got something wrong with my users.
I set an sql user and my client application can log in with this sql user.
but i had to remove the first two statements: "Integrated Security=SSPI;" +"Persist Security Info=False",
do you know if this does any "harm" ?
Leia2011
|
|
|
|
|
Leia2011 wrote: do you know if this does any "harm" ?
If you want to use SQL logins then you need to remove it. It tells SQL Server that you want to use Windows Authentication.
|
|
|
|
|
i have a datagridview in a form application,and now i want del
a row which i selected from datagridview . who can give a advise or example?
|
|
|
|
|
:-Dhi all,
i am a new guy..
i get good results from Recursive queries in sql server 2005 to count no of childs unde a node in a tree.
but now i am facing a problem ???
i have to define the level of a node ..
the case is as : starting from the rootnode of tree every node can have maximum of two node as left node and right node. not more than two node under a node.
so at level zero means root of node contains zero nodes.
suppose A is root of tree. first ledt node of A will be create afetr that right node a will be create. now A have two members under him so A is now at level one.
as suppose A have two node B(left)/C(right). and node B contais D/E as left right node and C(right of A ) contains F/G as Left/right node than at this level B exactly contains two nodes under him as well as C conyais two nodes . so binary has been complete. so now A is at level two.
now D has left only and G has only left node so at this level D E F G are uncomplete (having less tahn two nodes ) so now a is at two level.
so this is the pattern for that structure..
so have to et the level for every node in the tree.
now can i do
i am using asp . net 1.1/C# and sql server 2005.
This is the table structure for above :---
-------------------------------------------
Id name ParentId Left Right
--------------------------------------------
1 A -1/null 0 1
------------------------------------------
2 B 1 0 1
-------------------------------------------
3 C 1 0 1
--------------------------------------------
4 D 2 0 -1
----------------------------------------------
5 E 2 -1 -1
----------------------------------------------
6 F 3 -1 -1
-----------------------------------------------
7 G 3 0 -1
------------------------------------------------
8 H 4 -1 -1
--------------------------------------------
9 I 7 -1 -1
-----------------------------------------------
parent of A has null or -1 as reference .if a node has keft child that is represent by zero and for right one .
if a node does not contains any node this left=right will be -1;
so plz help me how can i set the level of a node in the tree.
the depth can be up to 50,000 node.
-- modified at 2:31 Thursday 24th May, 2007
-- modified at 2:34 Thursday 24th May, 2007
jh hsg sabdhas avdhagd advahgd axva
|
|
|
|
|
You may want to rename the title of your post. It sounds like you are demanding someone write the query for you. Since this is your first post, I recommend you read the forum guidelines.
__________________
Bob is my homeboy.
|
|
|
|
|
Hi
I am doing an application in which I am using a XML file to populate a datagrid.
In that XML file I have one like.....
<>
1.To generate leads efficiently and profitably.
2.To ensure that all details are collected in one call.
3.To provide email and chat support.
4.To manage Work Basket reports as required.
5.To meet targets for both quantity and quality.
<>
When I am trying to populate this column onto datagrid, all these lines or sentences are getting combine and displaying like a paragraph.
I want to know how to format this column to get them in the a new line
Thank u
Chandu
Thank u
Chandu
|
|
|
|
|
please don't spam the site, choose one forum for your question.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Does anyone know of the procedure, steps that need to be followed to allow installing SQL 2005 Express from a network? Since SQL 2005 express requires .NET 2 and the MSI engine 3.1 and MDAC 2.8 it is a real problem pushing it from a network such as active directory using an AIP (Administrator Installation Point).
|
|
|
|
|
I am required to create a database using Visual Studio with a built in SQL server, to do this i have chosen to make a 'windows application' and not .asp etc. I am creating a Database with 7 tables each containing many PK and FK's. From tutorials that i have currently done the only way to get a forgien to to relate to a primary key correctly seems very basic and not suited for tables that have many rows.
At the moment the only way i know how to do it is by creating another row (in the secondary table) which will be used as the forgein key. Then call this row the same name as the primary key from the wanted table. from there i have to manually assign the FKid value by ensuring it is the same as the unquie identifier PK from the other table.
Surely this is not the correct way to do it as once the database grows, manually entering the FK ID for seven different tables would be a issue.
How can i get the table to automatically gain the FK from a different table?
Sorry if my description seems a bit vague as im still learning many ropes.
Many thanks for any help provide, as u can see its well needed 
Cass
|
|
|
|
|
You need to use relationships. This will eliminate the second table.
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
|
|
|
|
|
I have created relationships using datasets and database diagrams..is there more i need to do?
Do you have any sites that have tutorial on setting up these relationships ?
Thanks
|
|
|
|
|
Hi All
I need to add my Project logo to the user interface of SSRS2005. How can I do this?
Regards
|
|
|
|
|
It's been a while since I've done reporting services work, but I beleive there is an image control that you can add to the UI.
topcoderjax - Remember, Google is your friend.
|
|
|
|
|
I'll Have alook
Thanx
Progress is a process , so value it
|
|
|
|
|
No
What I want to do is to change the folder image on the report server web site to my Company image
Regars
Progress is a process , so value it
|
|
|
|
|
Hi
I am doing an application in which I am using a XML file to populate a datagrid.
In that XML file I have one like.....
<>
1.To generate leads efficiently and profitably.
2.To ensure that all details are collected in one call.
3.To provide email and chat support.
4.To manage Work Basket reports as required.
5.To meet targets for both quantity and quality.
<>
When I am trying to populate this column onto datagrid, all these lines or sentences are getting combine and displaying like a paragraph.
I want to know how to format this column to get them in the a new line
Thank u
Chandu
|
|
|
|
|
I am not totally sure how you are working with your xml, but usually there is a property called white space presever or something like that.
Check out this link:
http://msdn2.microsoft.com/en-us/library/6f00zs65(vs.71).aspx[^]
Once that value is set you should just be able to do a:
Environment.NewLine or Char(13)Char(10)
Hope that helps.
Ben
|
|
|
|
|
hi
IS there any way to optimize a stored procedure for quick data retrival..
please help me
thanks in advance..
pradip kishore
|
|
|
|
|
Yes, there is. Optimization with a stored procedure, like all other optimizations, is different for each procedure. Make sure you don't do anything unnessesary and that you don't pull the same information multiple times unless you have to. There might be some useful tools, try a google search on that.
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
|
|
|
|
|
Dear
Used Minimum,Temporary table, Minmum Joins, It will be optimize ur query
|
|
|
|
|
Hi,
I'm using VC++ to connect to a SQL Server. At first there was no problem.
But the program has grown and there are now 13 threads accessing the database.
Some too retrieve the data they need, while others put there data in it.
My question is the following: What is the best way to let this work?
a. use a single connection by all threads.
b. let every thread make its own connection.
c. some other solution ...
Can solution (a) give problems when using the same connection pointer in multiple threads.
Solution (b) seems logical but further investigation showed that u must make sure that there are enough concurrent user session on the SQL server. But does that mean that you need 13 CAL's or can you use a single CAL for the whole applications. I can't seem to find any answer to that question?
Thanks in advance
Kurt Pattyn
codito ergo sum
|
|
|
|
|
Hi there,
Well I am starting to wade into the world of SQL however, I am stuck with a problem. At the moment I have two tables, product table and supplier table. In the product table I have a foreign key called supplierID which is the primary key of the supplier table. Using MS Access I have created a relationship between these two tables graphically, i.e. one to many relationship.
My problem is that I am trying to delete the supplierID column from the product table using queries.My problem is that I am not being allowed to delete the column supplierID from the product table due to an error:
"Cannont delete field 'supplierID'. It is part of one or more relationships".
My deletion query:
ALTER TABLE product DROP COLUMN supplierID
My question is how do i delete the existing relationship between the two tables I had created graphically ?
Any help will be highly appreciated.
thanks
EDIT:
I am interested in finding out how to delete the relationship programmatically 
|
|
|
|
|
Try
ALTER TABLE tblname DROP CONSTRAINT constraintname
topcoderjax - Remember, Google is your friend.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
