|
Inserting Into these table's are possible only If one of the table's Foreign Key column Allows Null Value.
Regards
J O H N ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
"Even eagles need a push." David McNally
|
|
|
|
|
You have two foreign keys, each referencing the primary key of the other table. Why do you have this circular reference?
Makes inserting records a little awkward...
|
|
|
|
|
You are right.
Regards
J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
I know 
|
|
|
|
|
Hi,
Thanks for giving answer.But my application requires this things.Please help me
on this.
i want to join this group
|
|
|
|
|
I can't understand an application that would require this design, it seems fairly fundamentally flawed.
Think about it - if your foreign key fields can't accept nulls and you are trying to insert a record:
1. Try to insert a record into A, fails because corresponding field does not exist in B.
2. Try to insert a corresponding record into B, fails because initial record does not exist in A.
3. Keep trying because it doesn't work.
It seems like you are trying to enforce a one to one relationship between these two tables - why not combine them into a single table?
|
|
|
|
|
Hi,
I will try to combine into only one table.Thanks a lot.
Veeresh
i want to join this group
|
|
|
|
|
It looks like your purpose is to have roles list ant employees list and you need some how to assign roles to employees.
If this is the case - I would have done this with three Tables.
TableEmps -- empId, empName (PK - empId)
TableRoles -- roleId, RoleName (PK - roleId)
TableRoleToEmp -- roleId, empId (FK1 roleId ref - TableRoles.roleId, FK2 empId ref - TableEmps.empId)
|
|
|
|
|
Hi..
I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error:
Cannot connect to 123.456.789.000\sqlexpress
An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider:SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server)
I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas?
Thanks
confused
|
|
|
|
|
I too had same issue like this
I installed SQL Server SE, on an XP machine. How other users of same domain can access SQL server using SQL Server Express Edn.
I did create new logins for user, windows authentication. But whenever user try to connect it show message like
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified).
How to get rid of this issue. Do i need to set/change in WInodws user accounts?
|
|
|
|
|
Does this issue occur with the SqlServer service started on the remote computer?
|
|
|
|
|
I could login from the local machine. When when other user try to login it show error.
It seems that Windows Authentication issues are there.
What all things to do in the SQL Ser. Standard Edition ( XP ) to enable remote login
( like user permission, adding new login , etc etc )
|
|
|
|
|
Contact the DBA responsible for the server and ask them to use SQL Server Surface Area Configuration tool to check whether SQL Server is configured to allow remote connections.
|
|
|
|
|
|
Is SQL Browser service running?
|
|
|
|
|
Hi..yes the remote server is up and the sql browser service in my local server is running.Any other configurations i need to check?
confused
|
|
|
|
|
Check firewall on the client and server.
|
|
|
|
|
Hi thanks ...
Well...I am afraid I dont know about the firewall state in the computer that i am tring to accesss...I will surely find that out ASAP...abt my station ,yes ,the firewall is on but i have defined SQL server and the SQL browser as exceptions for it .That means firewall must not block these applications.
confused
|
|
|
|
|
|
Will this[^] be of any help?
|
|
|
|
|
Thanks everyone!!
I solved the problem.Well..the mistake was quite simple.I had been giving the hostname as hostname\sqlexpress but it shud have been only hostname.
Rest everything was working fine.
Cheers!
confused
-- modified at 5:22 Friday 5th October, 2007
confused
|
|
|
|
|
Hi,
I am using .Net 1.1 for my web application.
And my database server is SQL Server 2005.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Can any one please help me to solve this error?
With Regards,
Mayank Prajapati
MCP, MCTS .Net 2.0
|
|
|
|
|
While reading through a list of tables names with a cursur the table name is picked up.
I then try to use this table name to create a table and I get the following message.
Must declare the scalar variable "@tblSQLTableNames".
I declare the following then try to set the name to a variable.
DECLARE @tblSQLTableNames TABLE(strName VARCHAR(10));
SET @tblSQLTableNames = strSQLTableNames;
How do you resolve this problem.
I'd appreciate any help concerning the above,
Michael
|
|
|
|
|
Are you talking about creating tables on the fly?
Will this[^] be of any help?
|
|
|
|
|
You have to insert data into the @tblSQLTableNames table variable.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
