I have started to use the ODBC calls and P/Invoke as the Odbc stuff is .Net is sorely lacking. Still can't get it work though. IntPtr henv; short ret; // Allocate environment handle ret = SQLAllocHandle(SQL_HANDLE_ENV, (IntPtr)SQL_NULL_HANDLE, out henv); if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) { ret = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,(IntPtr)SQL_OV_ODBC3, 0); if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) { IntPtr hdbc; ret = SQLAllocHandle(SQL_HANDLE_DBC, henv, out hdbc); if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) { // ret = SQLConnect(hdbc, dsn, SQL_NTS, null, SQL_NTS, null, SQL_NTS); if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) { IntPtr hstmt; ret = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, out hstmt); if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) { ret = SQLTables(hstmt, null, SQL_NTS, null, SQL_NTS, null, SQL_NTS, null, SQL_NTS); if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) { StringBuilder tableName = new StringBuilder(256); int tableNameLen; ret = SQLBindCol(hstmt, 2, 1, tableName, 256, out tableNameLen); if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) { while(SQLFetch(hstmt) == SQL_SUCCESS) { Console.WriteLine(tableName + ":" + tableNameLen.ToString()); } } } ret = SQLFreeHandle(SQL_HANDLE_STMT, hstmt); } ret = SQLDisconnect(hdbc); } // ret = SQLFreeHandle(SQL_HANDLE_DBC, hdbc); } } ret = SQLFreeHandle(SQL_HANDLE_ENV, henv); } The SQLFetch will be called as many times as there are tables in the dsn but the dsn is empty and tableNameLen is -1. Rugby League: The Greatest Game Of All.

It is the GUI thread which changes the cursor - the long running process just raises an event to say it has started then one to say it has completed - these are handled on the GUI thread.

Whoops, sorry about that - my apps engine is in C# and the GUI is in VB (don't ask) and I tend to spend more time on the C# messageboard - I guess I got bit carried away :doh:

I HAVE A SIMILAR PROBLEM i am havig a list view and i dynamically tried to cange the cursor to waiting cursor, but it does not work. then i tried changing the cursor from the property of the list view but it does not work either.

I am using the byte array as a bit array and I need to constanty iterate over it ANDing and ORing it against another byte array. I am creating a 3 way crosstab report and by recycling the memory I only have 3 byte arrays in memory at any one time which give me big savings. The array is basically the number of "person" records on a database divided by 8

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/fastmanagedcode.asp?frame=true&hidetoc=true http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/dotnetgcbasics.asp

Yes, you can still use evens. The article details exactly how to do it in terms of your GUI. First, subscribe to the events or use a delegate which points to your GUI's method. Either way will work fine. Your thread will call it's delegate or raise its event, and the UI thread will receive the notification. In your gui you'll need code similar to this to handle the event: private delegate void uiThreadDelegate(object sender, EventArgs e); protected void MyEventHandler(object sender, EventArgs e) { if(this.InvokeRequired) { uiThreadDelegate ui = new ThreadDelegate(MyEventHandler); this.BeginInvoke(ui, new object[]{sender, e}); }else{ ... your code } }

There's a very good basic article here[^] that will probably cover most of the bases for you. It's a time saver if you don't want to reinvent the wheel with respect to UI <-> worker thread interaction. Hope this helps. The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’

Post codes are copyrighted by the Post Office so in short - no. Elaine :rose: The tigress is here :-D

True, I rather like C# now, I wqasn't to keen at first and I still have to do stuff I would rather not just to get the performance but then that's often the case in most languages - at least C# remains reasonably readable.

If you're judging by the "Mem Usage" column in the task manager, you're looking in the wrong place for memory usage; that column takes into account Windows memory paging, which will vary depending on the amount of RAM in the system. Tech, life, family, faith: Give me a visit. Judah Himango

PaleyX wrote: How do I find out the version number of a .NET DLL from within that DLL? The AssemblyVersionAttribute Class[^] isn't a custom attribute. In order to get the version information (usually as a Version[^] object) you have to use the AssemblyName.Version[^] property. And if a method is supposed to retrieve the version of its own assembly you can use Assembly.GetExecutingAssembly()[^] to get the assembly and Assembly.GetName()[^] to get the AssemblyName object. public string Version() { return Assembly.GetExecutingAssembly().GetName().Version.ToString(); } Best regards Dennis

You as the developer don't know what comprises your own project? If you need to check, right-click on your solution and select Configuration Manager. Look at the dependencies for your project by selecting your project from the drop-down. If there's a disabled checked checkbox, then you're got a project reference. If not, you're referencing an assembly. You can also open the .sln file (your solution file) in notepad or some other plain-text editor and look at the solution text to see what is listed. It should be quite obvious. For a 60+ project solution I used to manage while a senior software architect for another company I never once had a problem - nor did any of my developers - because we all used project references. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog]

First off, consider if your software is worth somebody spending the time to decompile your code just to be able to use your application and then publishing a license generator in the web. (Take into account that the average user will not have the skill to do this) If the answer is yes, then I wouldnt waste too much time...it'll get cracked anyways...just do a search in google for 'Keygen' and any software developer will cry himself to death. :p and I'm sure most of those apps have spend hours and money way beyond what ur will to try and stop that from happening.

It works much better when you use generics though. ;-) - Nick Parker My Blog | My Articles

Thanks for that. It isn't really a problem as the program is fast enough - analyse 1 billion records per second anybody? I was just curious why it was spending so much time sleeping and waiting. Rugby League: The Greatest Game Of All.