Hi,
I'm having this error in a VB.NET-application at the moment that I attempt
to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is
indicated as installed too:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer =
"2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc.
Does anybody know about thisp roblem? And some solution? Could it be because
of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes,
hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter 26 1178
Hi,
Maybe this will help. You might have to install the latest sql
server service pack. http://support.microsoft.com/default...59&Product=sql
Ken
--------------------
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc.
Does anybody know about thisp roblem? And some solution? Could it be because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
DraguVaso wrote: I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server: The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc.
Does anybody know about thisp roblem? And some solution? Could it be because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Hi DraguVaso,
seems you're not alone: http://groups.google.de/groups?selm=...TNGP10.phx.gbl http://groups.google.de/groups?selm=...40TKMSFTNGXA14
The MDAC Utility: Component Checker might help http://www.microsoft.com/downloads/d...displaylang=en
Cheers
Arne Janning
Hi,
Does it help if you reinstall mdac?
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com www.rthand.com
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a)
pc. Does anybody know about thisp roblem? And some solution? Could it be
because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
I reinstalled it but it doesn't work...
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... Hi,
Does it help if you reinstall mdac?
-- Miha Markic [MVP C#] - RightHand .NET consulting & development miha at rthand com www.rthand.com
"DraguVaso" <pi**********@hotmail.com> wrote in message news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I
attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft
Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it
is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc. Does anybody know about thisp roblem? And some solution? Could it be
because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
Hi Pieter,
And the message from Ken, I was not looking for you because I thought that
was it?
Cor
It doesn't have much to do with that:
- VS.NET is not installed, so reisntalling won't do much :-)
- I use the framwork 1.1 an VS.NET 2003, not 1.0 and 2002 (for which the
article is made)
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:u6**************@TK2MSFTNGP09.phx.gbl... Hi,
Maybe this will help. You might have to install the latest sql server service pack. http://support.microsoft.com/default...59&Product=sql
Ken -------------------- "DraguVaso" <pi**********@hotmail.com> wrote in message news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I
attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft
Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it
is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc.
Does anybody know about thisp roblem? And some solution? Could it be because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
See thread: it doesn't have much to do with that. I'm gonna try to look with
the Component Checker, and do some trial and error :-)
Maybe MDAC 2.8 will help. And would Jet have something to do with it?
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl... Hi Pieter,
And the message from Ken, I was not looking for you because I thought that was it?
Cor
DraguVaso wrote: Maybe MDAC 2.8 will help. And would Jet have something to do with it?
Wild guess: Do you use Windows Update? A recent critical update included a
JET update, and since then my Access 2003 seems to be a little bit confused.
See http://groups.google.com/groups?lr=&...tngp13.phx.gbl
Boris
Ok, I modified my source-code a little bit so I can se where it goes wrong:
This is my function:
Private Sub ShowClientInfo(ByVal strIndice As String)
If strIndice.Length <= 0 Then
txtInfo.Text = "No Identification"
Exit Sub
End If
Dim strSql As String
strSql = "SELECT TOP 1 (tdprNFoy + tdprNCCD) AS DossierNr,
(tcliLSigl1 + ' ' + tcliLNomPren1) AS Cl1, " & _
"(tcliLSigl2 + ' ' + tcliLNomPren2) AS Cl2, tdcaNCartphy, Auto,
Choice " & _
"FROM tblCalls LEFT JOIN tblDossiers ON tblCalls.DossierID =
tblDossiers.DossierID " & _
"WHERE (Indice = '" & strIndice & "') " & _
"ORDER BY CallID DESC"
MessageBox.Show("a1")
Dim dtrSql As SqlDataReader
Dim conSql As SqlConnection
conSql = New SqlConnection(strConn)
Dim cmdSql As SqlCommand
MessageBox.Show("a2" & conSql.ConnectionString)
Try
MessageBox.Show("a3")
conSql.Open()
MessageBox.Show("a4")
cmdSql = New SqlCommand(strSql, conSql)
MessageBox.Show("b")
dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow)
MessageBox.Show("c")
dtrSql.Read()
MessageBox.Show("d")
If dtrSql.HasRows Then
MessageBox.Show("e")
strDossierNr = dtrSql.Item("DossierNr").ToString
MessageBox.Show("f")
txtInfo.Text = "DOSSIER: " & strDossierNr & cstDelimit & _
"CARD: " & dtrSql.Item("tdcaNCartphy").ToString & cstDelimit
& _
dtrSql.Item("Choice").ToString & cstDelimit & vbCrLf & _
dtrSql.Item("Cl1").ToString & ", " &
dtrSql.Item("Cl2").ToString
MessageBox.Show("g")
If chkAuto.Checked Then
'Auto-handeling doen
Select Case dtrSql.Item("Auto").ToString
Case "SAVE"
Dim clsVBS As New clsVBScripts
clsVBS.SAVE(strDossierNr)
clsVBS = Nothing
Case "CONT"
Dim clsVBS As New clsVBScripts
clsVBS.CONT(strDossierNr)
clsVBS = Nothing
End Select
End If
Else
MessageBox.Show("Failed to Load Call Data", "Call Data
Failure", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
End If
Catch ex As Exception
ErrorMessage(Me, ex, "Failed to Load Call Data", "Call Data
Failure")
Finally
MessageBox.Show("k")
dtrSql.Close()
MessageBox.Show("k1")
cmdSql.Dispose()
MessageBox.Show("k2")
If conSql.State = ConnectionState.Open Then
MessageBox.Show("l")
conSql.Close()
End If
MessageBox.Show("m")
dtrSql = Nothing
cmdSql = Nothing
conSql = Nothing
MessageBox.Show("n")
End Try
End Sub
I get this messageboxes: a1, a2, a3, than the error, k
So the error seems to happen on the "conSql.Open()"-statement.
Really weird is also that it only shows the "k" of the finally, and not the
k1, k2, l, m and n... :-(
And much weirder: I managed to get it working one time again, but the next
time it didn't work anymore :-( So it works kind of randomly: 2 times it
worked, +- 15 times it didn't work... :-( Couldn't it be because something
on the SQL Server?
please help :-(
Pieter
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Of**************@TK2MSFTNGP12.phx.gbl... Ok: some 'funny' results:
I installed JET 4.0 SP7: It worked once (ONCE!!), and afterwarths I got
the same error... :-(
Than I installed JET 4.0 SP8 and MDAC 2.8: It still doesn't work, but the Error-message is different now: Object reference not set to an instance of an object. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
I'm still not able to find out what causes the problem and how to find a resolution :-( Any help would really be appreciated!! The weird thing is that it only happens on one pc (NT SP6a), on the others I tested it (a
2000 and a NT SP6A) it works fine...
Thanks in advance,
Pieter "DraguVaso" <pi**********@hotmail.com> wrote in message news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I
attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft
Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it
is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc. Does anybody know about thisp roblem? And some solution? Could it be
because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
No I dodn't use Windows Update on these pc's. In fact there are all NT, and
there isn't any Windows Update on NT (or am I wrong?).
As a matter of fact: I use Windows Update on my pc, and here it works? Maybe
I should use Windows Update? hehe :-)
"Boris" <bo***@gtemail.net> wrote in message
news:OU****************@TK2MSFTNGP10.phx.gbl... DraguVaso wrote: Maybe MDAC 2.8 will help. And would Jet have something to do with it? Wild guess: Do you use Windows Update? A recent critical update included a JET update, and since then my Access 2003 seems to be a little bit
confused. See http://groups.google.com/groups?lr=&...tngp13.phx.gbl Boris
I tryed that, but it didn't work: the error becomes now:
Object reference not set to an instance of an object. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
"scorpion53061" <sc************@nospamhereeveryahoo.com> wrote in message
news:u5****************@tk2msftngp13.phx.gbl... reinstall jet.
http://www.microsoft.com/downloads/d...displaylang=en It is time. Then reinstall MDAC 2.8.
This error normally occurs when a connection cannot be established with the
server.
Create a new project (do not use anything from this current project you are
in) and attempt to create a connection there. Don't get fancy.
If this does not work, copy and paste here the code you are using.
If this does not work then
1. reinstall Jet
2. reinstall the Framework
3. Reinstall MDAC 2.8
If this does not work reinstall Windows. Others may disagree with me but
trying all this if it fails it is clear the corrpution is in your operating
environment.
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:ur****************@TK2MSFTNGP12.phx.gbl... I tryed that, but it didn't work: the error becomes now: Object reference not set to an instance of an object. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
"scorpion53061" <sc************@nospamhereeveryahoo.com> wrote in message news:u5****************@tk2msftngp13.phx.gbl... reinstall jet.
http://www.microsoft.com/downloads/d...displaylang=en It is time. Then reinstall MDAC 2.8.
Hi,
Make sure that the MDAC is also installed on the database server.
Leo
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a)
pc. Does anybody know about thisp roblem? And some solution? Could it be
because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
MDAC 2.7 SP1 REFRESH is isntalled on the Server...
"Leo Muller" <le***@keshet-i.com> wrote in message
news:c9**********@news2.netvision.net.il... Hi,
Make sure that the MDAC is also installed on the database server.
Leo
"DraguVaso" <pi**********@hotmail.com> wrote in message news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I
attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft
Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it
is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc. Does anybody know about thisp roblem? And some solution? Could it be
because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
Ok, today's news: I tested it: it worked once, than it didn't work anymore.
After that I made a small Test-appliation to test the conenction: I make my
connection etc the same way as in my application, and it works all the
time!!
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim strConn As String
strConn = "Server=BESQL1;DataBase=VocalcomCetelem;User
ID=vocalcomcetelem;Password=vocalcomcetelem;Truste d_Connection=False"
Dim strSql As String
strSql = "SELECT TOP 1 * " & _
"FROM tblCalls " & _
"ORDER BY CallID DESC"
Dim dtrSql As SqlDataReader
Dim conSql As SqlConnection
conSql = New SqlConnection(strConn)
Dim cmdSql As SqlCommand
Try
conSql.Open()
cmdSql = New SqlCommand(strSql, conSql)
dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow)
dtrSql.Read()
If dtrSql.HasRows Then
MessageBox.Show(dtrSql.Item("tdcaNCartphy").ToStri ng)
End If
Catch ex As Exception
MessageBox.Show(ex.Message & ex.StackTrace)
End Try
End Sub
Afterwurths I did some more tests with my application: on one pc it still
didn't work, on the other miraculously it worked 6-7 times one after the
other without error!! I really can't get it why it works sometimes and other
times it doesn't.
Are there 'better' ways to open the connection? Maybe I should make my query
on another way so it doesn't need to open the connection like this? Or I
don't know how?
Thanks, Pieter
"scorpion53061" <sc************@nospamhereeveryahoo.com> wrote in message
news:ut****************@TK2MSFTNGP09.phx.gbl... This error normally occurs when a connection cannot be established with
the server.
Create a new project (do not use anything from this current project you
are in) and attempt to create a connection there. Don't get fancy.
If this does not work, copy and paste here the code you are using.
If this does not work then
1. reinstall Jet 2. reinstall the Framework 3. Reinstall MDAC 2.8
If this does not work reinstall Windows. Others may disagree with me but trying all this if it fails it is clear the corrpution is in your
operating environment.
"DraguVaso" <pi**********@hotmail.com> wrote in message news:ur****************@TK2MSFTNGP12.phx.gbl... I tryed that, but it didn't work: the error becomes now: Object reference not set to an instance of an object. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
"scorpion53061" <sc************@nospamhereeveryahoo.com> wrote in
message news:u5****************@tk2msftngp13.phx.gbl... reinstall jet.
http://www.microsoft.com/downloads/d...displaylang=en It is time. Then reinstall MDAC 2.8.
> After that I made a small Test-appliation to test the conenction: I make
my connection etc the same way as in my application, and it works all the time!! "scorpion53061" <sc************@nospamhereeveryahoo.com> wrote in message news:ut****************@TK2MSFTNGP09.phx.gbl... This error normally occurs when a connection cannot be established with the server.
connection issue just like I had said!! :)
Hi,
Obviously the connection has problems, that's why it can't open it, and in
your "finally" part it can't close it either, since it wasn't opened.
I think you can isolate the problem by just creating the connection, open
and close it. The same will happen then.
If the connection does work sometimes, then there isn't anything wrong with
your application, or MDAC. Rather you may be experiencing a network problem,
or a SQL problem.
use try and catch while opening the connection, and check the error
description and source that it will return.
Leo
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:O4****************@TK2MSFTNGP11.phx.gbl... Ok, I modified my source-code a little bit so I can se where it goes
wrong: This is my function:
Private Sub ShowClientInfo(ByVal strIndice As String) If strIndice.Length <= 0 Then txtInfo.Text = "No Identification" Exit Sub End If
Dim strSql As String strSql = "SELECT TOP 1 (tdprNFoy + tdprNCCD) AS DossierNr, (tcliLSigl1 + ' ' + tcliLNomPren1) AS Cl1, " & _ "(tcliLSigl2 + ' ' + tcliLNomPren2) AS Cl2, tdcaNCartphy, Auto, Choice " & _ "FROM tblCalls LEFT JOIN tblDossiers ON tblCalls.DossierID = tblDossiers.DossierID " & _ "WHERE (Indice = '" & strIndice & "') " & _ "ORDER BY CallID DESC"
MessageBox.Show("a1") Dim dtrSql As SqlDataReader Dim conSql As SqlConnection conSql = New SqlConnection(strConn) Dim cmdSql As SqlCommand MessageBox.Show("a2" & conSql.ConnectionString) Try MessageBox.Show("a3") conSql.Open() MessageBox.Show("a4") cmdSql = New SqlCommand(strSql, conSql) MessageBox.Show("b") dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow) MessageBox.Show("c") dtrSql.Read() MessageBox.Show("d") If dtrSql.HasRows Then MessageBox.Show("e") strDossierNr = dtrSql.Item("DossierNr").ToString MessageBox.Show("f") txtInfo.Text = "DOSSIER: " & strDossierNr & cstDelimit & _ "CARD: " & dtrSql.Item("tdcaNCartphy").ToString &
cstDelimit & _ dtrSql.Item("Choice").ToString & cstDelimit & vbCrLf & _ dtrSql.Item("Cl1").ToString & ", " & dtrSql.Item("Cl2").ToString MessageBox.Show("g") If chkAuto.Checked Then 'Auto-handeling doen Select Case dtrSql.Item("Auto").ToString Case "SAVE" Dim clsVBS As New clsVBScripts clsVBS.SAVE(strDossierNr) clsVBS = Nothing
Case "CONT" Dim clsVBS As New clsVBScripts clsVBS.CONT(strDossierNr) clsVBS = Nothing
End Select End If Else MessageBox.Show("Failed to Load Call Data", "Call Data Failure", MessageBoxButtons.OK, MessageBoxIcon.Exclamation) End If
Catch ex As Exception ErrorMessage(Me, ex, "Failed to Load Call Data", "Call Data Failure") Finally MessageBox.Show("k") dtrSql.Close() MessageBox.Show("k1") cmdSql.Dispose() MessageBox.Show("k2") If conSql.State = ConnectionState.Open Then MessageBox.Show("l") conSql.Close() End If MessageBox.Show("m") dtrSql = Nothing cmdSql = Nothing conSql = Nothing MessageBox.Show("n") End Try
End Sub
I get this messageboxes: a1, a2, a3, than the error, k So the error seems to happen on the "conSql.Open()"-statement. Really weird is also that it only shows the "k" of the finally, and not
the k1, k2, l, m and n... :-(
And much weirder: I managed to get it working one time again, but the next time it didn't work anymore :-( So it works kind of randomly: 2 times it worked, +- 15 times it didn't work... :-( Couldn't it be because something on the SQL Server?
please help :-(
Pieter
"DraguVaso" <pi**********@hotmail.com> wrote in message news:Of**************@TK2MSFTNGP12.phx.gbl... Ok: some 'funny' results:
I installed JET 4.0 SP7: It worked once (ONCE!!), and afterwarths I got the same error... :-(
Than I installed JET 4.0 SP8 and MDAC 2.8: It still doesn't work, but
the Error-message is different now: Object reference not set to an instance of an object. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
I'm still not able to find out what causes the problem and how to find a resolution :-( Any help would really be appreciated!! The weird thing is that it only happens on one pc (NT SP6a), on the others I tested it (a 2000 and a NT SP6A) it works fine...
Thanks in advance,
Pieter "DraguVaso" <pi**********@hotmail.com> wrote in message news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry
it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp
6a) pc. Does anybody know about thisp roblem? And some solution? Could it be
because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20
minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really
appreciated! Pieter
I made a small test-application, and that works all the time (tested it
20-30 times), but the 'real' application works like 20% of the time.
My test-application:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim strConn As String
strConn = "Server=BESQL1;DataBase=VocalcomCetelem;User
ID=vocalcomcetelem;Password=vocalcomcetelem;Truste d_Connection=False"
Dim strSql As String
strSql = "SELECT TOP 1 * " & _
"FROM tblCalls " & _
"ORDER BY CallID DESC"
Dim dtrSql As SqlDataReader
Dim conSql As SqlConnection
conSql = New SqlConnection(strConn)
Dim cmdSql As SqlCommand
Try
conSql.Open()
cmdSql = New SqlCommand(strSql, conSql)
dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow)
dtrSql.Read()
If dtrSql.HasRows Then
MessageBox.Show(dtrSql.Item("tdcaNCartphy").ToStri ng)
End If
Catch ex As Exception
MessageBox.Show(ex.Message & ex.StackTrace)
End Try
End Sub
The error's:
Like this with MDAC 2.7 installed:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
Access Components(MDAC) version 2.6 or later.
at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
Or this with MDAC 2.8:
Object reference not set to an instance of an object.
at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
Any idea? :-(
"Leo Muller" <le***@keshet-i.com> wrote in message
news:c9**********@news2.netvision.net.il... Hi,
Obviously the connection has problems, that's why it can't open it, and in your "finally" part it can't close it either, since it wasn't opened.
I think you can isolate the problem by just creating the connection, open and close it. The same will happen then.
If the connection does work sometimes, then there isn't anything wrong
with your application, or MDAC. Rather you may be experiencing a network
problem, or a SQL problem.
use try and catch while opening the connection, and check the error description and source that it will return.
Leo
"DraguVaso" <pi**********@hotmail.com> wrote in message news:O4****************@TK2MSFTNGP11.phx.gbl... Ok, I modified my source-code a little bit so I can se where it goes wrong: This is my function:
Private Sub ShowClientInfo(ByVal strIndice As String) If strIndice.Length <= 0 Then txtInfo.Text = "No Identification" Exit Sub End If
Dim strSql As String strSql = "SELECT TOP 1 (tdprNFoy + tdprNCCD) AS DossierNr, (tcliLSigl1 + ' ' + tcliLNomPren1) AS Cl1, " & _ "(tcliLSigl2 + ' ' + tcliLNomPren2) AS Cl2, tdcaNCartphy, Auto, Choice " & _ "FROM tblCalls LEFT JOIN tblDossiers ON tblCalls.DossierID = tblDossiers.DossierID " & _ "WHERE (Indice = '" & strIndice & "') " & _ "ORDER BY CallID DESC"
MessageBox.Show("a1") Dim dtrSql As SqlDataReader Dim conSql As SqlConnection conSql = New SqlConnection(strConn) Dim cmdSql As SqlCommand MessageBox.Show("a2" & conSql.ConnectionString) Try MessageBox.Show("a3") conSql.Open() MessageBox.Show("a4") cmdSql = New SqlCommand(strSql, conSql) MessageBox.Show("b") dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow) MessageBox.Show("c") dtrSql.Read() MessageBox.Show("d") If dtrSql.HasRows Then MessageBox.Show("e") strDossierNr = dtrSql.Item("DossierNr").ToString MessageBox.Show("f") txtInfo.Text = "DOSSIER: " & strDossierNr & cstDelimit &
_ "CARD: " & dtrSql.Item("tdcaNCartphy").ToString & cstDelimit & _ dtrSql.Item("Choice").ToString & cstDelimit & vbCrLf & _ dtrSql.Item("Cl1").ToString & ", " & dtrSql.Item("Cl2").ToString MessageBox.Show("g") If chkAuto.Checked Then 'Auto-handeling doen Select Case dtrSql.Item("Auto").ToString Case "SAVE" Dim clsVBS As New clsVBScripts clsVBS.SAVE(strDossierNr) clsVBS = Nothing
Case "CONT" Dim clsVBS As New clsVBScripts clsVBS.CONT(strDossierNr) clsVBS = Nothing
End Select End If Else MessageBox.Show("Failed to Load Call Data", "Call Data Failure", MessageBoxButtons.OK, MessageBoxIcon.Exclamation) End If
Catch ex As Exception ErrorMessage(Me, ex, "Failed to Load Call Data", "Call Data Failure") Finally MessageBox.Show("k") dtrSql.Close() MessageBox.Show("k1") cmdSql.Dispose() MessageBox.Show("k2") If conSql.State = ConnectionState.Open Then MessageBox.Show("l") conSql.Close() End If MessageBox.Show("m") dtrSql = Nothing cmdSql = Nothing conSql = Nothing MessageBox.Show("n") End Try
End Sub
I get this messageboxes: a1, a2, a3, than the error, k So the error seems to happen on the "conSql.Open()"-statement. Really weird is also that it only shows the "k" of the finally, and not the k1, k2, l, m and n... :-(
And much weirder: I managed to get it working one time again, but the
next time it didn't work anymore :-( So it works kind of randomly: 2 times it worked, +- 15 times it didn't work... :-( Couldn't it be because
something on the SQL Server?
please help :-(
Pieter
"DraguVaso" <pi**********@hotmail.com> wrote in message news:Of**************@TK2MSFTNGP12.phx.gbl... Ok: some 'funny' results:
I installed JET 4.0 SP7: It worked once (ONCE!!), and afterwarths I
got the same error... :-(
Than I installed JET 4.0 SP8 and MDAC 2.8: It still doesn't work, but the Error-message is different now: Object reference not set to an instance of an object. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
I'm still not able to find out what causes the problem and how to find
a resolution :-( Any help would really be appreciated!! The weird thing
is that it only happens on one pc (NT SP6a), on the others I tested it (a 2000 and a NT SP6A) it works fine...
Thanks in advance,
Pieter "DraguVaso" <pi**********@hotmail.com> wrote in message news:%2****************@tk2msftngp13.phx.gbl... > Hi, > > I'm having this error in a VB.NET-application at the moment that I attempt > to read data from an SQL Server: > > > The .Net Data SQL Provider (System.Data.SqlClient) requires
Microsoft Data > Access Components(MDAC) version 2.6 or later. at > System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) > at >
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec > tionString options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > Failed to Load Call Data Call Data Failure > > > However the MDAC 2.7 is installed! And when I look into the registry it is > indicated as installed too: > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = > "2.71.9040.2" > > The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc. > > Does anybody know about thisp roblem? And some solution? Could it be because > of some restictions (although I do have full Admin rights on the
pc). > > I'ts really urgent and bothering me (I have to do a demo in 20 minutes, > hehe). > > Thanks a lot in advance, any help, hints etc will be really appreciated! > > Pieter > >
Ok I finally found out what caused the problem: Fasten your seatbelts:
The EXTRA.System-object conflcited with the SetWindowsHookEx-function. Both
of them worked fine, and there wasn't anything to see at it. But they caused
sometimes an error on the Database-Connection...
Disabling these functions on NT (and now finding an other solution for that
part) fixed the problem.
Thanks a lot to averything who helped me looking for a solution.
Pieter
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... Hi,
I'm having this error in a VB.NET-application at the moment that I attempt to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is indicated as installed too: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = "2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a)
pc. Does anybody know about thisp roblem? And some solution? Could it be
because of some restictions (although I do have full Admin rights on the pc).
I'ts really urgent and bothering me (I have to do a demo in 20 minutes, hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
> Thanks a lot to averything who helped me looking for a solution.
Pieter
I am happy you finally were able to put this baby to bed!!
Hehe thanks :-)
I hope if I'll ever have children they won't be such a pain in the ass :-)
Although, one advantage children have above software is that you can beat
them up ;-)
"scorpion53061" <sc************@nospamhereeveryahoo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl... Thanks a lot to averything who helped me looking for a solution.
Pieter
I am happy you finally were able to put this baby to bed!!
Hi, I also have just started to experience the MDAC required messages even
though I installed 2.7 and then 2.8.
My situation is a bit different though. I was developing on a Windows 2000
Server machine with Visual Studio .Net 2002 and then I upgraded the OS to
Windows Server 2003 and that's when I started to get the error messages.
I can connect using the OracleClient Connection objects but not the
Oledb.Connection objects?
Is there something special I have to do with Windows Server 2003.
Thanks,
Patrick
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:eE**************@TK2MSFTNGP09.phx.gbl... I made a small test-application, and that works all the time (tested it 20-30 times), but the 'real' application works like 20% of the time.
My test-application: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strConn As String strConn = "Server=BESQL1;DataBase=VocalcomCetelem;User ID=vocalcomcetelem;Password=vocalcomcetelem;Truste d_Connection=False"
Dim strSql As String strSql = "SELECT TOP 1 * " & _ "FROM tblCalls " & _ "ORDER BY CallID DESC"
Dim dtrSql As SqlDataReader Dim conSql As SqlConnection conSql = New SqlConnection(strConn) Dim cmdSql As SqlCommand Try conSql.Open() cmdSql = New SqlCommand(strSql, conSql) dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow) dtrSql.Read() If dtrSql.HasRows Then MessageBox.Show(dtrSql.Item("tdcaNCartphy").ToStri ng) End If Catch ex As Exception MessageBox.Show(ex.Message & ex.StackTrace) End Try
End Sub
The error's: Like this with MDAC 2.7 installed: The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Or this with MDAC 2.8: Object reference not set to an instance of an object. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
Any idea? :-(
"Leo Muller" <le***@keshet-i.com> wrote in message news:c9**********@news2.netvision.net.il... Hi,
Obviously the connection has problems, that's why it can't open it, and
in your "finally" part it can't close it either, since it wasn't opened.
I think you can isolate the problem by just creating the connection,
open and close it. The same will happen then.
If the connection does work sometimes, then there isn't anything wrong with your application, or MDAC. Rather you may be experiencing a network problem, or a SQL problem.
use try and catch while opening the connection, and check the error description and source that it will return.
Leo
"DraguVaso" <pi**********@hotmail.com> wrote in message news:O4****************@TK2MSFTNGP11.phx.gbl... Ok, I modified my source-code a little bit so I can se where it goes wrong: This is my function:
Private Sub ShowClientInfo(ByVal strIndice As String) If strIndice.Length <= 0 Then txtInfo.Text = "No Identification" Exit Sub End If
Dim strSql As String strSql = "SELECT TOP 1 (tdprNFoy + tdprNCCD) AS DossierNr, (tcliLSigl1 + ' ' + tcliLNomPren1) AS Cl1, " & _ "(tcliLSigl2 + ' ' + tcliLNomPren2) AS Cl2, tdcaNCartphy,
Auto, Choice " & _ "FROM tblCalls LEFT JOIN tblDossiers ON tblCalls.DossierID = tblDossiers.DossierID " & _ "WHERE (Indice = '" & strIndice & "') " & _ "ORDER BY CallID DESC"
MessageBox.Show("a1") Dim dtrSql As SqlDataReader Dim conSql As SqlConnection conSql = New SqlConnection(strConn) Dim cmdSql As SqlCommand MessageBox.Show("a2" & conSql.ConnectionString) Try MessageBox.Show("a3") conSql.Open() MessageBox.Show("a4") cmdSql = New SqlCommand(strSql, conSql) MessageBox.Show("b") dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow) MessageBox.Show("c") dtrSql.Read() MessageBox.Show("d") If dtrSql.HasRows Then MessageBox.Show("e") strDossierNr = dtrSql.Item("DossierNr").ToString MessageBox.Show("f") txtInfo.Text = "DOSSIER: " & strDossierNr & cstDelimit
& _ "CARD: " & dtrSql.Item("tdcaNCartphy").ToString & cstDelimit & _ dtrSql.Item("Choice").ToString & cstDelimit & vbCrLf &
_ dtrSql.Item("Cl1").ToString & ", " & dtrSql.Item("Cl2").ToString MessageBox.Show("g") If chkAuto.Checked Then 'Auto-handeling doen Select Case dtrSql.Item("Auto").ToString Case "SAVE" Dim clsVBS As New clsVBScripts clsVBS.SAVE(strDossierNr) clsVBS = Nothing
Case "CONT" Dim clsVBS As New clsVBScripts clsVBS.CONT(strDossierNr) clsVBS = Nothing
End Select End If Else MessageBox.Show("Failed to Load Call Data", "Call Data Failure", MessageBoxButtons.OK, MessageBoxIcon.Exclamation) End If
Catch ex As Exception ErrorMessage(Me, ex, "Failed to Load Call Data", "Call
Data Failure") Finally MessageBox.Show("k") dtrSql.Close() MessageBox.Show("k1") cmdSql.Dispose() MessageBox.Show("k2") If conSql.State = ConnectionState.Open Then MessageBox.Show("l") conSql.Close() End If MessageBox.Show("m") dtrSql = Nothing cmdSql = Nothing conSql = Nothing MessageBox.Show("n") End Try
End Sub
I get this messageboxes: a1, a2, a3, than the error, k So the error seems to happen on the "conSql.Open()"-statement. Really weird is also that it only shows the "k" of the finally, and
not the k1, k2, l, m and n... :-(
And much weirder: I managed to get it working one time again, but the next time it didn't work anymore :-( So it works kind of randomly: 2 times
it worked, +- 15 times it didn't work... :-( Couldn't it be because
something on the SQL Server?
please help :-(
Pieter
"DraguVaso" <pi**********@hotmail.com> wrote in message news:Of**************@TK2MSFTNGP12.phx.gbl... > Ok: some 'funny' results: > > I installed JET 4.0 SP7: It worked once (ONCE!!), and afterwarths I got the > same error... :-( > > Than I installed JET 4.0 SP8 and MDAC 2.8: It still doesn't work,
but the > Error-message is different now: > Object reference not set to an instance of an object. at > System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) > at >
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec > tionString options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > > > I'm still not able to find out what causes the problem and how to
find a > resolution :-( Any help would really be appreciated!! The weird
thing is > that it only happens on one pc (NT SP6a), on the others I tested it
(a 2000 > and a NT SP6A) it works fine... > > Thanks in advance, > > Pieter > > > > "DraguVaso" <pi**********@hotmail.com> wrote in message > news:%2****************@tk2msftngp13.phx.gbl... > > Hi, > > > > I'm having this error in a VB.NET-application at the moment that I attempt > > to read data from an SQL Server: > > > > > > The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data > > Access Components(MDAC) version 2.6 or later. at > > System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& > isInTransaction) > > at > > >
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec > > tionString options, Boolean& isInTransaction) > > at System.Data.SqlClient.SqlConnection.Open() > > Failed to Load Call Data Call Data Failure > > > > > > However the MDAC 2.7 is installed! And when I look into the
registry it is > > indicated as installed too: > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer = > > "2.71.9040.2" > > > > The .NET Framework is installed (1.1), and it is on a Windows NT
(Sp 6a) > pc. > > > > Does anybody know about thisp roblem? And some solution? Could it
be > because > > of some restictions (although I do have full Admin rights on the
pc). > > > > I'ts really urgent and bothering me (I have to do a demo in 20
minutes, > > hehe). > > > > Thanks a lot in advance, any help, hints etc will be really appreciated! > > > > Pieter > > > > > >
Hm I wouldn't know: I got the problem only on Windows NT, and because of a
WindowsKeyHook and a Extra-Session object that conflicted...
"Patrick Yan" <py**@oneshield.com> wrote in message
news:uK**************@TK2MSFTNGP11.phx.gbl... Hi, I also have just started to experience the MDAC required messages even though I installed 2.7 and then 2.8.
My situation is a bit different though. I was developing on a Windows
2000 Server machine with Visual Studio .Net 2002 and then I upgraded the OS to Windows Server 2003 and that's when I started to get the error messages.
I can connect using the OracleClient Connection objects but not the Oledb.Connection objects?
Is there something special I have to do with Windows Server 2003.
Thanks, Patrick
"DraguVaso" <pi**********@hotmail.com> wrote in message news:eE**************@TK2MSFTNGP09.phx.gbl... I made a small test-application, and that works all the time (tested it 20-30 times), but the 'real' application works like 20% of the time.
My test-application: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strConn As String strConn = "Server=BESQL1;DataBase=VocalcomCetelem;User ID=vocalcomcetelem;Password=vocalcomcetelem;Truste d_Connection=False"
Dim strSql As String strSql = "SELECT TOP 1 * " & _ "FROM tblCalls " & _ "ORDER BY CallID DESC"
Dim dtrSql As SqlDataReader Dim conSql As SqlConnection conSql = New SqlConnection(strConn) Dim cmdSql As SqlCommand Try conSql.Open() cmdSql = New SqlCommand(strSql, conSql) dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow) dtrSql.Read() If dtrSql.HasRows Then MessageBox.Show(dtrSql.Item("tdcaNCartphy").ToStri ng) End If Catch ex As Exception MessageBox.Show(ex.Message & ex.StackTrace) End Try
End Sub
The error's: Like this with MDAC 2.7 installed: The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft
Data Access Components(MDAC) version 2.6 or later. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() Or this with MDAC 2.8: Object reference not set to an instance of an object. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open()
Any idea? :-(
"Leo Muller" <le***@keshet-i.com> wrote in message news:c9**********@news2.netvision.net.il... Hi,
Obviously the connection has problems, that's why it can't open it,
and in your "finally" part it can't close it either, since it wasn't opened.
I think you can isolate the problem by just creating the connection, open and close it. The same will happen then.
If the connection does work sometimes, then there isn't anything wrong with your application, or MDAC. Rather you may be experiencing a network problem, or a SQL problem.
use try and catch while opening the connection, and check the error description and source that it will return.
Leo
"DraguVaso" <pi**********@hotmail.com> wrote in message news:O4****************@TK2MSFTNGP11.phx.gbl... > Ok, I modified my source-code a little bit so I can se where it goes wrong: > > This is my function: > > Private Sub ShowClientInfo(ByVal strIndice As String) > If strIndice.Length <= 0 Then > txtInfo.Text = "No Identification" > Exit Sub > End If > > Dim strSql As String > strSql = "SELECT TOP 1 (tdprNFoy + tdprNCCD) AS DossierNr, > (tcliLSigl1 + ' ' + tcliLNomPren1) AS Cl1, " & _ > "(tcliLSigl2 + ' ' + tcliLNomPren2) AS Cl2, tdcaNCartphy, Auto, > Choice " & _ > "FROM tblCalls LEFT JOIN tblDossiers ON tblCalls.DossierID = > tblDossiers.DossierID " & _ > "WHERE (Indice = '" & strIndice & "') " & _ > "ORDER BY CallID DESC" > > MessageBox.Show("a1") > Dim dtrSql As SqlDataReader > Dim conSql As SqlConnection > conSql = New SqlConnection(strConn) > Dim cmdSql As SqlCommand > MessageBox.Show("a2" & conSql.ConnectionString) > Try > MessageBox.Show("a3") > conSql.Open() > MessageBox.Show("a4") > cmdSql = New SqlCommand(strSql, conSql) > MessageBox.Show("b") > dtrSql = cmdSql.ExecuteReader(CommandBehavior.SingleRow) > MessageBox.Show("c") > dtrSql.Read() > MessageBox.Show("d") > If dtrSql.HasRows Then > MessageBox.Show("e") > strDossierNr = dtrSql.Item("DossierNr").ToString > MessageBox.Show("f") > txtInfo.Text = "DOSSIER: " & strDossierNr &
cstDelimit & _ > "CARD: " & dtrSql.Item("tdcaNCartphy").ToString & cstDelimit > & _ > dtrSql.Item("Choice").ToString & cstDelimit & vbCrLf
& _ > dtrSql.Item("Cl1").ToString & ", " & > dtrSql.Item("Cl2").ToString > MessageBox.Show("g") > If chkAuto.Checked Then > 'Auto-handeling doen > Select Case dtrSql.Item("Auto").ToString > Case "SAVE" > Dim clsVBS As New clsVBScripts > clsVBS.SAVE(strDossierNr) > clsVBS = Nothing > > Case "CONT" > Dim clsVBS As New clsVBScripts > clsVBS.CONT(strDossierNr) > clsVBS = Nothing > > End Select > End If > Else > MessageBox.Show("Failed to Load Call Data", "Call
Data > Failure", MessageBoxButtons.OK, MessageBoxIcon.Exclamation) > End If > > Catch ex As Exception > ErrorMessage(Me, ex, "Failed to Load Call Data", "Call Data > Failure") > Finally > MessageBox.Show("k") > dtrSql.Close() > MessageBox.Show("k1") > cmdSql.Dispose() > MessageBox.Show("k2") > If conSql.State = ConnectionState.Open Then > MessageBox.Show("l") > conSql.Close() > End If > MessageBox.Show("m") > dtrSql = Nothing > cmdSql = Nothing > conSql = Nothing > MessageBox.Show("n") > End Try > > End Sub > > > I get this messageboxes: a1, a2, a3, than the error, k > So the error seems to happen on the "conSql.Open()"-statement. > Really weird is also that it only shows the "k" of the finally, and not the > k1, k2, l, m and n... :-( > > And much weirder: I managed to get it working one time again, but
the next > time it didn't work anymore :-( So it works kind of randomly: 2
times it > worked, +- 15 times it didn't work... :-( Couldn't it be because something > on the SQL Server? > > please help :-( > > Pieter > > > "DraguVaso" <pi**********@hotmail.com> wrote in message > news:Of**************@TK2MSFTNGP12.phx.gbl... > > Ok: some 'funny' results: > > > > I installed JET 4.0 SP7: It worked once (ONCE!!), and afterwarths
I got > the > > same error... :-( > > > > Than I installed JET 4.0 SP8 and MDAC 2.8: It still doesn't work, but the > > Error-message is different now: > > Object reference not set to an instance of an object. at > > System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& > isInTransaction) > > at > > >
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec > > tionString options, Boolean& isInTransaction) > > at System.Data.SqlClient.SqlConnection.Open() > > > > > > I'm still not able to find out what causes the problem and how to find a > > resolution :-( Any help would really be appreciated!! The weird thing is > > that it only happens on one pc (NT SP6a), on the others I tested
it (a > 2000 > > and a NT SP6A) it works fine... > > > > Thanks in advance, > > > > Pieter > > > > > > > > "DraguVaso" <pi**********@hotmail.com> wrote in message > > news:%2****************@tk2msftngp13.phx.gbl... > > > Hi, > > > > > > I'm having this error in a VB.NET-application at the moment that
I > attempt > > > to read data from an SQL Server: > > > > > > > > > The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft > Data > > > Access Components(MDAC) version 2.6 or later. at > > > System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& > > isInTransaction) > > > at > > > > > >
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec > > > tionString options, Boolean& isInTransaction) > > > at System.Data.SqlClient.SqlConnection.Open() > > > Failed to Load Call Data Call Data Failure > > > > > > > > > However the MDAC 2.7 is installed! And when I look into the registry it > is > > > indicated as installed too: > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer
= > > > "2.71.9040.2" > > > > > > The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) > > pc. > > > > > > Does anybody know about thisp roblem? And some solution? Could
it be > > because > > > of some restictions (although I do have full Admin rights on the
pc). > > > > > > I'ts really urgent and bothering me (I have to do a demo in 20 minutes, > > > hehe). > > > > > > Thanks a lot in advance, any help, hints etc will be really appreciated! > > > > > > Pieter > > > > > > > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: DraguVaso |
last post by:
Hi,
I'm having this error in a VB.NET-application at the moment that I attempt
to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |