This is a migrated thread and some comments may be shown as answers.

Some of the OLE DB drivers are not listed in OLE DB providers list

3 Answers 599 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Ali
Top achievements
Rank 1
Ali asked on 15 Jan 2014, 09:49 PM
When adding a Ole Db Data source from Telerik Reporting, 8 OLE DB providers are listed. But there 13 OLE DB providers in visual studio's server explorer. I need to use the Microsoft OLE DB Provider for Visual Studio. I can use this provider from my .NET web applications. Isn't it possible to use it from Telerik Reporting?

3 Answers, 1 is accepted

Sort by
0
Ali
Top achievements
Rank 1
answered on 16 Jan 2014, 02:32 PM
Sorry, I wrote the provider wrong.

I need to use the Microsoft OLE DB Provider for Visual FoxPro. This provider is installed on my computer. I can use this client and use OleDbConnection, OlDbCommand, etc... classes to connect to FoxPro databases from .NET applications (desktop and web). But this Ole Db provider is not listed in the Ole Db providers list of data connection wizard in Telerik report designer.

Selecting a generic Ole Db provider an providing the following connection string displays the error:

"The 'VFPOLEDB.1' provider is not registered on the local machine".

Connection string:
Provider=vfpoledb.1;Collating Sequence=TURKISH;DATE=BRITISH;connection Timeout=1200;Data Source=C:\AAW\evrim\ADADATA.DBC

This connection string works for .net applications and use the vfpoledb.1 provider, which is installed on my computer

0
Stef
Telerik team
answered on 16 Jan 2014, 06:53 PM
Hello Ali,

Please take a look at the following KB article: Data provider is missing in the SqlDataSource wizard.
Verify the provider is installed and regitered correctly and covers the listed requirements.

I hope this information helps you.

Regards,
Stef
Telerik

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Ali
Top achievements
Rank 1
answered on 16 Jan 2014, 09:51 PM
Okey, issue is resolved.

Telerik report designer has two executables, Telerik.ReportDesigner.exe and Telerik.ReportDesigner.x86.exe

Since the OLE DB data provider that I wanted to use is only registered as 32-bit, it only appears in the OLE DB providers list of the 32 bit version of report designer.
Tags
General Discussions
Asked by
Ali
Top achievements
Rank 1
Answers by
Ali
Top achievements
Rank 1
Stef
Telerik team
Share this question
or