Michel,
First: I agree that my previous message had a lot of grammatical
failures. I corrected it to quick, while in fact I had no time at that
moment (like in fact now).
Second: As advice, buy a new book, books from 2002 where based on Beta
2002 VB, while even the not Beta VB 2002 was very bad.
In that time is often used the sentence "It is best practise
.........................", simple because the mostly VB6 writers who
were converting there books did not understand things yet. This sentence
exist as well for AdoDB, however probably that is from before the .Net
time and meant that AdoDB was better than DOA. Those best practise
sentences seem to have mostly almost an endless life.
Thirth: although I never use it, can AdoDB be a better choise to use
for application made solely for stand alone, by instance games, simply
because in those cases AdoDB is much quicker (DAO is even quicker but
that is not supported anymore).
Fourth: AdoDb has still to be supported for a while, because it is still
in Visual Studio .Net 2008, because AdoDB is used by converting VB6
programs.
Cor
Huh ???
Because probably noboby including me, wants to answer again on that
dead horse again
And then you start giving wrong answers ? , and i was having the
impression that his question was misunderstood by the rest of the
thread answerers
that is why i gave this thread a new push with my question
As it is a question about AdoDB then you don't by instance know if
this is related with Sharepoint, where was AFAIK a time written by
some people like the about the dispose method.
"It is best practise to use ADODB". About the Dispose this is changed
on the official MSDN pages, I am not aware about the status with
AdoDB.
Wel after rereading this several times , i am still not sure if i
understand you correct
but i give it a shot :
As it is a question about AdoDB then you don't by instance know if this
is related with Sharepoint,
I guess he should have posted his question then in one of the
sharepoint related groups or at least mention sharepoint or any other
valid reasson for using legacy ADODB in .Net
"It is best practise to use ADODB". About the Dispose this is changed
on the official MSDN pages, I am not aware about the status with AdoDB.
AFAIK : the prefered way in .Net languages to access data and data
services is ADO.Net and not ADODB
it as simple as ADO.Net = .Net and ADODB = legacy So if you program
in .Net wich one should be prefered ?
And Dispose why are you still talking about the Dispose thread ?
The book i quoted out was published in 2002 about the same time when
VB.Net was released to the public , so from my perspective the Dispose
rule is as old as .Net is out there .
Michel Posseth [MCP]
http://www.vbdotnetcoder.com
"Cor Ligthert[MVP]" <
[email protected]> schreef in bericht
Because probably noboby including me, wants to answer again on that
dead horse again
As it is a question about AdoDB then you don't by instance know if
this is related with Sharepoint, where was AFAIK a time written by
some people like the about the dispose method.
"It is best practise to use ADODB". About the Dispose this is changed
on the official MSDN pages, I am not aware about the status with
AdoDB.
Cor
Mr. X.
What i am still curious about is the following
I see all these people here giving you answers how to use "Classic"
ADODB in .Net 2008 ( wich i would sure not recomend you to do
unless you have a verry good reasson to do so
Are you aware of the fact that ADO.Net should be prefered in .Net ?
regards
Michel
"Mr. X." <no_spam_please@nospam_please.com> schreef in bericht
Hello.
In earlier applications I did :
Dim conn As Adodb.connetion
... in order to declare a connection string (rest is known).
When I am using dotnet (In VISUAL STUDIO 2008),
The above isn't compiled.
On the aspx page :
...
<
<%@ Page Language="vb" AutoEventWireup="false"
CodeBehind="Default.aspx.vb" Inherits="WebApplication1._Default" %>
in Default.aspx.vb :
==============
Partial Public Class _Default
Inherits System.Web.UI.Page
Dim conn As Adodb.connetion
Protected Sub LoginButton_Click(ByVal sender As Object, ByVal e As
EventArgs)
End Sub
End Class
"Dim conn As Adodb.connetion" is not the correct syntax.
What is the correct syntax ?
Is there any other way to do connection to database (fits to
sql-server 2008) ?
Thanks