November 2005 Entries
Came across a great multi-vendor db tool today called Aqua from AquaFold. It's much like the Enterprise Manager that comes with MS SQL Server - but, personally I think it's waaaay better - more functionality (intelli-sense would be one of my favourites) etc. It supports most of the main rdbms's: Oracle- 8i/9i/10g DB2 UDB- 7.x/8.x MS SQL Server- 2000/2005/7/MSDE Sybase ASE- 11.x/12.x/15 Sybase Anywhere- 6/7/8/9 Informix (IDS)- 7.x/9.4/10 Postgresql- 7.x/8.0 MySQL- 3.x/4.x/5 Generic JDBC[tm] Generic...
For those of you, like me with a memory like a seive.. here's a quick 101 on linux/unix commands: Help/Manual (to get help on a command or shell): man eg: man cp The following will show details of how to work within a shell, ie syntax for pipes, scripting etc man sh man bash Once within man: = scroll down 1 line = scroll down 1 page Q = quit. Display contents of a file or output stream: more Once within man: = scroll down 1 line = scroll down 1 page Q = quit. List files in a dir: ls (file/dir names...
This error occurs within IIS 6 when you try to start your web site and it has not been assigned to a valid application pool. This usually happens when the default app pool has been deleted. HTH Tim
LMAO when stumbling across an RSS aggregator called RSS Bandit. Actually, it's very good... and the app aint bad either ;-)
This occurs when using ADSI (ActiveDs.dll) when retreiving a property value whose type (in the schema) is not the same as that specified in the method you use. In my case I was trying to access a property which was a dn (distinguished name), however the method I was using to retrieve the value was defaulting to type ADSTYPEENUM.ADSTYPE_CASE_IG... This caused the following error: Exception Information****************... Type: System.Runtime.InteropServi...
I find that when using the Close() method for both the OleDbDataReader and/or the OleDbConnection, when connected to a Sybase server, my ASP.NET process hangs. I had a need to run multiple different queries in sequence, so wanted to reuse the connection and just close the reader each time. And just wanted to close the connection at the end (as a good practice ;-) ) Couldn't find a solution, nor the reason, so, the workaround is... Put all the db access code into one method and call that each time...
The following error occurs in VS.NET when you try to open a project that requires certificates and the host name in the url differs from the cert: The Web server reported the following error when attempting to create or open the Web project located at the following URL: 'http://<host>/<pr... 'The host name in the certificate is invalid or does not match'. To resolve you need to make sure the host name in both the .sln and .webinfo files is the same as on the server's certificate....