Recent content by Nikolaj

What version of IIS are you running?? I cant find the 'Enable process throttling' on my version????? But I think it is the thing for me!!

Hi!! I have the exact same problem!!!! I have found this but it dosent help me much!! Maybe it can help you! > Dear all,> > I have two IIS 5 (clustered) connecting to SQL 7.0 server. There are ASP > running on those IIS 5. The IISs handle about 180 concurrent users and I > found there are...

Sure it is enough with the IP address! The name is just used as an Alias that is converted some where in a router or something to the IP address! I dont really know how it works but the IP is for sure enough!

Ok! It might look as Im using the ODBC!! But I think its a General setting not just a ODBC setting. It is just set from the ODBC DataSource! <br><br>It has to be possible to set this setting from a VB or something else!!<br><br><br><br>

Hi!!<br><br>What the heck are you talking about!! Im not using the ODBC data source!! Where in my code can you see that im using the ODBC data source??<br><br><br>If im wrong please tell me how not to use ODBC!!!??<br><br><br>Nikolaj

The problem is solved!! Is not called by another SQL script byt is done in a Bat file using the osql -i<br><br><br>

Hi again!<br><br>Im not using ODBC data Source! I just wanted to see if it was possible to connect through that. But it wasnt untill I set the TCP/IP setting!!<br><br>I am doing a direct connection throug ADO from VB but my problem is that the TCP/IP setting is wrong so no connection is...

Hi!!<br><br>I solved the problem myself!<br><br>In Client Configuration in the ODBC Source in the Control Panel should the Network Libraries be set to TCP/IP!!<br><br>So that solves the actual problem!!<br><br>But;<br><br>Do you know how to set this from a VB Application???<br><br>It is bulls...

Hi!<br><br>Yes Im trying to connect to the SQL server through ADO in a VB applikation.<br><br>Im running WinNt Service Pack 5.0<br><br>Here is how im trying to connect to the SQL server<br><br>If (Connection Is Nothing) Then<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim str As...

Hi!!<br><br>I have a client that is NOT logged on to the machine with the SQL server on! Nothing that has anything to do with the SQL server is installed on the client!!<br><br>Why can't i connect to the SQL server??? Is it a problem like the problem conserning DCOM??? That is really a pain in...

Hi!<br><br>Does anyone know if it is possible to call or execute a SQl Script called Sql1.sql from another sql script???<br><br>I have a lot of Scripts that creates tables but I want them to be in a script each so it is more easy to maintain!<br><br>Regards<br><br>Nikolaj

Hi Jatin!<br><br>I dont think I have the answer to you question but I just want to ask you a question!<br><br>How do you create an instance of the Middle Tier in the user Interface Tier??? With the CreateObject(...)???<br><br>Are the machine with the UserInterface Tier logged in to the machine...

Hi Again!<br><br>Im sorry If i misinformed you fourguys!! Obivously the Object Pooling feature is not a part of the MTS 2.0 Release!<br><br>Nikolaj<br>

Hi!!<br><br>The thing with MTS is that is keeps an instance of the object alive if anyoneelse should need it. There is a place in the MTS that defines the time that an instance shall stay alive without being used before it gets destroyed!<br>In the properties of the package in which the...

When you make an update to a component installed in teh MTS you have to delete the Component, shut down the Package and reinstall the component to the MTS!<br><br>I dont think it should be neccesary to reinstall the package to the clients unless you make radical changes, like interface changes...