Create provider

Question

Create provider

Krasavita

SSC-Insane

Points: 23138
More actions
June 28, 2011 at 7:26 am

#389852

Can some one help me how to create provider.
Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

Krasavita (6/28/2011)
Can some one help me how to create provider.
Thank you

can you explain what you mean? do you mean adding ODBC providers to your SQL instance? like adding Oracle, DB2 MYSQL or some other ODBC provider?

do you mean creating a connection string or linked server featuring a provider?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Krasavita SSC-Insane Points: 23138 More actions · Answer 2

Under options:

Linked Servers, I have Providers, I would like to know how they get created, I have a lot of them and can't modify them.I need to know how Microsoft.ACE.OLEDB.12.0 got created, I get error message from my sql job for this provider.

Thank you

Lowell SSC Guru Points: 323518 More actions · Answer 3

the list is a list of all ODBC drivers installed and registered on the server .

the ace driver gets installed when you install this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

it might also be installed if you install office 2007 or above.

the error might be because your SQL isntance is 64 bit, but the Office or DLL versions installed were 32 bit. it could be the otehr way too...32 bit SQL, 64 bit drivers.

you'd have to uninstall Office/that msi and install the 64 version, for example.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!