Database Connectivity

[Izzy]

Re: Database Connectivity

Will post the encryption code on Monday, I don't remember who wrote,
but it works great. I use it to store passwords in an access table.

Check back Monday after 8AM Central Time.

Izzy


Miro wrote:

Izzy,
>
Id be interested in that 128 bit encryption - just to see how you do it. -
If you wouldnt mind.
>
Ivan,
I am in the same boat you are, just started learning vb.net
My code is probably all over the place. I started one step behind and
create my access table with adox.
There isnt much info out there. If you need something like that, let me
know. I found some good examples out there,
but were super hard to find.
>
Miro
>
"Izzy" <israel.richner @gmail.comwrote in message
news:1158951171 .143852.231990@ b28g2000cwb.goo glegroups.com.. .

Something to remember is when you destroy an object the memory doesn't
get released back to the OS instantly. It's not until the GC (garbage
collector) comes along and cleans up any unused resources.

I've had instances where I had to tell the garbage collecter to run
manually: gc.Collect()

You'll need that at some point.

Additionally Seth was right, passwords should be encrypted when stored
in an Access file. I have a routine for that too, it will encrypt it
with 128bit encryption then store it in the Access file. I didn't write
and I can't remember who did.

But if you want it I'll post it for you.

Izzy

Ivan Weiss wrote:

Izzy, another question.
>
Wouldnt you need to destroy the object or dispose of it or anything
after utilizing? Or will all resources be freed and database connection
be closed automatically once the functions run?
>
-Ivan
>
*** Sent via Developersdex http://www.developersdex.com ***

[Miro]

Re: Database Connectivity

Thanks Izzy,
Dont look too hard for it,

I created my own "encryption array" and flush out certain chars with others
depending on what value it links up to
with my encryption table.

Just wondering if there is an easier way. :)

I have a work around though.

Example ( and keep in mind that i have all the alphabet here )
EncryptionKey1 = { A, C, B, D, E, .... }
EncryptionKey2 = { C, D, B, A, E, .... ) 'includes all letters upper and
lower, and also some ascii chars.
and so on ..

Basically if I have a Password that allows for a length of 10. I actually
store the database as an 11 char field and the first
char is a 123...
If I have the #2 stored in that field and and A was in the pword, then it
gets replaced with a letter C.
If its a B, a D gets put in its spot, and an E, ( in this case stays as an
E )

I select a random number from 1 to how many encryption keys i have and thats
the one i use to encrypt it.
Whenever I have to write to the database and I de-crypt it, I re-encrypt it
with a different Encryption key.

Its simple, and with 30 encryption keys, it does its job.
Any letters that are not in the Encryption key or something like a special
char, doesnt get convrted and stays as is.

M.



"Izzy" <israel.richner @gmail.comwrote in message
news:1159053014 .114809.148840@ i42g2000cwa.goo glegroups.com.. .

Will post the encryption code on Monday, I don't remember who wrote,
but it works great. I use it to store passwords in an access table.
>
Check back Monday after 8AM Central Time.
>
Izzy
>
>
Miro wrote:

>Izzy,
>>
>Id be interested in that 128 bit encryption - just to see how you do
>it. -
>If you wouldnt mind.
>>
>Ivan,
>I am in the same boat you are, just started learning vb.net
>My code is probably all over the place. I started one step behind and
>create my access table with adox.
>There isnt much info out there. If you need something like that, let me
>know. I found some good examples out there,
>but were super hard to find.
>>
>Miro
>>
>"Izzy" <israel.richner @gmail.comwrote in message
>news:115895117 1.143852.231990 @b28g2000cwb.go oglegroups.com. ..

Something to remember is when you destroy an object the memory doesn't
get released back to the OS instantly. It's not until the GC (garbage
collector) comes along and cleans up any unused resources.
>
I've had instances where I had to tell the garbage collecter to run
manually: gc.Collect()
>
You'll need that at some point.
>
Additionally Seth was right, passwords should be encrypted when stored
in an Access file. I have a routine for that too, it will encrypt it
with 128bit encryption then store it in the Access file. I didn't write
and I can't remember who did.
>
But if you want it I'll post it for you.
>
Izzy
>
Ivan Weiss wrote:
>Izzy, another question.
>>
>Wouldnt you need to destroy the object or dispose of it or anything
>after utilizing? Or will all resources be freed and database
>connection
>be closed automatically once the functions run?
>>
>-Ivan
>>
>*** Sent via Developersdex http://www.developersdex.com ***
>

>

[Izzy]

Re: Database Connectivity

Here it is, I have no idea how it works, but it works great. I use it
to encrypt passwords stored in an access file.

To call it:

'This will encrypt a value
Variable = EncryptString12 8Bit(txt_Passwo rd.Text, EncryptionKey)

'This will decrypt a value
Variable = DecryptString12 8Bit([Password stored in DB goes here],
EncryptionKey)

Have fun,
Izzy

*************** *************** *************** *************** *************** *

Imports System.Security .Cryptography
Imports System.Text

Module mod_Globals

Public EncryptionKey As String = "justsomewordst obeusedasacrypt ionkey"

Public Function EncryptString12 8Bit(ByVal vstrTextToBeEnc rypted As
String, ByVal vstrEncryptionK ey As String) As String

Dim bytValue() As Byte
Dim bytKey() As Byte
Dim bytEncoded() As Byte
Dim bytIV() As Byte = {121, 241, 10, 1, 132, 74, 11, 39, 255,
91, 45, 78, 14, 211, 22, 62}
Dim intLength As Integer
Dim intRemaining As Integer
Dim objMemoryStream As New MemoryStream
Dim objCryptoStream As CryptoStream
Dim objRijndaelMana ged As RijndaelManaged

vstrTextToBeEnc rypted =
StripNullCharac ters(vstrTextTo BeEncrypted)

bytValue =
Encoding.ASCII. GetBytes(vstrTe xtToBeEncrypted .ToCharArray)

intLength = Len(vstrEncrypt ionKey)

If intLength >= 32 Then
vstrEncryptionK ey = Strings.Left(vs trEncryptionKey , 32)
Else
intLength = Len(vstrEncrypt ionKey)
intRemaining = 32 - intLength
vstrEncryptionK ey = vstrEncryptionK ey &
Strings.StrDup( intRemaining, "X")
End If

bytKey = Encoding.ASCII. GetBytes(vstrEn cryptionKey.ToC harArray)

objRijndaelMana ged = New RijndaelManaged

Try
objCryptoStream = New CryptoStream(ob jMemoryStream,
objRijndaelMana ged.CreateEncry ptor(bytKey, bytIV),
CryptoStreamMod e.Write)
objCryptoStream .Write(bytValue , 0, bytValue.Length )
objCryptoStream .FlushFinalBloc k()
bytEncoded = objMemoryStream .ToArray
objMemoryStream .Close()
objCryptoStream .Close()
Catch

End Try

Return Convert.ToBase6 4String(bytEnco ded)

End Function

Public Function DecryptString12 8Bit(ByVal vstrStringToBeD ecrypted
As String, ByVal vstrDecryptionK ey As String) As String

Dim bytDataToBeDecr ypted() As Byte
Dim bytTemp() As Byte
Dim bytIV() As Byte = {121, 241, 10, 1, 132, 74, 11, 39, 255,
91, 45, 78, 14, 211, 22, 62}
Dim objRijndaelMana ged As New RijndaelManaged
Dim objMemoryStream As MemoryStream
Dim objCryptoStream As CryptoStream
Dim bytDecryptionKe y() As Byte
Dim intLength As Integer
Dim intRemaining As Integer
Dim intCtr As Integer
Dim strReturnString As String = String.Empty
Dim achrCharacterAr ray() As Char
Dim intIndex As Integer

bytDataToBeDecr ypted =
Convert.FromBas e64String(vstrS tringToBeDecryp ted)

intLength = Len(vstrDecrypt ionKey)

If intLength >= 32 Then
vstrDecryptionK ey = Strings.Left(vs trDecryptionKey , 32)
Else
intLength = Len(vstrDecrypt ionKey)
intRemaining = 32 - intLength
vstrDecryptionK ey = vstrDecryptionK ey &
Strings.StrDup( intRemaining, "X")
End If

bytDecryptionKe y =
Encoding.ASCII. GetBytes(vstrDe cryptionKey.ToC harArray)

ReDim bytTemp(bytData ToBeDecrypted.L ength)

objMemoryStream = New MemoryStream(by tDataToBeDecryp ted)

Try

objCryptoStream = New CryptoStream(ob jMemoryStream,
objRijndaelMana ged.CreateDecry ptor(bytDecrypt ionKey, bytIV),
CryptoStreamMod e.Read)
objCryptoStream .Read(bytTemp, 0, bytTemp.Length)
objCryptoStream .FlushFinalBloc k()
objMemoryStream .Close()
objCryptoStream .Close()

Catch

End Try

Return StripNullCharac ters(Encoding.A SCII.GetString( bytTemp))

End Function


Public Function StripNullCharac ters(ByVal vstrStringWithN ulls As
String) As String

Dim intPosition As Integer
Dim strStringWithOu tNulls As String

intPosition = 1
strStringWithOu tNulls = vstrStringWithN ulls

Do While intPosition 0
intPosition = InStr(intPositi on, vstrStringWithN ulls,
vbNullChar)

If intPosition 0 Then
strStringWithOu tNulls = Left$(strString WithOutNulls,
intPosition - 1) & _
Right$(strStrin gWithOutNulls,
Len(strStringWi thOutNulls) - intPosition)
End If

If intPosition strStringWithOu tNulls.Length Then
Exit Do
End If
Loop

Return strStringWithOu tNulls

End Function

End Module

*************** *************** *************** *************** *************** *************

Miro wrote:

Thanks Izzy,
Dont look too hard for it,
>
I created my own "encryption array" and flush out certain chars with others
depending on what value it links up to
with my encryption table.
>
Just wondering if there is an easier way. :)
>
I have a work around though.
>
Example ( and keep in mind that i have all the alphabet here )
EncryptionKey1 = { A, C, B, D, E, .... }
EncryptionKey2 = { C, D, B, A, E, .... ) 'includes all letters upper and
lower, and also some ascii chars.
and so on ..
>
Basically if I have a Password that allows for a length of 10. I actually
store the database as an 11 char field and the first
char is a 123...
If I have the #2 stored in that field and and A was in the pword, then it
gets replaced with a letter C.
If its a B, a D gets put in its spot, and an E, ( in this case stays as an
E )
>
I select a random number from 1 to how many encryption keys i have and thats
the one i use to encrypt it.
Whenever I have to write to the database and I de-crypt it, I re-encrypt it
with a different Encryption key.
>
Its simple, and with 30 encryption keys, it does its job.
Any letters that are not in the Encryption key or something like a special
char, doesnt get convrted and stays as is.
>
M.
>
>
>
"Izzy" <israel.richner @gmail.comwrote in message
news:1159053014 .114809.148840@ i42g2000cwa.goo glegroups.com.. .

Will post the encryption code on Monday, I don't remember who wrote,
but it works great. I use it to store passwords in an access table.

Check back Monday after 8AM Central Time.

Izzy


Miro wrote:

Izzy,
>
Id be interested in that 128 bit encryption - just to see how you do
it. -
If you wouldnt mind.
>
Ivan,
I am in the same boat you are, just started learning vb.net
My code is probably all over the place. I started one step behind and
create my access table with adox.
There isnt much info out there. If you need something like that, let me
know. I found some good examples out there,
but were super hard to find.
>
Miro
>
"Izzy" <israel.richner @gmail.comwrote in message
news:1158951171 .143852.231990@ b28g2000cwb.goo glegroups.com.. .
Something to remember is when you destroy an object the memory doesn't
get released back to the OS instantly. It's not until the GC (garbage
collector) comes along and cleans up any unused resources.

I've had instances where I had to tell the garbage collecter to run
manually: gc.Collect()

You'll need that at some point.

Additionally Seth was right, passwords should be encrypted when stored
in an Access file. I have a routine for that too, it will encrypt it
with 128bit encryption then store it in the Access file. I didn't write
and I can't remember who did.

But if you want it I'll post it for you.

Izzy

Ivan Weiss wrote:
Izzy, another question.
>
Wouldnt you need to destroy the object or dispose of it or anything
after utilizing? Or will all resources be freed and database
connection
be closed automatically once the functions run?
>
-Ivan
>
*** Sent via Developersdex http://www.developersdex.com ***

[Miro]

Re: Database Connectivity

Looks like something simillar to what I wrote....... NOT!!! :-)

Thanks... I will be going back to the old code sometime at the end of this
week or early next week once I finish something up what Im doing now and
give her a run. I gotta fix up my Icon/Graphic mess I have created myself.

I will probably have a comment somewhere in there
'Encrypt data 128 bits - it just works ;-)

Thanks agian,

Miro


"Izzy" <israel.richner @gmail.comwrote in message
news:1159190558 .498861.156470@ k70g2000cwa.goo glegroups.com.. .

Here it is, I have no idea how it works, but it works great. I use it
to encrypt passwords stored in an access file.
>
To call it:
>
'This will encrypt a value
Variable = EncryptString12 8Bit(txt_Passwo rd.Text, EncryptionKey)
>
'This will decrypt a value
Variable = DecryptString12 8Bit([Password stored in DB goes here],
EncryptionKey)
>
Have fun,
Izzy
>
*************** *************** *************** *************** *************** *
>
Imports System.Security .Cryptography
Imports System.Text
>
Module mod_Globals
>
Public EncryptionKey As String = "justsomewordst obeusedasacrypt ionkey"
>
Public Function EncryptString12 8Bit(ByVal vstrTextToBeEnc rypted As
String, ByVal vstrEncryptionK ey As String) As String
>
Dim bytValue() As Byte
Dim bytKey() As Byte
Dim bytEncoded() As Byte
Dim bytIV() As Byte = {121, 241, 10, 1, 132, 74, 11, 39, 255,
91, 45, 78, 14, 211, 22, 62}
Dim intLength As Integer
Dim intRemaining As Integer
Dim objMemoryStream As New MemoryStream
Dim objCryptoStream As CryptoStream
Dim objRijndaelMana ged As RijndaelManaged
>
vstrTextToBeEnc rypted =
StripNullCharac ters(vstrTextTo BeEncrypted)
>
bytValue =
Encoding.ASCII. GetBytes(vstrTe xtToBeEncrypted .ToCharArray)
>
intLength = Len(vstrEncrypt ionKey)
>
If intLength >= 32 Then
vstrEncryptionK ey = Strings.Left(vs trEncryptionKey , 32)
Else
intLength = Len(vstrEncrypt ionKey)
intRemaining = 32 - intLength
vstrEncryptionK ey = vstrEncryptionK ey &
Strings.StrDup( intRemaining, "X")
End If
>
bytKey = Encoding.ASCII. GetBytes(vstrEn cryptionKey.ToC harArray)
>
objRijndaelMana ged = New RijndaelManaged
>
Try
objCryptoStream = New CryptoStream(ob jMemoryStream,
objRijndaelMana ged.CreateEncry ptor(bytKey, bytIV),
CryptoStreamMod e.Write)
objCryptoStream .Write(bytValue , 0, bytValue.Length )
objCryptoStream .FlushFinalBloc k()
bytEncoded = objMemoryStream .ToArray
objMemoryStream .Close()
objCryptoStream .Close()
Catch
>
End Try
>
Return Convert.ToBase6 4String(bytEnco ded)
>
End Function
>
Public Function DecryptString12 8Bit(ByVal vstrStringToBeD ecrypted
As String, ByVal vstrDecryptionK ey As String) As String
>
Dim bytDataToBeDecr ypted() As Byte
Dim bytTemp() As Byte
Dim bytIV() As Byte = {121, 241, 10, 1, 132, 74, 11, 39, 255,
91, 45, 78, 14, 211, 22, 62}
Dim objRijndaelMana ged As New RijndaelManaged
Dim objMemoryStream As MemoryStream
Dim objCryptoStream As CryptoStream
Dim bytDecryptionKe y() As Byte
Dim intLength As Integer
Dim intRemaining As Integer
Dim intCtr As Integer
Dim strReturnString As String = String.Empty
Dim achrCharacterAr ray() As Char
Dim intIndex As Integer
>
bytDataToBeDecr ypted =
Convert.FromBas e64String(vstrS tringToBeDecryp ted)
>
intLength = Len(vstrDecrypt ionKey)
>
If intLength >= 32 Then
vstrDecryptionK ey = Strings.Left(vs trDecryptionKey , 32)
Else
intLength = Len(vstrDecrypt ionKey)
intRemaining = 32 - intLength
vstrDecryptionK ey = vstrDecryptionK ey &
Strings.StrDup( intRemaining, "X")
End If
>
bytDecryptionKe y =
Encoding.ASCII. GetBytes(vstrDe cryptionKey.ToC harArray)
>
ReDim bytTemp(bytData ToBeDecrypted.L ength)
>
objMemoryStream = New MemoryStream(by tDataToBeDecryp ted)
>
Try
>
objCryptoStream = New CryptoStream(ob jMemoryStream,
objRijndaelMana ged.CreateDecry ptor(bytDecrypt ionKey, bytIV),
CryptoStreamMod e.Read)
objCryptoStream .Read(bytTemp, 0, bytTemp.Length)
objCryptoStream .FlushFinalBloc k()
objMemoryStream .Close()
objCryptoStream .Close()
>
Catch
>
End Try
>
Return StripNullCharac ters(Encoding.A SCII.GetString( bytTemp))
>
End Function
>
>
Public Function StripNullCharac ters(ByVal vstrStringWithN ulls As
String) As String
>
Dim intPosition As Integer
Dim strStringWithOu tNulls As String
>
intPosition = 1
strStringWithOu tNulls = vstrStringWithN ulls
>
Do While intPosition 0
intPosition = InStr(intPositi on, vstrStringWithN ulls,
vbNullChar)
>
If intPosition 0 Then
strStringWithOu tNulls = Left$(strString WithOutNulls,
intPosition - 1) & _
Right$(strStrin gWithOutNulls,
Len(strStringWi thOutNulls) - intPosition)
End If
>
If intPosition strStringWithOu tNulls.Length Then
Exit Do
End If
Loop
>
Return strStringWithOu tNulls
>
End Function
>
End Module
>
*************** *************** *************** *************** *************** *************
>
Miro wrote:

>Thanks Izzy,
>Dont look too hard for it,
>>
>I created my own "encryption array" and flush out certain chars with
>others
>depending on what value it links up to
>with my encryption table.
>>
>Just wondering if there is an easier way. :)
>>
>I have a work around though.
>>
>Example ( and keep in mind that i have all the alphabet here )
>EncryptionKe y1 = { A, C, B, D, E, .... }
>EncryptionKe y2 = { C, D, B, A, E, .... ) 'includes all letters upper and
>lower, and also some ascii chars.
>and so on ..
>>
>Basically if I have a Password that allows for a length of 10. I
>actually
>store the database as an 11 char field and the first
>char is a 123...
>If I have the #2 stored in that field and and A was in the pword, then it
>gets replaced with a letter C.
>If its a B, a D gets put in its spot, and an E, ( in this case stays as
>an
>E )
>>
>I select a random number from 1 to how many encryption keys i have and
>thats
>the one i use to encrypt it.
>Whenever I have to write to the database and I de-crypt it, I re-encrypt
>it
>with a different Encryption key.
>>
>Its simple, and with 30 encryption keys, it does its job.
>Any letters that are not in the Encryption key or something like a
>special
>char, doesnt get convrted and stays as is.
>>
>M.
>>
>>
>>
>"Izzy" <israel.richner @gmail.comwrote in message
>news:115905301 4.114809.148840 @i42g2000cwa.go oglegroups.com. ..

Will post the encryption code on Monday, I don't remember who wrote,
but it works great. I use it to store passwords in an access table.
>
Check back Monday after 8AM Central Time.
>
Izzy
>
>
Miro wrote:
>Izzy,
>>
>Id be interested in that 128 bit encryption - just to see how you do
>it. -
>If you wouldnt mind.
>>
>Ivan,
>I am in the same boat you are, just started learning vb.net
>My code is probably all over the place. I started one step behind and
>create my access table with adox.
>There isnt much info out there. If you need something like that, let
>me
>know. I found some good examples out there,
>but were super hard to find.
>>
>Miro
>>
>"Izzy" <israel.richner @gmail.comwrote in message
>news:115895117 1.143852.231990 @b28g2000cwb.go oglegroups.com. ..
Something to remember is when you destroy an object the memory
doesn't
get released back to the OS instantly. It's not until the GC
(garbage
collector) comes along and cleans up any unused resources.
>
I've had instances where I had to tell the garbage collecter to run
manually: gc.Collect()
>
You'll need that at some point.
>
Additionally Seth was right, passwords should be encrypted when
stored
in an Access file. I have a routine for that too, it will encrypt it
with 128bit encryption then store it in the Access file. I didn't
write
and I can't remember who did.
>
But if you want it I'll post it for you.
>
Izzy
>
Ivan Weiss wrote:
>Izzy, another question.
>>
>Wouldnt you need to destroy the object or dispose of it or anything
>after utilizing? Or will all resources be freed and database
>connection
>be closed automatically once the functions run?
>>
>-Ivan
>>
>*** Sent via Developersdex http://www.developersdex.com ***
>
>

>

[aaron.kempf@gmail.com]

Re: Database Connectivity

you would be better off using Access Data Projects and SQL Server.

VB.net has a negative ROI.

Access Data Projects; things are SOOOOOO much easier






Ivan Weiss wrote:

Izzy,
>
Thanks so much for posting all of that. I am going to load it in and go
through it with a fine tooth comb to make sure I see what you are doing
(not a problem for me).
>
However, I thought the approach would be different and correct me if I
am right or wrong from a general programming with OOP sense.
>
I had thought the approach would be to make a User object and have that
user have various methods such as validate, authenticate, etc... Am I
reading too much into the OOP approach? I just figured any object
(person or item) should be separated by a class but like I said this is
new to me.
>
-Ivan
>
*** Sent via Developersdex http://www.developersdex.com ***

[rowe_newsgroups]

Re: Database Connectivity

VB.net has a negative ROI.

By ROI I assume you mean return on investment? If so on what are you
basing this on?

Access Data Projects; things are SOOOOOO much easier

In my opinion ADPs are not nearly as powerful or as secure as a .Net
solution. Also, using ADPs limits you to SQL Server, limiting which
database systems you could use in the future. (As from what I
understand, the OP's company isn't using SQL Server and may prefer a
different db solution like Oracle).
Some other big benefits of using .Net over Access is the that Access
isn't required on each computer, and you have the option to devolop
solutions on mobile devices.

So Ivan, just remember to think about what the project might devolop
into, and don't limit yourself to a certain set up.

Thanks,

Seth Rowe

Learning VB.Net also means that you don't
aaron.kempf@gma il.com wrote:

you would be better off using Access Data Projects and SQL Server.
>
VB.net has a negative ROI.
>
Access Data Projects; things are SOOOOOO much easier
>
>
>
>
>
>
Ivan Weiss wrote:

Izzy,

Thanks so much for posting all of that. I am going to load it in and go
through it with a fine tooth comb to make sure I see what you are doing
(not a problem for me).

However, I thought the approach would be different and correct me if I
am right or wrong from a general programming with OOP sense.

I had thought the approach would be to make a User object and have that
user have various methods such as validate, authenticate, etc... Am I
reading too much into the OOP approach? I just figured any object
(person or item) should be separated by a class but like I said this is
new to me.

-Ivan

*** Sent via Developersdex http://www.developersdex.com ***

[Spam Catcher]

Re: Database Connectivity

"aaron.kempf@gm ail.com" <aaron.kempf@gm ail.comwrote in
news:1159240509 .939018.117780@ b28g2000cwb.goo glegroups.com:

Access Data Projects; things are SOOOOOO much easier

And harder to maintain too.

[Anon-E-Moose]

Re: Database Connectivity

"rowe_newsgroup s" <rowe_email@yah oo.comwrote in
news:1159303182 .694436.176640@ m73g2000cwd.goo glegroups.com:

>VB.net has a negative ROI.

>
By ROI I assume you mean return on investment? If so on what are you
basing this on?
>

Don't mind Aaron Kemp - I think he's the nutcase of the group ; )

[Spam Catcher]

Re: Database Connectivity

Ivan Weiss <ivan.weiss@eli tefse.comwrote in news:O1qwWoc3GH A.2096
@TK2MSFTNGP05.p hx.gbl:

Would you recommend going with the controls built into Visual Studio,
coding within the subs as I need them, or creating a class to handle all
of my database connectivity.
>
I am guessing a class is the best way for code re-usability but how
would I go about keeping it generic?

Check out LLBLGen for your data layer - they basically provide .NET 3.0
LINQ, OR/M features now ;-)

[aaron.kempf@gmail.com]

Re: Database Connectivity

BS; harder to maintain?
You keep everything in one place!!!

well shit let me just come out and say that .NET causes AIDS.

no facts; i'll just run out and make a claim; ok?

-Aaron


Spam Catcher wrote:

"aaron.kempf@gm ail.com" <aaron.kempf@gm ail.comwrote in
news:1159240509 .939018.117780@ b28g2000cwb.goo glegroups.com:
>

Access Data Projects; things are SOOOOOO much easier

>
And harder to maintain too.

[aaron.kempf@gmail.com]

Re: Database Connectivity

re:
In my opinion ADPs are not nearly as powerful or as secure as a .Net
solution. Also, using ADPs limits you to SQL Server, limiting which
database systems you could use in the future. (As from what I
understand, the OP's company isn't using SQL Server and may prefer a
different db solution like Oracle).
Some other big benefits of using .Net over Access is the that Access
isn't required on each computer, and you have the option to devolop
solutions on mobile devices.


your opinion is wrong.

ADP limits you to SQL Server? SQL Server rules the roost; you're a
fucking idiot if you haven't looked at tpc.org in the past decade.

and you're really; honestly going to use a toolset that takes 3 times
as long; just so that you can put it on a PDA?

get a fucking clue; kids

Mobile is worthless.

ADP runs circles around you kids.

And he should take his Access experience and apply it to Access Data
Projects.

I would rather use a CSV file than MDB.

-Aaron


rowe_newsgroups wrote:

VB.net has a negative ROI.

>
By ROI I assume you mean return on investment? If so on what are you
basing this on?
>

Access Data Projects; things are SOOOOOO much easier

>
In my opinion ADPs are not nearly as powerful or as secure as a .Net
solution. Also, using ADPs limits you to SQL Server, limiting which
database systems you could use in the future. (As from what I
understand, the OP's company isn't using SQL Server and may prefer a
different db solution like Oracle).
Some other big benefits of using .Net over Access is the that Access
isn't required on each computer, and you have the option to devolop
solutions on mobile devices.
>
So Ivan, just remember to think about what the project might devolop
into, and don't limit yourself to a certain set up.
>
Thanks,
>
Seth Rowe
>
Learning VB.Net also means that you don't
aaron.kempf@gma il.com wrote:

you would be better off using Access Data Projects and SQL Server.

VB.net has a negative ROI.

Access Data Projects; things are SOOOOOO much easier






Ivan Weiss wrote:

Izzy,
>
Thanks so much for posting all of that. I am going to load it in and go
through it with a fine tooth comb to make sure I see what you are doing
(not a problem for me).
>
However, I thought the approach would be different and correct me if I
am right or wrong from a general programming with OOP sense.
>
I had thought the approach would be to make a User object and have that
user have various methods such as validate, authenticate, etc... Am I
reading too much into the OOP approach? I just figured any object
(person or item) should be separated by a class but like I said this is
new to me.
>
-Ivan
>
*** Sent via Developersdex http://www.developersdex.com ***

[Izzy]

Re: Database Connectivity

Aaron,

You really should stick with the Access group, you're in love with
Access and completely blinded by love.

It's fine, and sometimes your actually even helpful there.

People who post questions in the .NET group really don't benefit from
your input. They are not going to convert to ADP just because Aaron
says so. You need to go lay on someone's couch and talk about your
frustrations.

Izzy


aaron.kempf@gma il.com wrote:

BS; harder to maintain?
You keep everything in one place!!!
>
well shit let me just come out and say that .NET causes AIDS.
>
no facts; i'll just run out and make a claim; ok?
>
-Aaron
>
>
Spam Catcher wrote:

"aaron.kempf@gm ail.com" <aaron.kempf@gm ail.comwrote in
news:1159240509 .939018.117780@ b28g2000cwb.goo glegroups.com:

Access Data Projects; things are SOOOOOO much easier

And harder to maintain too.

[aaron.kempf@gmail.com]

Re: Database Connectivity

well the kid was talking about using access.

fucking jackass; nobody should use the MDB file format for ANYTHING.
It's not scalable; its not reliable.

It's almost as bad as using Excel.

If he's a friggin loser that uses Access MDB as a database; he might as
well be using Access forms and reports.

-Aaron



Izzy wrote:

Aaron,
>
You really should stick with the Access group, you're in love with
Access and completely blinded by love.
>
It's fine, and sometimes your actually even helpful there.
>
People who post questions in the .NET group really don't benefit from
your input. They are not going to convert to ADP just because Aaron
says so. You need to go lay on someone's couch and talk about your
frustrations.
>
Izzy
>
>
aaron.kempf@gma il.com wrote:

BS; harder to maintain?
You keep everything in one place!!!

well shit let me just come out and say that .NET causes AIDS.

no facts; i'll just run out and make a claim; ok?

-Aaron


Spam Catcher wrote:

"aaron.kempf@gm ail.com" <aaron.kempf@gm ail.comwrote in
news:1159240509 .939018.117780@ b28g2000cwb.goo glegroups.com:
>
Access Data Projects; things are SOOOOOO much easier
>
And harder to maintain too.

[aaron.kempf@gmail.com]

Re: Database Connectivity

oh YAH

LINQ, OR/M

It would help if you knew how to use SQL Server you friggin jackasses
If you're looking for an easy solution to a real database-- use Access
Data Projects.

I can out develop any of you .NET kids on performance, features, price
and performance.

-Aaron


Spam Catcher wrote:

Ivan Weiss <ivan.weiss@eli tefse.comwrote in news:O1qwWoc3GH A.2096
@TK2MSFTNGP05.p hx.gbl:
>

Would you recommend going with the controls built into Visual Studio,
coding within the subs as I need them, or creating a class to handle all
of my database connectivity.

I am guessing a class is the best way for code re-usability but how
would I go about keeping it generic?

>
Check out LLBLGen for your data layer - they basically provide .NET 3.0
LINQ, OR/M features now ;-)

[Spam Catcher]

Re: Database Connectivity

"aaron.kempf@gm ail.com" <aaron.kempf@gm ail.comwrote in
news:1159468582 .587317.5550@i4 2g2000cwa.googl egroups.com:

It would help if you knew how to use SQL Server you friggin jackasses
If you're looking for an easy solution to a real database-- use Access
Data Projects.
>
I can out develop any of you .NET kids on performance, features, price
and performance.

Why rewrite the data layer EVERY time?

Not to mention you'll make mistakes in the SQL - (generated) data access
layer save you from all the hassles.

You still need to know how T-SQL, SQL Server, and Database design ... but
OR/M mappers save you the mundane chore of filling data objects :)