Moving to VB.NET

Friday, December 24, 2004

Merry Christmas

I would like to wish everyone a Merry Christmas and a happy new year!

Monday, November 08, 2004

Database Status

I have now heard from my ISP it seems for some reason they do not support MS Access format Databases in the .NEt environment, I do not quite understand this as it should be possible to make the DB's just as secure in this environment as it was in the pre .NET days, and I have a few sites already running with this ISP using this scenario. Looks like I will have to find an alternative ISP in order to Host my Access DB's and then later host them with SQL server once the application has been complete. Anyone have any good ISP that they know that meets the above criteria? Also I have a new bunch of Gmail invites if anyone is interested, then drop me a line.

Friday, October 29, 2004

More on Database Connections

I am still suffering from my database connections problems, and my ISP is no further to resolving the problem.
I am currently trying to open an Access format database using aso.net, I have no problems locally, however once I have moved the site to my ISP I get the following errors

Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request failed.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Anyone had this problem before,
Anyone have a resolution or suggestion
Thanks

Tuesday, October 26, 2004

John Peel has passed away

This was sad news for me today, as I listened to his show regularily for the past 15+ years, he will be missed by many music fans. More information is available at www.bbc.co.uk/radio1

Monday, October 18, 2004

Database Connections

I have moved part of my first web site to my ISP, however for the moment I am unable to connect to the Database that drives my sight. It looks like some security related item.
Something new to learn later today in order to resolve the problem

Friday, October 15, 2004

OverLoads

I am really liking overloads in VB.NET, gone are the day when I would pass Variant into routines then perform actions based on the variable type,
for example .

function formatsearch(vin as variant) as variant
dim varTemp as variant

Select Case VarType(strIn)
Case vbString
formatsearch = Chr(39) & strIn & Chr(39)
Case vbDate
formatsearch = Chr(39) & strIn & Chr(39)
Case Else
formatsearch = strIn
End Select
This would work fine 90 persent of the time,other than times where the return value was say an integer, but the value I passed in was a string, this would result in a runtime type mismatch error.
as in the following example
Dim intTest as integer
dim strTest as string

strTest="test"
intest= formatsearch(strTest)

This would result in a type mistmatch

With VB.Net I can create type specific routines, and let the compiler perform all of the type checking automatically for me(with option Strict of course).
I will post some details samples of the code that I have replaced in the next day or so.
Thats all for now
As always is this of us to you? Let me know.

Friday, October 08, 2004

Database Switching

I think that I now have a good idea on how I am going to accomplish the switching of Databases fromMS Access to SQL . I have come up with the following solution
Developed a Class for SQL databases access
Developed a class for MSAccess databases.

The above classes will share the same properties, and methods where applicable.
In my web config file I have a setting indicating the date base that I will be accessing.
In my CRUD class I interigate the database setting then access a method in the appropriate database class.
I am not sure that I like all of the extra work, but at least it will allow me the luxury of accessing both types of databases from the same aplication with out a create deal of re-writing.
the code that I will use will be something like the following
sub getdata(intSomething as integer)
if myDBFormat=MSSQL then
getsqldata(intSomething)
elseif myDBFormat=MSACCESS then
getMSADate(intSomething)
end if
end sub
Is this if any interest to anybody, comment?
Thanks is all for now.