471,357 Members | 1,090 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Connection With Paradox Database

Hi,

I´m trying to connect with a paradox database from my windows dot net
application(vb.net) and web application(asp.net) using odbc driver. vb.net
project works fine, but the asp.net it doesn´t. The following code is the
same from both, except the way to display the error messenger..

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

Dim objConn As Odbc.OdbcConnection
Dim objcmd As New Odbc.OdbcCommand
Dim objDr As Odbc.OdbcDataReader
Dim sConnString As String = "Driver={Microsoft Paradox Driver (*.db
)};DriverID=538;Fil=Paradox
5.X;DefaultDir=D:\TEMP;Dbq=D:\TEMP;CollatingSequen ce=ASCII"

objConn = New Odbc.OdbcConnection(sConnString)
Try
objConn.Open()
objcmd.Connection = objConn
objcmd.CommandType = CommandType.Text
objcmd.CommandText = "select ALU_NOME from ALU20051"
objDr = objcmd.ExecuteReader()
If objDr.Read Then ' Matricula Válida
MsgBox(objDr("ALU_NOME"))
Else ' Matricula Inválida
MsgBox("nao encontrado")
End If

Catch ex As Exception
MsgBox(ex.Message)

Finally
objConn.Close()
objConn = Nothing

objDr.Close()
objDr = Nothing
End Try

End Sub

The error messeger was

Exception Details: System.Data.Odbc.OdbcException: ERROR - no error
information available
Source Error:
Line 38:
Line 39: 'Try
Line 40: objConn.Open()
Line 41: objcmd.Connection = objConn

I try with odbc dot net driver (microsoft.data.odbc.dll) but it doesn´t work
too.

Help me. I'm quit get desperate..

Thanks a lot..
Jul 21 '05 #1
0 3416

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by TonyMontana | last post: by
2 posts views Thread by Michael Gerbasio | last post: by
reply views Thread by Ricardo | last post: by
2 posts views Thread by pamelafluente | last post: by
reply views Thread by =?Utf-8?B?dmlzaHJ1dGg=?= | last post: by
reply views Thread by XIAOLAOHU | last post: by

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.