473,323 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

"MDAC required" but it's installed...

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
Nov 20 '05 #1
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

Nov 20 '05 #2
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

Nov 20 '05 #3
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

Nov 20 '05 #4
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


Nov 20 '05 #5
Hi Pieter,

And the message from Ken, I was not looking for you because I thought that
was it?

Cor
Nov 20 '05 #6
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


Nov 20 '05 #7
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

Nov 20 '05 #8
Hi Pieter,

Does this page maybe help,

http://msdn.microsoft.com/library/de...Components.asp

Cor
Nov 20 '05 #9
"DraguVaso" <pi**********@hotmail.com> schrieb

I'm having this error in a VB.NET-application at the moment that I
attempt to read data from an SQL Server:


Please post only to the appropriate groups. I don't see that the question is
specific to the VB.net language.
--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

Nov 20 '05 #10
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
Nov 20 '05 #11
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


Nov 20 '05 #12
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

Nov 20 '05 #13
reinstall jet.

http://www.microsoft.com/downloads/d...displaylang=en

It is time. Then reinstall MDAC 2.8.
Nov 20 '05 #14
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.

Nov 20 '05 #15
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.


Nov 20 '05 #16
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

Nov 20 '05 #17
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


Nov 20 '05 #18
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.



Nov 20 '05 #19
> 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!! :)

Nov 20 '05 #20
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



Nov 20 '05 #21
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
>
>



Nov 20 '05 #22
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

Nov 20 '05 #23
>
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!!
Nov 20 '05 #24
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!!

Nov 20 '05 #25
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
> >
> >
>
>



Nov 20 '05 #26
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
> > >
> > >
> >
> >
>
>



Nov 20 '05 #27

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

29
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...
0
isladogs
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...
1
isladogs
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...
0
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...
0
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...
0
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...
1
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)...
1
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...
1
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....
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.