Re: Provider=Microsoft.Jet.OLEDB.4.0
- From: Beowulf <beowulf_is_not_here@xxxxxxxxxxx>
- Date: Tue, 25 Apr 2006 11:10:14 -0400
In my experience the "extended properties" information for Jet connections has always needed to be enclosed in double-quotes of its own (both for connecting to Excel workbooks and text file databases).
For example:
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sXlPath & ";" & _
"Extended Properties=""Excel 8.0;HDR=Yes"""
So the contents of sConnString after the assignment would be (this should be all one one line):
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\BeneFeedProcessor\bin\bene1.xls;Extended Properties="Excel 8.0;HDR=Yes"
The value of the HDR property tells Jet whether the first row in a named range contains column names or data. HDR=YES tells Jet to use the values in the first row for names and HDR=NO does the opposite.
dshort1225 wrote:
I am having some issues running an asp.net app on windows 2000 with .net Framework 1.1. The win 2000 server is a test server and the app was tested successfully approx 6 months ago on this server, the part of that app that is now failing is:.
Dim oleConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\Inetpub\wwwroot\BeneFeedProcessor\bin\bene1.xls;" & "Extended Properties=Excel 8.0;"
'*************************************************
' Create the connection object
Dim oleConn As New OleDbConnection(oleConnString)
' Open connection with the database.
oleConn.Open()
It fails on the open statement, the system is setup to auto install patches, could there be a patch that may be causing this issue?
Thanks,
- Prev by Date: IRowsetFastLoad and nvarchar (1) fields
- Next by Date: Re: IRowsetFastLoad and nvarchar (1) fields
- Previous by thread: IRowsetFastLoad and nvarchar (1) fields
- Next by thread: vfpoledb and ICommandPersist
- Index(es):
Relevant Pages
|
|
