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={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox
5.X;DefaultDir=c:\inetpub\wwwroot\fafire\web\graduacao_pagamento\dados\;Dbq=c:\inetpub\wwwroot\fafire\web\graduacao_pagamento\dados\;CollatingSequence=ASCII"

Code executed when the button is clicked
============================
Private Sub CustomValidator1_ServerValidate(ByVal source As System.Object,
ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles
CustomValidator1.ServerValidate

Dim PathAux As String = Server.MapPath("Web.config")
Dim PathRoot As String = PathAux.Substring(0,
PathAux.IndexOf("Web.config"))
Dim PastaDados As String = "BD" & Session("ano") &
Session("semestre")

Dim strConString As String = "Driver={Microsoft Paradox Driver
(*.db )};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=" & PathRoot & "dados\;" & _
"Dbq=" & PathRoot & "dados\;" & _
"CollatingSequence=ASCII"
Dim objConn As New Odbc.OdbcConnection(strConString)
Dim objCmd As New Odbc.OdbcCommand
Dim objDr As Odbc.OdbcDataReader

Try
objConn.Close()
objConn.Open()
objCmd.Connection = objConn
'=======================================================================
' Validando Matricula e CPF
'=======================================================================
objCmd.CommandType = CommandType.Text
objCmd.CommandText = "select
a.alu_nome,a.alu_end,a.alu_num,a.alu_compl,a.alu_bai,a.alu_cid,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.Text) & "' and c.mat_alun = a.alu_matr and a.alu_cur =
d.cus_cod"
objDr = objCmd.ExecuteReader(CommandBehavior.CloseConnection)
If objDr.Read Then ' Matricula Válida
Session("alu_nome") = Trim(objDr("alu_nome"))
Session("mat_alun") = Trim(txtNrMatr.Text)
Session("alun_cpf") = Trim(txtNrCPF.Text)
Session("alu_end") =
Trim(oFafire.validaDRText(objDr("alu_end")))
Session("alu_num") =
Trim(oFafire.validaDRText(objDr("alu_num")))
Session("alu_compl") =
Trim(oFafire.validaDRText(objDr("alu_compl")))
Session("alu_bai") =
Trim(oFafire.validaDRText(objDr("alu_bai")))
Session("alu_cid") =
Trim(oFafire.validaDRText(objDr("alu_cid")))
Session("alu_est") =
Trim(oFafire.validaDRText(objDr("alu_est")))
Session("alu_cep") =
IIf(Trim(oFafire.validaDRText(objDr("alu_cep"))) = "", "50000-000",
Trim(oFafire.validaDRText(objDr("alu_cep"))))
Session("cus_nome") = Trim(objDr("cus_nome"))
args.IsValid = True
Else ' Matricula Inválida
CustomValidator1.ErrorMessage = "Matricula/CPF Incorreto"
args.IsValid = False
End If

Catch ex As System.Exception
args.IsValid = False
Response.Redirect("error.aspx?MensagemTexto=" & ex.Message.Trim
& "&MensagemPaginaRetorno=mensalidade_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.malik/archive/2005/05/13/63199.aspx

 

[Guest]

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:

 

[taco24]

I had the same error message, which doesn't tell you anything about the problem

In my case the table contained a field of type "CLOB" which couldn't be handled by the odbc driver.

After searching for hours I tried a simpler example and it worked.

Maybe in your case it has also to do with incompatible types or inconsistent data. But maybe it's also something completely different. As I said, the error message is completely useless.