Search results for query: *

If you are using the SQL Server, there is a stored procedures that tells you the number of concurrent connections. Also you can implement your own method by keeping the count in a storage like db, and increment/decrement it yourself. Mohammad Mehran Nikoo, MCSD mohmehran@msn.com

Try using CASE phrase. Mohammad Mehran Nikoo, MCSD mohmehran@msn.com

It is normal. When you use Execute method of Command or Connection object, it returns a forward-only recordset and it does not allowed you to move back (that is using .MovePrevious method). RecordCount will return -1 in this case. So, you can use Recordset.Open instead of Command.Execute. Just...

As foxdev says, it is impossible to insert into two tables in one statements. Even if you have a view defined on two tables, any insert statement on this view that references columns from two table will fail. The reason to this constraint is that, since each TSQL statement is wrapped in its own...

Hey guys, keep in mind that: 1- The recordset should be client-side, so that the client knows about the number of rows. *** 2- Execute method of Connection and Command objects always return a forward-only, read-only recordset, even if you assign the return value to a static (,etc) recordset...

Also you can use ActiveX controls like Windows Media Player, if you are sure it is installed on clients. Mohammad Mehran Nikoo, MCP mohmehran@yahoo.com

Simply remove any forms from your code, add a standard module, and put the code in Public Sub Main. Then goto project properties window and set the startup mode to "Sub Main". Mohammad Mehran Nikoo, MCP mohmehran@yahoo.com

Your can use the COMMAND() function, which returns a string, containing all of the user-supplied values as a single string. Then you will have to parse it and set the default values as needed yourself. VB will help you in parsing with Split function, which will get a string with delimiter (say...

You can FileSystemObject COM Component or VB's Open function to open the text file. Then you can read the contents of the file and put words in the array and do the processing. Although it works, it could be much better if you exported your text file into a database (this will be so easy by...

You can write an ActiveX dll that includes a class module. This project will have a reference to Microsoft ActiveX Data Objects, and will use ADO to connect to the database. This class module may return data from database in various formats, which can be ADO Recordsets, scalar values or...

There may be several reasons to this. Maybe the url provided in 'CODEBASE' attribute is not correct. Also it is possible that the security settings of browser does not allow the client machines to download unsigned ActiveX controls to their machines. Mohammad Mehran Nikoo, MCP mohmehran@yahoo.com

But first try this: SELECT * FROM tblTable WHERE UPPER(fldTest) LIKE '%ON%TECHNICAL%' Mohammad Mehran Nikoo, MCP mohmehran@yahoo.com

This is not defined in the ANSI-SQL standard. You should stick to the services provided by your DBMS. For example SQL Server has a service named Full-Text Search that will do what you want. Even you will be able to search for different forms of verbs. Refer to your DBMS documentation. Mohammad...

Are you running SQL Server 2000? If so, write me to tell you about the reason. Mohammad Mehran Nikoo, MCP mohmehran@yahoo.com

It depends on number of licenses you have purchased for SQL Server. In addition to this, each open connection costs you cpu utilization and memory. Mohammad Mehran Nikoo, MCP mohmehran@yahoo.com

So, where have you executed your query? You have just built the SQL statement!!! Mohammad Mehran Nikoo mohmehran@yahoo.com www.intellicomsoft.com MCP with experience in VB, ASP, XML, SQL, COM

[TonyBrindle wrote: ... passing ADO Recordset slow the entire process drastically. ] Just to note: Did you pass it by value? Since passing them by reference will have an overhead of two-way marshaling. Mohammad Mehran Nikoo mohmehran@yahoo.com www.intellicomsoft.com MCP with experience in...

Noway. Even don't think of it. Novell NetWare is just a File-Sharing OS and it does not do any process in the business tier. If you are serious using MTS, consider moving into NT. Mohammad Mehran Nikoo mohmehran@yahoo.com www.intellicomsoft.com MCP with experience in VB, ASP, XML, SQL, COM

Nice discussion. But there is something to note. You call SetComplete and SetAbort in the object in which you are doing some task. But you don't release the object in one of its own methods. So as you told, when you are using MTS, there is no need to release the object, since the MTS does not...