ERROR - no error information available

[Ricardo Magalhães]

Hi,

I using this code, to connect with a paradox file with ASP.NET. The first
time its connect ok, but others times occurs the error:

"ERROR - no error information available"

I close all connection, and this error yet occurs.

Someone knows why this ?

Thanks,
Ricardo
Connection strirng content:
=============== ===

"Driver={Micros oft Paradox Driver (*.db )};DriverID=538 ;Fil=Paradox
5.X;DefaultDir= c:\inetpub\wwwr oot\fafire\web\ graduacao_pagam ento\dados\;Dbq =c:\inetpub\www root\fafire\web \graduacao_paga mento\dados\;Co llatingSequence =ASCII"

Code executed when the button is clicked
=============== =============
Private Sub CustomValidator 1_ServerValidat e(ByVal source As System.Object,
ByVal args As System.Web.UI.W ebControls.Serv erValidateEvent Args) Handles
CustomValidator 1.ServerValidat e

Dim PathAux As String = Server.MapPath( "Web.config ")
Dim PathRoot As String = PathAux.Substri ng(0,
PathAux.IndexOf ("Web.config "))
Dim PastaDados As String = "BD" & Session("ano") &
Session("semest re")

Dim strConString As String = "Driver={Micros oft Paradox Driver
(*.db )};" & _
"DriverID=5 38;" & _
"Fil=Parado x 5.X;" & _
"DefaultDir =" & PathRoot & "dados\;" & _
"Dbq=" & PathRoot & "dados\;" & _
"CollatingSeque nce=ASCII"
Dim objConn As New Odbc.OdbcConnec tion(strConStri ng)
Dim objCmd As New Odbc.OdbcComman d
Dim objDr As Odbc.OdbcDataRe ader

Try
objConn.Close()
objConn.Open()
objCmd.Connecti on = objConn
'============== =============== =============== =============== ============
' Validando Matricula e CPF
'============== =============== =============== =============== ============
objCmd.CommandT ype = CommandType.Tex t
objCmd.CommandT ext = "select
a.alu_nome,a.al u_end,a.alu_num ,a.alu_compl,a. alu_bai,a.alu_c id,a.alu_est,
a.alu_cep,d.cus _cod,d.cus_nome from ALU20052 as a, MAT20052 as c, cursos as
d where c.mat_alun = '" & Trim(txtNrMatr. Text) & "' and a.alu_cpf = '" &
Trim(txtNrCPF.T ext) & "' and c.mat_alun = a.alu_matr and a.alu_cur =
d.cus_cod"
objDr = objCmd.ExecuteR eader(CommandBe havior.CloseCon nection)
If objDr.Read Then ' Matricula Válida
Session("alu_no me") = Trim(objDr("alu _nome"))
Session("mat_al un") = Trim(txtNrMatr. Text)
Session("alun_c pf") = Trim(txtNrCPF.T ext)
Session("alu_en d") =
Trim(oFafire.va lidaDRText(objD r("alu_end")) )
Session("alu_nu m") =
Trim(oFafire.va lidaDRText(objD r("alu_num")) )
Session("alu_co mpl") =
Trim(oFafire.va lidaDRText(objD r("alu_compl")) )
Session("alu_ba i") =
Trim(oFafire.va lidaDRText(objD r("alu_bai")) )
Session("alu_ci d") =
Trim(oFafire.va lidaDRText(objD r("alu_cid")) )
Session("alu_es t") =
Trim(oFafire.va lidaDRText(objD r("alu_est")) )
Session("alu_ce p") =
IIf(Trim(oFafir e.validaDRText( objDr("alu_cep" ))) = "", "50000-000",
Trim(oFafire.va lidaDRText(objD r("alu_cep")) ))
Session("cus_no me") = Trim(objDr("cus _nome"))
args.IsValid = True
Else ' Matricula Inválida
CustomValidator 1.ErrorMessage = "Matricula/CPF Incorreto"
args.IsValid = False
End If

Catch ex As System.Exceptio n
args.IsValid = False
Response.Redire ct("error.aspx? MensagemTexto=" & ex.Message.Trim
& "&MensagemPagin aRetorno=mensal idade_pagamento _entrada.aspx", False)

Finally
If objConn.State = ConnectionState .Open Then objConn.Close()
objConn.Dispose ()
objCmd.Dispose( )
If Not IsNothing(objDr ) Then objDr.Close()
objDr = Nothing
End Try

End Sub

[Sahil Malik [MVP]]

Funny .. with "No Error Information" it is kinda impossible to tell exactly
what is going wrong .. except .. that error is definitely occurring outside
of .NET i..e inside your Odbc driver.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------
---------------

"Ricardo Magalhães" <ri*********@ho tmail.com> wrote in message
news:#0******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I using this code, to connect with a paradox file with ASP.NET. The first
time its connect ok, but others times occurs the error:

"ERROR - no error information available"

I close all connection, and this error yet occurs.

Someone knows why this ?

Thanks,
Ricardo
Connection strirng content:
=============== ===

"Driver={Micros oft Paradox Driver (*.db )};DriverID=538 ;Fil=Paradox
5.X;DefaultDir= c:\inetpub\wwwr oot\fafire\web\ graduacao_pagam ento\dados\;Dbq =
c:\inetpub\wwwr oot\fafire\web\ graduacao_pagam ento\dados\;Col latingSequence= A
SCII"
Code executed when the button is clicked
=============== =============
Private Sub CustomValidator 1_ServerValidat e(ByVal source As System.Object, ByVal args As System.Web.UI.W ebControls.Serv erValidateEvent Args) Handles
CustomValidator 1.ServerValidat e

Dim PathAux As String = Server.MapPath( "Web.config ")
Dim PathRoot As String = PathAux.Substri ng(0,
PathAux.IndexOf ("Web.config "))
Dim PastaDados As String = "BD" & Session("ano") &
Session("semest re")

Dim strConString As String = "Driver={Micros oft Paradox Driver
(*.db )};" & _
"DriverID=5 38;" & _
"Fil=Parado x 5.X;" & _
"DefaultDir =" & PathRoot & "dados\;" & _ "Dbq=" & PathRoot & "dados\;" & _
"CollatingSeque nce=ASCII"
Dim objConn As New Odbc.OdbcConnec tion(strConStri ng)
Dim objCmd As New Odbc.OdbcComman d
Dim objDr As Odbc.OdbcDataRe ader

Try
objConn.Close()
objConn.Open()
objCmd.Connecti on = objConn
'============== =============== =============== =============== ============ ' Validando Matricula e CPF
'============== =============== =============== =============== ============ objCmd.CommandT ype = CommandType.Tex t
objCmd.CommandT ext = "select
a.alu_nome,a.al u_end,a.alu_num ,a.alu_compl,a. alu_bai,a.alu_c id,a.alu_est,
a.alu_cep,d.cus _cod,d.cus_nome from ALU20052 as a, MAT20052 as c, cursos as d where c.mat_alun = '" & Trim(txtNrMatr. Text) & "' and a.alu_cpf = '" &
Trim(txtNrCPF.T ext) & "' and c.mat_alun = a.alu_matr and a.alu_cur =
d.cus_cod"
objDr = objCmd.ExecuteR eader(CommandBe havior.CloseCon nection)
If objDr.Read Then ' Matricula Válida
Session("alu_no me") = Trim(objDr("alu _nome"))
Session("mat_al un") = Trim(txtNrMatr. Text)
Session("alun_c pf") = Trim(txtNrCPF.T ext)
Session("alu_en d") =
Trim(oFafire.va lidaDRText(objD r("alu_end")) )
Session("alu_nu m") =
Trim(oFafire.va lidaDRText(objD r("alu_num")) )
Session("alu_co mpl") =
Trim(oFafire.va lidaDRText(objD r("alu_compl")) )
Session("alu_ba i") =
Trim(oFafire.va lidaDRText(objD r("alu_bai")) )
Session("alu_ci d") =
Trim(oFafire.va lidaDRText(objD r("alu_cid")) )
Session("alu_es t") =
Trim(oFafire.va lidaDRText(objD r("alu_est")) )
Session("alu_ce p") =
IIf(Trim(oFafir e.validaDRText( objDr("alu_cep" ))) = "", "50000-000",
Trim(oFafire.va lidaDRText(objD r("alu_cep")) ))
Session("cus_no me") = Trim(objDr("cus _nome"))
args.IsValid = True
Else ' Matricula Inválida
CustomValidator 1.ErrorMessage = "Matricula/CPF Incorreto"
args.IsValid = False
End If

Catch ex As System.Exceptio n
args.IsValid = False
Response.Redire ct("error.aspx? MensagemTexto=" & ex.Message.Trim & "&MensagemPagin aRetorno=mensal idade_pagamento _entrada.aspx", False)

Finally
If objConn.State = ConnectionState .Open Then objConn.Close()
objConn.Dispose ()
objCmd.Dispose( )
If Not IsNothing(objDr ) Then objDr.Close()
objDr = Nothing
End Try

End Sub

[Fabio dos Santos Fernandes]

Hi Ricardo.

I understood that the connecrion is going ok, but at some isam drivers, the
connection only occurs when the real table is accessed.

So the problem still could be connection string, if you cant make a sql
"select" on a table.

I suggest you to create a file with "udl" extension on your desktop, then
double click
on the icon to configure the connection string to the paradox folder.

Wil be shown the properties to connect via paradox to the tables.
Configure all options needed and confirm to save and close.

Edit the file with nodepad and compare the connection string with the ADO.Net
connection string. Maybe with this you can detect any problem on your
connection string.

Fabio dos Santos Fernandes
MCAD.Net
WiseNetworks tecnologia
www.wisenetworks.com.br
Cause

"Ricardo Magalhães" escreveu:

Hi,

I using this code, to connect with a paradox file with ASP.NET. The first
time its connect ok, but others times occurs the error:

"ERROR - no error information available"

I close all connection, and this error yet occurs.

Someone knows why this ?

Thanks,
Ricardo
Connection strirng content:
=============== ===

"Driver={Micros oft Paradox Driver (*.db )};DriverID=538 ;Fil=Paradox
5.X;DefaultDir= c:\inetpub\wwwr oot\fafire\web\ graduacao_pagam ento\dados\;Dbq =c:\inetpub\www root\fafire\web \graduacao_paga mento\dados\;Co llatingSequence =ASCII"

Code executed when the button is clicked
=============== =============
Private Sub CustomValidator 1_ServerValidat e(ByVal source As System.Object,
ByVal args As System.Web.UI.W ebControls.Serv erValidateEvent Args) Handles
CustomValidator 1.ServerValidat e

Dim PathAux As String = Server.MapPath( "Web.config ")
Dim PathRoot As String = PathAux.Substri ng(0,
PathAux.IndexOf ("Web.config "))
Dim PastaDados As String = "BD" & Session("ano") &
Session("semest re")

Dim strConString As String = "Driver={Micros oft Paradox Driver
(*.db )};" & _
"DriverID=5 38;" & _
"Fil=Parado x 5.X;" & _
"DefaultDir =" & PathRoot & "dados\;" & _
"Dbq=" & PathRoot & "dados\;" & _
"CollatingSeque nce=ASCII"
Dim objConn As New Odbc.OdbcConnec tion(strConStri ng)
Dim objCmd As New Odbc.OdbcComman d
Dim objDr As Odbc.OdbcDataRe ader

Try
objConn.Close()
objConn.Open()
objCmd.Connecti on = objConn
'============== =============== =============== =============== ============
' Validando Matricula e CPF
'============== =============== =============== =============== ============
objCmd.CommandT ype = CommandType.Tex t
objCmd.CommandT ext = "select
a.alu_nome,a.al u_end,a.alu_num ,a.alu_compl,a. alu_bai,a.alu_c id,a.alu_est,
a.alu_cep,d.cus _cod,d.cus_nome from ALU20052 as a, MAT20052 as c, cursos as
d where c.mat_alun = '" & Trim(txtNrMatr. Text) & "' and a.alu_cpf = '" &
Trim(txtNrCPF.T ext) & "' and c.mat_alun = a.alu_matr and a.alu_cur =
d.cus_cod"
objDr = objCmd.ExecuteR eader(CommandBe havior.CloseCon nection)
If objDr.Read Then ' Matricula Válida
Session("alu_no me") = Trim(objDr("alu _nome"))
Session("mat_al un") = Trim(txtNrMatr. Text)
Session("alun_c pf") = Trim(txtNrCPF.T ext)
Session("alu_en d") =
Trim(oFafire.va lidaDRText(objD r("alu_end")) )
Session("alu_nu m") =
Trim(oFafire.va lidaDRText(objD r("alu_num")) )
Session("alu_co mpl") =
Trim(oFafire.va lidaDRText(objD r("alu_compl")) )
Session("alu_ba i") =
Trim(oFafire.va lidaDRText(objD r("alu_bai")) )
Session("alu_ci d") =
Trim(oFafire.va lidaDRText(objD r("alu_cid")) )
Session("alu_es t") =
Trim(oFafire.va lidaDRText(objD r("alu_est")) )
Session("alu_ce p") =
IIf(Trim(oFafir e.validaDRText( objDr("alu_cep" ))) = "", "50000-000",
Trim(oFafire.va lidaDRText(objD r("alu_cep")) ))
Session("cus_no me") = Trim(objDr("cus _nome"))
args.IsValid = True
Else ' Matricula Inválida
CustomValidator 1.ErrorMessage = "Matricula/CPF Incorreto"
args.IsValid = False
End If

Catch ex As System.Exceptio n
args.IsValid = False
Response.Redire ct("error.aspx? MensagemTexto=" & ex.Message.Trim
& "&MensagemPagin aRetorno=mensal idade_pagamento _entrada.aspx", False)

Finally
If objConn.State = ConnectionState .Open Then objConn.Close()
objConn.Dispose ()
objCmd.Dispose( )
If Not IsNothing(objDr ) Then objDr.Close()
objDr = Nothing
End Try

End Sub