Hello, I am reading an excel file from a VB6 app on Windows 98. Here is my
code:
Dim oConn As ADODB.Connection
Dim oRs As ADODB.Recordset
Create and open a new ADO Connection using ODBC.
Set oConn = New ADODB.Connection
oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"FIL=excel 8.0;" & _
"DefaultDir=" & App.path & _
"MaxBufferSize=2048;" & _
"PageTimeout=5;" & _
"DBQ=" & sFilename & ";"
As soon as I try to open the connection, I get a "Provider cannot be found.
May not be properly installed" error. I have the latest MDAC applied, but
this did not fix the issue. What DID fix the problem is I applied the latest
Jet 4.0 service pack for Windows 98. My question is this:
I want users to install my app and NOT have to then go to the MS website to
download the Jet 4.0 service pack. What would be your recommendation?
Should I:
(1) Distribute and execute the service pack during the program install
(provided this does not violate any license from microsoft).
(2) Use a different connection string that does not require the latest Jet
4.0 service pack? If so, what changes would I make to the connection string?
I found google evidence for "fil=excel 6.0", "8.0", and "9.0". So perhaps
using "6.0" on an (older?) Windows 98 computer (with Excel installed) could
be easier.
(3) Any other idea you have I have not thought of?
Microsoft XP service pack 2 - Internet problem ... I have recently re-installed windows on my laptop. ... I then updated to service pack 2. ... I had to install it in safe mode, as the exe file wouldn't launch ... indicating the status of my connection (bottom right on the desktop ... (microsoft.public.windowsxp.general)
Re: Service packs ... Probably install the OS service pack (assumes you have the complete SP ~135 ... | whether I need to set up internet connections before the ... | connection is not up and running. ... (microsoft.public.win2000.setup)
Re: failuer to download Win XP Sp3 (KB936929) ...Windows XP Service Pack 3 - ISO-9660 CD Image File: ... Some third-party programs may experience a change in functionality after you install... | Running on a dial-up connection system info. Win XP Pro. ... (microsoft.public.windowsupdate)
Re: install sp1 from cd? ... It says I need an internet... >connection to finish the install,... The full service pack is available here, ...high-speed Internet connection.... (microsoft.public.windowsxp.network_web)
Re: Win32.Blaster.worm -- Problem ... I dont have the service pack 2 installed. ... I've dl'd KB823980 patch but when I try to install the ... >> to restart, you have slow net connection, and while ... (microsoft.public.win2000.security)
