Asp Forum - OdbcConnection issues??? - microsoft.public.dotnet.framework.odbcnet

Sean

3/4/2005 5:58:00 PM

Hello all, I am messing around with my first attempt at opening an ODBC
connection via .NET. I have been attempting to open a single dBase IV
database file that is output from Paradox 9. I have been playing with the
following code snippet to open the database but all I can seem to get is an
error message. Can someone point me to a couple of good examples?

Sean

<error>
ERROR [HY024] [Microsoft][ODBC dBase Driver] '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly and that you are
connected to the server on which the file resides. ERROR [IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
[HY024] [Microsoft][ODBC dBase Driver] '(unknown)' is not a valid path. Make
sure that the path name is spelled correctly and that you are connected to
the server on which the file resides.
</error>

<code>
Partial Class Default_aspx

Sub Button1_ServerClick(ByVal sender As Object, ByVal e As System.EventArgs)

' If the connection string is null, use a default.

Dim I As Integer

Dim myConn As New Data.Odbc.OdbcConnection("DRIVER={Microsoft dBase Driver
(*.dbf)};DBQ=c:\website\test.dbf;")

Dim TableOutput As New Data.Odbc.OdbcCommand("SELECT `test$`.ORDER_NUMB FROM
`c:\website\test`.`test$` `test$`", myConn)

myConn.Open()

Dim Readme As Data.Odbc.OdbcDataReader = TableOutput.ExecuteReader()

Try

While Readme.Read()

junk.Text = Readme.GetString(i)

End While

Finally

Readme.Close()

myConn.Close()

End Try

End Sub

Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles
Me.Load

End Sub

End Class

</code>

14 Answers

Paul Clement

3/7/2005 4:48:00 PM

On Fri, 4 Mar 2005 09:57:46 -0800, "Sean" <spam_I_hate@whenu.com> wrote:

¤ Hello all, I am messing around with my first attempt at opening an ODBC
¤ connection via .NET. I have been attempting to open a single dBase IV
¤ database file that is output from Paradox 9. I have been playing with the
¤ following code snippet to open the database but all I can seem to get is an
¤ error message. Can someone point me to a couple of good examples?
¤
¤ Sean
¤
¤ <error>
¤ ERROR [HY024] [Microsoft][ODBC dBase Driver] ''(unknown)'' is not a valid
¤ path. Make sure that the path name is spelled correctly and that you are
¤ connected to the server on which the file resides. ERROR [IM006]
¤ [Microsoft][ODBC Driver Manager] Driver''s SQLSetConnectAttr failed ERROR
¤ [HY024] [Microsoft][ODBC dBase Driver] ''(unknown)'' is not a valid path. Make
¤ sure that the path name is spelled correctly and that you are connected to
¤ the server on which the file resides.
¤ </error>
¤
¤
¤ <code>
¤ Partial Class Default_aspx
¤
¤ Sub Button1_ServerClick(ByVal sender As Object, ByVal e As System.EventArgs)
¤
¤ '' If the connection string is null, use a default.
¤
¤ Dim I As Integer
¤
¤ Dim myConn As New Data.Odbc.OdbcConnection("DRIVER={Microsoft dBase Driver
¤ (*.dbf)};DBQ=c:\website\test.dbf;")
¤
¤ Dim TableOutput As New Data.Odbc.OdbcCommand("SELECT `test$`.ORDER_NUMB FROM
¤ `c:\website\test`.`test$` `test$`", myConn)
¤
¤ myConn.Open()
¤
¤ Dim Readme As Data.Odbc.OdbcDataReader = TableOutput.ExecuteReader()
¤
¤ Try
¤
¤ While Readme.Read()
¤
¤ junk.Text = Readme.GetString(i)
¤
¤ End While
¤
¤ Finally
¤
¤ Readme.Close()
¤
¤ myConn.Close()
¤
¤ End Try
¤
¤
¤
¤ End Sub
¤

Have you tried Jet OLEDB with the dBase ISAM instead:

Dim ConnectionString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\dBase;Extended Properties=dBase IV"
Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(ConnectionString)
dBaseConnection.Open()

Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT * FROM MyDBase",
dBaseConnection)
Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader =
dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)

While dBaseDataReader.Read
Console.WriteLine(dBaseDataReader("Column1").ToString)
Console.WriteLine(dBaseDataReader("Column2").ToString)
Console.WriteLine(dBaseDataReader("Column3").ToString)
End While

dBaseConnection.Close()

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Sean

3/9/2005 8:01:00 PM

Paul,

I will go ahead and give this a try to see how it works. I''ll keep the
list posted.

Sean
_swarnock_ at _warnocksolutions_ dot _com_

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:5a1p215ufar3mbdgtv2qshr7ngonjlddoc@4ax.com...
> On Fri, 4 Mar 2005 09:57:46 -0800, "Sean" <spam_I_hate@whenu.com> wrote:
>
> ¤ Hello all, I am messing around with my first attempt at opening an ODBC
> ¤ connection via .NET. I have been attempting to open a single dBase IV
> ¤ database file that is output from Paradox 9. I have been playing with
> the
> ¤ following code snippet to open the database but all I can seem to get is
> an
> ¤ error message. Can someone point me to a couple of good examples?
> ¤
> ¤ Sean
> ¤
> ¤ <error>
> ¤ ERROR [HY024] [Microsoft][ODBC dBase Driver] ''(unknown)'' is not a valid
> ¤ path. Make sure that the path name is spelled correctly and that you are
> ¤ connected to the server on which the file resides. ERROR [IM006]
> ¤ [Microsoft][ODBC Driver Manager] Driver''s SQLSetConnectAttr failed ERROR
> ¤ [HY024] [Microsoft][ODBC dBase Driver] ''(unknown)'' is not a valid path.
> Make
> ¤ sure that the path name is spelled correctly and that you are connected
> to
> ¤ the server on which the file resides.
> ¤ </error>
> ¤
> ¤
> ¤ <code>
> ¤ Partial Class Default_aspx
> ¤
> ¤ Sub Button1_ServerClick(ByVal sender As Object, ByVal e As
> System.EventArgs)
> ¤
> ¤ '' If the connection string is null, use a default.
> ¤
> ¤ Dim I As Integer
> ¤
> ¤ Dim myConn As New Data.Odbc.OdbcConnection("DRIVER={Microsoft dBase
> Driver
> ¤ (*.dbf)};DBQ=c:\website\test.dbf;")
> ¤
> ¤ Dim TableOutput As New Data.Odbc.OdbcCommand("SELECT `test$`.ORDER_NUMB
> FROM
> ¤ `c:\website\test`.`test$` `test$`", myConn)
> ¤
> ¤ myConn.Open()
> ¤
> ¤ Dim Readme As Data.Odbc.OdbcDataReader = TableOutput.ExecuteReader()
> ¤
> ¤ Try
> ¤
> ¤ While Readme.Read()
> ¤
> ¤ junk.Text = Readme.GetString(i)
> ¤
> ¤ End While
> ¤
> ¤ Finally
> ¤
> ¤ Readme.Close()
> ¤
> ¤ myConn.Close()
> ¤
> ¤ End Try
> ¤
> ¤
> ¤
> ¤ End Sub
> ¤
>
> Have you tried Jet OLEDB with the dBase ISAM instead:
>
> Dim ConnectionString As String
>
> ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=e:\My Documents\dBase;Extended Properties=dBase
> IV"
> Dim dBaseConnection As New
> System.Data.OleDb.OleDbConnection(ConnectionString)
> dBaseConnection.Open()
>
> Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT *
> FROM MyDBase",
> dBaseConnection)
> Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader =
> dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)
>
> While dBaseDataReader.Read
> Console.WriteLine(dBaseDataReader("Column1").ToString)
> Console.WriteLine(dBaseDataReader("Column2").ToString)
> Console.WriteLine(dBaseDataReader("Column3").ToString)
> End While
>
> dBaseConnection.Close()
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Sean

3/16/2005 12:32:00 AM

OK, at this point I can definatly say that I do not get something about
the connection string. I continue to get the error message stating that I
am using an invalid path. The code snippet that I fired off is currently in
a code behind aspx page. Do I need to assume that my path should be in
relation to the web server''s virtual directory. I.E.
c:\inetpub\wwwroot\data\test.dbf this my connection string should be to the
relative path of ./data/test.dbf or should I be connecting to the actual
location (I.E. c:\inetpub\wwwroot\data\test.dbf)? As you can see this is
more of a learning experiment but I really could use a little more
background reading on the subject. Any suggestions are welcome.

Sean

"Sean" <spam_I_hate@whenu.com> wrote in message
news:O1ezuKOJFHA.2560@TK2MSFTNGP09.phx.gbl...
> Paul,
>
> I will go ahead and give this a try to see how it works. I''ll keep
the
> list posted.
>
> Sean
> _swarnock_ at _warnocksolutions_ dot _com_
>
> "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
> news:5a1p215ufar3mbdgtv2qshr7ngonjlddoc@4ax.com...
> > On Fri, 4 Mar 2005 09:57:46 -0800, "Sean" <spam_I_hate@whenu.com> wrote:
> >
> > ¤ Hello all, I am messing around with my first attempt at opening an
ODBC
> > ¤ connection via .NET. I have been attempting to open a single dBase IV
> > ¤ database file that is output from Paradox 9. I have been playing with
> > the
> > ¤ following code snippet to open the database but all I can seem to get
is
> > an
> > ¤ error message. Can someone point me to a couple of good examples?
> > ¤
> > ¤ Sean
> > ¤
> > ¤ <error>
> > ¤ ERROR [HY024] [Microsoft][ODBC dBase Driver] ''(unknown)'' is not a
valid
> > ¤ path. Make sure that the path name is spelled correctly and that you
are
> > ¤ connected to the server on which the file resides. ERROR [IM006]
> > ¤ [Microsoft][ODBC Driver Manager] Driver''s SQLSetConnectAttr failed
ERROR
> > ¤ [HY024] [Microsoft][ODBC dBase Driver] ''(unknown)'' is not a valid
path.
> > Make
> > ¤ sure that the path name is spelled correctly and that you are
connected
> > to
> > ¤ the server on which the file resides.
> > ¤ </error>
> > ¤
> > ¤
> > ¤ <code>
> > ¤ Partial Class Default_aspx
> > ¤
> > ¤ Sub Button1_ServerClick(ByVal sender As Object, ByVal e As
> > System.EventArgs)
> > ¤
> > ¤ '' If the connection string is null, use a default.
> > ¤
> > ¤ Dim I As Integer
> > ¤
> > ¤ Dim myConn As New Data.Odbc.OdbcConnection("DRIVER={Microsoft dBase
> > Driver
> > ¤ (*.dbf)};DBQ=c:\website\test.dbf;")
> > ¤
> > ¤ Dim TableOutput As New Data.Odbc.OdbcCommand("SELECT
`test$`.ORDER_NUMB
> > FROM
> > ¤ `c:\website\test`.`test$` `test$`", myConn)
> > ¤
> > ¤ myConn.Open()
> > ¤
> > ¤ Dim Readme As Data.Odbc.OdbcDataReader = TableOutput.ExecuteReader()
> > ¤
> > ¤ Try
> > ¤
> > ¤ While Readme.Read()
> > ¤
> > ¤ junk.Text = Readme.GetString(i)
> > ¤
> > ¤ End While
> > ¤
> > ¤ Finally
> > ¤
> > ¤ Readme.Close()
> > ¤
> > ¤ myConn.Close()
> > ¤
> > ¤ End Try
> > ¤
> > ¤
> > ¤
> > ¤ End Sub
> > ¤
> >
> > Have you tried Jet OLEDB with the dBase ISAM instead:
> >
> > Dim ConnectionString As String
> >
> > ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> > "Data Source=e:\My Documents\dBase;Extended Properties=dBase
> > IV"
> > Dim dBaseConnection As New
> > System.Data.OleDb.OleDbConnection(ConnectionString)
> > dBaseConnection.Open()
> >
> > Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT *
> > FROM MyDBase",
> > dBaseConnection)
> > Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader =
> > dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)
> >
> > While dBaseDataReader.Read
> > Console.WriteLine(dBaseDataReader("Column1").ToString)
> > Console.WriteLine(dBaseDataReader("Column2").ToString)
> > Console.WriteLine(dBaseDataReader("Column3").ToString)
> > End While
> >
> > dBaseConnection.Close()
> >
> >
> > Paul ~~~ pclement@ameritech.net
> > Microsoft MVP (Visual Basic)
>
>

Paul Clement

3/16/2005 3:28:00 PM

On Tue, 15 Mar 2005 16:31:50 -0800, "Sean" <no_spam_administrator.visionairelighting.com> wrote:

¤ OK, at this point I can definatly say that I do not get something about
¤ the connection string. I continue to get the error message stating that I
¤ am using an invalid path. The code snippet that I fired off is currently in
¤ a code behind aspx page. Do I need to assume that my path should be in
¤ relation to the web server''s virtual directory. I.E.
¤ c:\inetpub\wwwroot\data\test.dbf this my connection string should be to the
¤ relative path of ./data/test.dbf or should I be connecting to the actual
¤ location (I.E. c:\inetpub\wwwroot\data\test.dbf)? As you can see this is
¤ more of a learning experiment but I really could use a little more
¤ background reading on the subject. Any suggestions are welcome.
¤
¤ Sean

What does your connection code look like?

You might want to use MapPath in order to specify the path to the database:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/html/270433db-6a1a-42b1-86fa-9c4ca0...

Paul
~~~~
Microsoft MVP (Visual Basic)

Sean

3/23/2005 6:15:00 PM

Paul,

Is there a chance you can point me to a fully working database
connection that also makes a few reads from the ODBC database? I think I
might just need a good example to spark that Aha moment.

Sean

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:3njg31131vtifv6toc9aeloantd67u0gom@4ax.com...
> On Tue, 15 Mar 2005 16:31:50 -0800, "Sean"
> <no_spam_administrator.visionairelighting.com> wrote:
>
> ¤ OK, at this point I can definatly say that I do not get something
> about
> ¤ the connection string. I continue to get the error message stating that
> I
> ¤ am using an invalid path. The code snippet that I fired off is
> currently in
> ¤ a code behind aspx page. Do I need to assume that my path should be in
> ¤ relation to the web server''s virtual directory. I.E.
> ¤ c:\inetpub\wwwroot\data\test.dbf this my connection string should be to
> the
> ¤ relative path of ./data/test.dbf or should I be connecting to the actual
> ¤ location (I.E. c:\inetpub\wwwroot\data\test.dbf)? As you can see this
> is
> ¤ more of a learning experiment but I really could use a little more
> ¤ background reading on the subject. Any suggestions are welcome.
> ¤
> ¤ Sean
>
> What does your connection code look like?
>
> You might want to use MapPath in order to specify the path to the
> database:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/html/270433db-6a1a-42b1-86fa-9c4ca0...
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

Paul Clement

3/23/2005 7:32:00 PM

On Wed, 23 Mar 2005 10:14:31 -0800, "Sean" <spam_I_hate@whenu.com> wrote:

¤ Paul,
¤
¤ Is there a chance you can point me to a fully working database
¤ connection that also makes a few reads from the ODBC database? I think I
¤ might just need a good example to spark that Aha moment.
¤
¤ Sean

There is an example in one of my previous replies. Didn''t it work for you?

Paul
~~~~
Microsoft MVP (Visual Basic)

Sean

3/23/2005 9:09:00 PM

Unfortunatly no that did not work. I recieved the same error message
when I tried to connect. I seem to be able to open an excel file but every
time I try and open a DBASE IV file it blows up on me. I have been using a
DBASE IV database file created with Excel 2003 for testing.

Sean

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:ivg341hk3uuhe0rqursp8kg7le2q2ftqkm@4ax.com...
> On Wed, 23 Mar 2005 10:14:31 -0800, "Sean" <spam_I_hate@whenu.com> wrote:
>
> ¤ Paul,
> ¤
> ¤ Is there a chance you can point me to a fully working database
> ¤ connection that also makes a few reads from the ODBC database? I think
> I
> ¤ might just need a good example to spark that Aha moment.
> ¤
> ¤ Sean
>
> There is an example in one of my previous replies. Didn''t it work for you?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

Paul Clement

3/24/2005 1:32:00 PM

On Wed, 23 Mar 2005 13:08:47 -0800, "Sean" <spam_I_hate@whenu.com> wrote:

¤ Unfortunatly no that did not work. I recieved the same error message
¤ when I tried to connect. I seem to be able to open an excel file but every
¤ time I try and open a DBASE IV file it blows up on me. I have been using a
¤ DBASE IV database file created with Excel 2003 for testing.
¤

Can you could post your code and identify the error and where is occurring?

Paul
~~~~
Microsoft MVP (Visual Basic)

Sean

3/24/2005 7:17:00 PM

OK here we go. This is the entire code block from start to finish.

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd...

<html xmlns="http://www.w3.org/1999/x... >

<head runat="server">

<title>Visionaire Lighting, LLC</title>

<link href="./styles/visionaire.css" rel="stylesheet" type="text/css" />



<script language="vb" runat="server">

Public Sub DataSpew(ByVal myConnection As String)

End Sub

Protected Sub Button1_ServerClick(ByVal sender As Object, ByVal e As
System.EventArgs)

End Sub

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As
System.EventArgs)

'' If the connection string is null, use a default.

''<test code>

Dim ConnectionString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=test.dbf;Extended Properties=dBase IV"

Dim dBaseConnection As New Data.OleDb.OleDbConnection(ConnectionString)

Dim dBaseCommand As New Data.OleDb.OleDbCommand("SELECT * FROM test",
dBaseConnection)

dBaseConnection.Open()

Dim dBaseDataReader As Data.OleDb.OleDbDataReader

dBaseDataReader = dBaseCommand.ExecuteReader()

While dBaseDataReader.Read()

Console.WriteLine(dBaseDataReader("Column1").ToString)

End While

dBaseConnection.Close()

''</test code>

''<exiting code>

'' Dim I As Integer

'' Dim myConn As New Data.Odbc.OdbcConnection("DRIVER={Microsoft Excel Driver
(*.xls)};DBQ=c:\WebSites\WebSite3\test.xls;")

'' Dim TableOutput As New Data.Odbc.OdbcCommand("SELECT `test$`.ORDER_NUMB
FROM `C:\WebSites\WebSite3\Data\test`.`test$` `test$`", myConn)

'' myConn.Open()

'' Dim Readme As Data.Odbc.OdbcDataReader = TableOutput.ExecuteReader()

'' Try

''While Readme.Read()

'' junk.Text = Readme.GetString(i)

'' End While

'' Finally

''Readme.Close()

''myConn.Close()

''End Try

''</existing code>

End Sub

</script>

</head>

<body>

<form id="form1" runat="server">

<div>

<h1>Visioniare Lighting Rep Utilities</h1>

<p>

<asp:Button ID="Button2" runat="server" Text="Test Reader"
OnClick="Button2_Click" />

 </p>

<asp:Label ID="junk" Runat=Server></asp:Label>

</div>

</form>

</body>

</html>

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:f3g541d3vuffm1q32n684jdbt9bnrqg7to@4ax.com...
> On Wed, 23 Mar 2005 13:08:47 -0800, "Sean" <spam_I_hate@whenu.com> wrote:
>
> ¤ Unfortunatly no that did not work. I recieved the same error
> message
> ¤ when I tried to connect. I seem to be able to open an excel file but
> every
> ¤ time I try and open a DBASE IV file it blows up on me. I have been
> using a
> ¤ DBASE IV database file created with Excel 2003 for testing.
> ¤
>
> Can you could post your code and identify the error and where is
> occurring?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

Sean

3/24/2005 7:18:00 PM

And the exact error message is...

Server Error in ''/Test'' Application.
--------------------------------------------------------------------------------

''test.dbf'' is not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on which the file
resides.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: ''test.dbf'' is not a
valid path. Make sure that the path name is spelled correctly and that you
are connected to the server on which the file resides.

Source Error:

Line 27:
Line 28: Dim dBaseCommand As New Data.OleDb.OleDbCommand("SELECT *
FROM test", dBaseConnection)
Line 29: dBaseConnection.Open()
Line 30: Dim dBaseDataReader As Data.OleDb.OleDbDataReader
Line 31:

Source File: D:\Test\Default.aspx Line: 29

Stack Trace:

[OleDbException (0x80004005): ''test.dbf'' is not a valid path. Make sure
that the path name is spelled correctly and that you are connected to the
server on which the file resides.]
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString
constr, OleDbConnection connection) +933090
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions
options, Object providerInfo, DbConnection owningObject) +54
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup) +25
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) +49
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +106
System.Data.OleDb.OleDbConnection.Open() +37
ASP.Default_aspx.Button2_Click(Object sender, EventArgs e) in
D:\Test\Default.aspx:29
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +72
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
+78
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4207

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.50110.28; ASP.NET
Version:2.0.50110.28

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:f3g541d3vuffm1q32n684jdbt9bnrqg7to@4ax.com...
> On Wed, 23 Mar 2005 13:08:47 -0800, "Sean" <spam_I_hate@whenu.com> wrote:
>
> ¤ Unfortunatly no that did not work. I recieved the same error
> message
> ¤ when I tried to connect. I seem to be able to open an excel file but
> every
> ¤ time I try and open a DBASE IV file it blows up on me. I have been
> using a
> ¤ DBASE IV database file created with Excel 2003 for testing.
> ¤
>
> Can you could post your code and identify the error and where is
> occurring?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

microsoft.public.dotnet.framework.odbcnet

OdbcConnection issues???

Sean

Paul Clement

Sean

Sean

Paul Clement

Sean

Paul Clement

Sean

Paul Clement

Sean

Sean

x Login to ForumsZone