I have been trying to solve this for quite sometime, I have google it as well. My connection string is as follows: "Data Source=xxx.xxx.8.20,1433;Network Library=DBMSSOCN;Initial Catalog=myDatabase;Trusted_Connection=Yes;"
Though my remote server is SQL 2000 Server. On my developer platform I have SQL 2005 and 2000, but whenever I debug the application, it is giving the error:
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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
I can ping the remote server. I can also connect to the server from the studio, please what can I do to solve this problem.
I am also having the same issue. I am trying to build a Window application where i want to connect to a remote sql server 2000 database. Fortunately i have figured out some settings in "Surface Area Manager" of 2005, but no help regarding remote connection in sql server 2000.
Please let me know in case you have figured out the solution. Any help is highly awaited.
Thanks for the quick response. Well actually i am new in developing and not having that much sense. I was wondering if you could please provide me with some detailed step by step configuration of sql server. As far as ports are concerned i think we can put it in between 1433-1444 and i have given it 1438. but still i am stuck with two errors:
A dialog box (Not from VS 2005 that's for sure) appears with the following error - Invalid Parameter and then asking to enable JIT in my machine.config file to debug the issue
Similarly another dialog box occurs this time with the error msg as Object reference not set to the instance of object. and i am sure this is also not comming from vs 2005 because i have put my code in try.... catch and have a different messagebox to display the exception.
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString = "Network Library=DBMSSOCN; Data Source=xxx.xxx.xxx.xxx,1438;Initial Catalog=databaseName;User ID=myUsername;Password=myPassword"
I don't see anything wrong, but that may be because I didn't look closely since you didn't use PRE tags which would improve readability.
The good thing is you were wise to choose multiple lines, so you can easily remove part of the statement and discover which part is causing the trouble.
Luc Pattyn [Forum Guidelines][My Articles] DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
Hi, yea may be I was not able to put my question properly. Let me try once more. Suppose CategoryId 1 is the root level, so thete is no top level category for it and it is null. The CategoryId 2 is the child of CategoryId 1, therefore, the topcategoryid for Category 2 is 1. Like wise for Category 3, the topcategoryid is 2 and for CategoryId 4, the topcategoryid is 3. CategoryId 5 is the child of CategoryId 1 and there are further no child categories under it.
Therefore, I showed thebase table like that. For the same, I want the output in the manner I depicted.
Sorry for being late in answering your question.
I was completely bogged up with my project.
However, please try this
SELECT C1.TOPCATEGORYID AS CATEGORY1,
C1.CATEGORYID AS CATEGORY2,
C2.CATEGORYID AS CATEGORY3,
C3.CATEGORYID AS CATEGORY4
FROM CATEGORY AS C1
LEFT OUTER JOIN CATEGORY AS C2
ON C2.TOPCATEGORYID = C1.CATEGORYID
LEFT OUTER JOIN CATEGORY AS C3
ON C3.TOPCATEGORYID = C2.CATEGORYID
WHERE C1.TOPCATEGORYID IS NOT NULL) F
WHERE F.CATEGORY1 = 1
N.B.~ The inner derived query is the right one. It is showing the right dependencies. Since I had to bring precisely to your format, so I applied the outer query.
However, it will work as per the input you gave and as per your desired output
i'm searching a few weeks for a database which fits to my requirements and where i don't have to pay any cent. MySQL is very great, but i don't know what's with the licenses, do i need to pay for the db-system or only for the connector or not and so on...
So i wanted to ask, is it a good idea to create a "own" database? Maybe, for each Table an own, maybe XML-File or CSV-File? I don't need a lot of relations and so on, it must be only fast. And it mustn't be very secure, because only a server is talking to my DB over TCP. The hole thing user-management, or index-keys and so on, that's coded very fast, and that's not the problem. The problem is, how to save that files? I mean, how does a database load their data? I don't access for each SELECT-Command the HDD.
So how to make it, i have a lot of ideas, but i don't know if it's makeable. Or maybe could somebody explain how a DB-System like MySQL works? They have all their DB-Table-Files soemwhere on the filesystem.
Last Visit: 31-Dec-99 19:00 Last Update: 1-Dec-23 20:04