当前位置:网站首页>OLEDB accessing sqlserver 2019

OLEDB accessing sqlserver 2019

2022-01-15 02:30:21 CSDN Q & A

The phenomenon and background of the problem

My previous code , It's using OLEDB Technology access Sqlserver2008 Of . No problem

however , When I go to visit Sqlserver2019 When , There are a lot of problems . I fix some mistakes that I can fix .
however :
// The second step : Create data source objects , Simultaneous acquisition IDBInitialize Interface
// Creates a with the specified class identifier Com object , Creates an uninitialized object with the specified class identifier
g_hr_return = CoCreateInstance(CLSID_SQLNCLI10, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize, (void**)&data_pIDBInitialize);
// Parameters 1:
if (FAILED(g_hr_return))
{
return -1;
}

Operation results and error reporting contents

CLSID_SQLNCLI10 I can't recognize this

My solution ideas and tried methods

I thought Every COM Components have different ID. Sqlservr 2009 and Sqlserve2019 Of COM Components ID atypism .  But reality hits the face .
I searched a lot of information , The final conclusion is  OELDB  It's too old ,  Eliminate .Sqlderver2019 No support for . tragedy

What I want to achieve

1) See if you can save , Use OLEDB visit Sql2019

perhaps

2) Access... Using other technologies sqlserver2019. It can make the write speed reach... Per second 10 Line ten thousand .( I use OLEDB write in Sqlserver2008,1 Seconds to write 10 Ten thousand line floating point number )

××
Postscript : I can provide my current code . Paid , thank you

版权声明
本文为[CSDN Q & A]所创,转载请带上原文链接,感谢
https://chowdera.com/2021/12/20211207165416966t.html

随机推荐