Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO with Win2000 and 98/ MSDASQL provider

Status
Not open for further replies.

Imshaad

Programmer
Jun 2, 2003
9
MU
Hi All,

I have a big problem right now. I have developed an apllication in Excel VBA. I have the following codes for connecting to another Excel Sheet

Set cnConn = New Connection
With cnConn
.Provider = "MSDASQL"
.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};" & _
"DBQ=" & sEmpFilePath & ";"
.CursorLocation = adUseClient
.Open
End With

This works find on my development machine which is under win 2000. When I deploy the application under win 2000 it still works fine but under win 98 I get the following error:
Error Number: 3706
Description: Provider Cannot be found. It may not be properly installed.

Any hint how to get this resolved?

thanks you all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top