Database

FirstPrevNext

Re: Query required John-ph4-Oct-07 0:41 John-ph 4-Oct-07 0:41  Table Relationship's are Violating the Normalization Rule. Regards J O H N "Even eagles need a push." David McNally Re: Query required Krish - KP4-Oct-07 0:28 Krish - KP 4-Oct-07 0:28  disable constraint then a dummy master data. use the same while inserting into transaction table. Regards KP Re: Query required John-ph4-Oct-07 0:38 John-ph 4-Oct-07 0:38  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 "Even eagles need a push." David McNally Re: Query required Paddy Boyd4-Oct-07 0:35 Paddy Boyd 4-Oct-07 0:35  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... Re: Query required John-ph4-Oct-07 0:44 John-ph 4-Oct-07 0:44  You are right. Regards J O H N "Even eagles need a push." David McNally Re: Query required Paddy Boyd4-Oct-07 0:46 Paddy Boyd 4-Oct-07 0:46  I know Re: Query required veereshIndia4-Oct-07 1:09 veereshIndia 4-Oct-07 1:09  Hi, Thanks for giving answer.But my application requires this things.Please help me on this. i want to join this group Re: Query required Paddy Boyd4-Oct-07 1:14 Paddy Boyd 4-Oct-07 1:14  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? Re: Query required veereshIndia4-Oct-07 1:27 veereshIndia 4-Oct-07 1:27  Hi, I will try to combine into only one table.Thanks a lot. Veeresh i want to join this group Re: Query required karoitay4-Oct-07 0:52 karoitay 4-Oct-07 0:52  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) Remote Connection MSSQL confusedme3-Oct-07 19:52 confusedme 3-Oct-07 19:52  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 Re: Remote Connection MSSQL Anilkumar K V3-Oct-07 20:18 Anilkumar K V 3-Oct-07 20:18  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? Re: Remote Connection MSSQL Joe3-Oct-07 20:21 Joe 3-Oct-07 20:21  Does this issue occur with the SqlServer service started on the remote computer? Re: Remote Connection MSSQL Anilkumar K V3-Oct-07 22:46 Anilkumar K V 3-Oct-07 22:46  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 ) Re: Remote Connection MSSQL [modified] Marek Grzenkowicz3-Oct-07 22:13 Marek Grzenkowicz 3-Oct-07 22:13  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. Re: Remote Connection MSSQL Anilkumar K V3-Oct-07 23:31 Anilkumar K V 3-Oct-07 23:31  Its enabled Re: Remote Connection MSSQL Marek Grzenkowicz3-Oct-07 23:47 Marek Grzenkowicz 3-Oct-07 23:47  Is SQL Browser service running? Re: Remote Connection MSSQL confusedme4-Oct-07 0:14 confusedme 4-Oct-07 0:14  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 Re: Remote Connection MSSQL Marek Grzenkowicz4-Oct-07 0:40 Marek Grzenkowicz 4-Oct-07 0:40  Check firewall on the client and server. Re: Remote Connection MSSQL confusedme4-Oct-07 18:35 confusedme 4-Oct-07 18:35  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 Re: Remote Connection MSSQL Marek Grzenkowicz4-Oct-07 22:38 Marek Grzenkowicz 4-Oct-07 22:38  Check this[^], too. Re: Remote Connection MSSQL Joe4-Oct-07 0:51 Joe 4-Oct-07 0:51  Will this[^] be of any help? Re: Remote Connection MSSQL [modified] confusedme4-Oct-07 23:15 confusedme 4-Oct-07 23:15  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 General Network Error. Check your network documentation Mayank Prajapati3-Oct-07 19:29 Mayank Prajapati 3-Oct-07 19:29  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 Changing table name to a table variable MAW303-Oct-07 17:13 MAW30 3-Oct-07 17:13  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

Last Visit: 31-Dec-99 18:00     Last Update: 26-Apr-24 13:09 Refresh ᐊ Prev1...1392139313941395139613971398139914001401 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.