S
S
Stanisav2014-09-04 10:43:53
Microsoft
Stanisav, 2014-09-04 10:43:53

How to set default msdasql provider?

At work in a third-party program, the source of which I do not have access to, the size of the database grew from sql express 2005, so I had to install sql express 2008, Win 7 x64 OS, the program imports large directories using openrowset. I found how scripts turn it on on the server, turned it on, but now another error has come up - when importing, it crashes with an error

Поставщик OLE DB "MSDASQL" для связанного сервера "(null)" вернул сообщение "[Microsoft][Диспетчер драйверов ODBC] Источник данных не найден и не указан драйвер, используемый по умолчанию".

DLL msdasql.dll is in C:\Program Files\Common Files\System\Ole DB and in C:\Program Files(x86)\Common Files\System\Ole DB

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question