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" <pyan@oneshield.com> wrote in message
news:uK3q32oSEHA.3756@TK2MSFTNGP11.phx.gbl...[color=blue]
> 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[/color]
2000[color=blue]
> 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" <pietercoucke@hotmail.com> wrote in message
> news:eE#HScJSEHA.1160@TK2MSFTNGP09.phx.gbl...[color=green]
> > 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[/color][/color]
Data[color=blue][color=green]
> > Access Components(MDAC) version 2.6 or later.
> > at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
> > isInTransaction)
> > at
> >[/color]
>[/color]
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec[color=blue][color=green]
> > 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
> >[/color]
>[/color]
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec[color=blue][color=green]
> > tionString options, Boolean& isInTransaction)
> > at System.Data.SqlClient.SqlConnection.Open()
> >
> >
> > Any idea? :-(
> >
> > "Leo Muller" <leo-m@keshet-i.com> wrote in message
> > news:c9kcps$ohv$1@news2.netvision.net.il...[color=darkred]
> > > Hi,
> > >
> > > Obviously the connection has problems, that's why it can't open it,[/color][/color][/color]
and[color=blue]
> in[color=green][color=darkred]
> > > 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,[/color][/color]
> open[color=green][color=darkred]
> > > and close it. The same will happen then.
> > >
> > > If the connection does work sometimes, then there isn't anything wrong[/color]
> > with[color=darkred]
> > > your application, or MDAC. Rather you may be experiencing a network[/color]
> > problem,[color=darkred]
> > > 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" <pietercoucke@hotmail.com> wrote in message
> > > news:O4AnFR%23REHA.1448@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,[/color][/color]
> Auto,[color=green][color=darkred]
> > > > 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 &[/color][/color][/color]
cstDelimit[color=blue]
> &[color=green]
> > _[color=darkred]
> > > > "CARD: " & dtrSql.Item("tdcaNCartphy").ToString &
> > > cstDelimit
> > > > & _
> > > > dtrSql.Item("Choice").ToString & cstDelimit & vbCrLf[/color][/color][/color]
&[color=blue]
> _[color=green][color=darkred]
> > > > 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[/color][/color][/color]
Data[color=blue][color=green][color=darkred]
> > > > Failure", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
> > > > End If
> > > >
> > > > Catch ex As Exception
> > > > ErrorMessage(Me, ex, "Failed to Load Call Data", "Call[/color][/color]
> Data[color=green][color=darkred]
> > > > 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[/color][/color]
> not[color=green][color=darkred]
> > > the
> > > > k1, k2, l, m and n... :-(
> > > >
> > > > And much weirder: I managed to get it working one time again, but[/color][/color][/color]
the[color=blue][color=green]
> > next[color=darkred]
> > > > time it didn't work anymore :-( So it works kind of randomly: 2[/color][/color][/color]
times[color=blue]
> it[color=green][color=darkred]
> > > > worked, +- 15 times it didn't work... :-( Couldn't it be because[/color]
> > something[color=darkred]
> > > > on the SQL Server?
> > > >
> > > > please help :-(
> > > >
> > > > Pieter
> > > >
> > > >
> > > > "DraguVaso" <pietercoucke@hotmail.com> wrote in message
> > > > news:Of78XH9REHA.1396@TK2MSFTNGP12.phx.gbl...
> > > > > Ok: some 'funny' results:
> > > > >
> > > > > I installed JET 4.0 SP7: It worked once (ONCE!!), and afterwarths[/color][/color][/color]
I[color=blue][color=green]
> > got[color=darkred]
> > > > the
> > > > > same error... :-(
> > > > >
> > > > > Than I installed JET 4.0 SP8 and MDAC 2.8: It still doesn't work,[/color][/color]
> but[color=green][color=darkred]
> > > 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
> > > > >
> > > >
> > >[/color]
> >[/color]
>[/color]
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec[color=blue][color=green][color=darkred]
> > > > > 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[/color][/color]
> find[color=green]
> > a[color=darkred]
> > > > > resolution :-( Any help would really be appreciated!! The weird[/color][/color]
> thing[color=green]
> > is[color=darkred]
> > > > > that it only happens on one pc (NT SP6a), on the others I tested[/color][/color][/color]
it[color=blue]
> (a[color=green][color=darkred]
> > > > 2000
> > > > > and a NT SP6A) it works fine...
> > > > >
> > > > > Thanks in advance,
> > > > >
> > > > > Pieter
> > > > >
> > > > >
> > > > >
> > > > > "DraguVaso" <pietercoucke@hotmail.com> wrote in message
> > > > > news:%23R5BWv6REHA.3476@tk2msftngp13.phx.gbl...
> > > > > > Hi,
> > > > > >
> > > > > > I'm having this error in a VB.NET-application at the moment that[/color][/color][/color]
I[color=blue][color=green][color=darkred]
> > > > attempt
> > > > > > to read data from an SQL Server:
> > > > > >
> > > > > >
> > > > > > The .Net Data SQL Provider (System.Data.SqlClient) requires[/color]
> > Microsoft[color=darkred]
> > > > Data
> > > > > > Access Components(MDAC) version 2.6 or later. at
> > > > > > System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
> > > > > isInTransaction)
> > > > > > at
> > > > > >
> > > > >
> > > >
> > >[/color]
> >[/color]
>[/color]
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec[color=blue][color=green][color=darkred]
> > > > > > 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[/color][/color]
> registry[color=green][color=darkred]
> > > it
> > > > is
> > > > > > indicated as installed too:
> > > > > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer[/color][/color][/color]
=[color=blue][color=green][color=darkred]
> > > > > > "2.71.9040.2"
> > > > > >
> > > > > > The .NET Framework is installed (1.1), and it is on a Windows NT[/color][/color]
> (Sp[color=green][color=darkred]
> > > 6a)
> > > > > pc.
> > > > > >
> > > > > > Does anybody know about thisp roblem? And some solution? Could[/color][/color][/color]
it[color=blue]
> be[color=green][color=darkred]
> > > > > because
> > > > > > of some restictions (although I do have full Admin rights on the[/color]
> > pc).[color=darkred]
> > > > > >
> > > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
