2 * Copyright (C) 2012 Alistair Leslie-Hughes
4 * This library is free software; you can redistribute it and/or
5 * modify it under the terms of the GNU Lesser General Public
6 * License as published by the Free Software Foundation; either
7 * version 2.1 of the License, or (at your option) any later version.
9 * This library is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
12 * Lesser General Public License for more details.
14 * You should have received a copy of the GNU Lesser General Public
15 * License along with this library; if not, write to the Free Software
16 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
21 #define NONAMELESSUNION
22 #define NONAMELESSSTRUCT
31 #include "oledb_private.h"
33 #include "wine/debug.h"
34 #include "wine/unicode.h"
36 WINE_DEFAULT_DEBUG_CHANNEL(oledb);
38 DEFINE_GUID(DBPROPSET_DBINIT, 0xc8b522bc, 0x5cf3, 0x11ce, 0xad, 0xe5, 0x00, 0xaa, 0x00, 0x44, 0x77, 0x3d);
40 typedef struct datainit
42 IDataInitialize IDataInitialize_iface;
47 static inline datainit *impl_from_IDataInitialize(IDataInitialize *iface)
49 return CONTAINING_RECORD(iface, datainit, IDataInitialize_iface);
54 IDBInitialize IDBInitialize_iface;
55 IDBProperties IDBProperties_iface;
60 static inline dbinit *impl_from_IDBInitialize(IDBInitialize *iface)
62 return CONTAINING_RECORD(iface, dbinit, IDBInitialize_iface);
65 static inline dbinit *impl_from_IDBProperties(IDBProperties *iface)
67 return CONTAINING_RECORD(iface, dbinit, IDBProperties_iface);
70 static HRESULT WINAPI dbprops_QueryInterface(IDBProperties *iface, REFIID riid, void **ppvObject)
72 dbinit *This = impl_from_IDBProperties(iface);
74 return IDBInitialize_QueryInterface(&This->IDBInitialize_iface, riid, ppvObject);
77 static ULONG WINAPI dbprops_AddRef(IDBProperties *iface)
79 dbinit *This = impl_from_IDBProperties(iface);
81 return IDBInitialize_AddRef(&This->IDBInitialize_iface);
84 static ULONG WINAPI dbprops_Release(IDBProperties *iface)
86 dbinit *This = impl_from_IDBProperties(iface);
88 return IDBInitialize_Release(&This->IDBInitialize_iface);
91 static HRESULT WINAPI dbprops_GetProperties(IDBProperties *iface, ULONG cPropertyIDSets,
92 const DBPROPIDSET rgPropertyIDSets[], ULONG *pcPropertySets, DBPROPSET **prgPropertySets)
94 dbinit *This = impl_from_IDBProperties(iface);
96 FIXME("(%p)->(%d %p %p %p)\n", This, cPropertyIDSets, rgPropertyIDSets, pcPropertySets, prgPropertySets);
101 static HRESULT WINAPI dbprops_GetPropertyInfo(IDBProperties *iface, ULONG cPropertyIDSets,
102 const DBPROPIDSET rgPropertyIDSets[], ULONG *pcPropertyInfoSets,
103 DBPROPINFOSET **prgPropertyInfoSets, OLECHAR **ppDescBuffer)
105 dbinit *This = impl_from_IDBProperties(iface);
107 FIXME("(%p)->(%d %p %p %p %p)\n", This, cPropertyIDSets, rgPropertyIDSets, pcPropertyInfoSets,
108 prgPropertyInfoSets, ppDescBuffer);
113 static HRESULT WINAPI dbprops_SetProperties(IDBProperties *iface, ULONG cPropertySets,
114 DBPROPSET rgPropertySets[])
116 dbinit *This = impl_from_IDBProperties(iface);
118 FIXME("(%p)->(%d %p)\n", This, cPropertySets, rgPropertySets);
123 static const struct IDBPropertiesVtbl dbprops_vtbl =
125 dbprops_QueryInterface,
128 dbprops_GetProperties,
129 dbprops_GetPropertyInfo,
130 dbprops_SetProperties
133 static HRESULT WINAPI dbinit_QueryInterface(IDBInitialize *iface, REFIID riid, void **obj)
135 dbinit *This = impl_from_IDBInitialize(iface);
136 TRACE("(%p)->(%s, %p)\n", This, debugstr_guid(riid), obj);
140 if(IsEqualIID(riid, &IID_IUnknown) ||
141 IsEqualIID(riid, &IID_IDBInitialize))
145 else if(IsEqualIID(riid, &IID_IDBProperties))
147 *obj = &This->IDBProperties_iface;
151 FIXME("interface %s not implemented\n", debugstr_guid(riid));
152 return E_NOINTERFACE;
155 IDBInitialize_AddRef(iface);
159 static ULONG WINAPI dbinit_AddRef(IDBInitialize *iface)
161 dbinit *This = impl_from_IDBInitialize(iface);
162 TRACE("(%p)\n", This);
164 return InterlockedIncrement(&This->ref);
167 static ULONG WINAPI dbinit_Release(IDBInitialize *iface)
169 dbinit *This = impl_from_IDBInitialize(iface);
172 TRACE("(%p)\n", This);
174 ref = InterlockedDecrement(&This->ref);
177 HeapFree(GetProcessHeap(), 0, This);
183 static HRESULT WINAPI dbinit_Initialize(IDBInitialize *iface)
185 dbinit *This = impl_from_IDBInitialize(iface);
187 FIXME("(%p) stub\n", This);
192 static HRESULT WINAPI dbinit_Uninitialize(IDBInitialize *iface)
194 dbinit *This = impl_from_IDBInitialize(iface);
196 FIXME("(%p) stub\n", This);
201 static const IDBInitializeVtbl dbinit_vtbl =
203 dbinit_QueryInterface,
210 static HRESULT create_db_init(void **obj)
218 This = HeapAlloc(GetProcessHeap(), 0, sizeof(*This));
219 if(!This) return E_OUTOFMEMORY;
221 This->IDBInitialize_iface.lpVtbl = &dbinit_vtbl;
222 This->IDBProperties_iface.lpVtbl = &dbprops_vtbl;
225 *obj = &This->IDBInitialize_iface;
230 static HRESULT WINAPI datainit_QueryInterface(IDataInitialize *iface, REFIID riid, void **obj)
232 datainit *This = impl_from_IDataInitialize(iface);
233 TRACE("(%p)->(%s, %p)\n", This, debugstr_guid(riid), obj);
237 if(IsEqualIID(riid, &IID_IUnknown) ||
238 IsEqualIID(riid, &IID_IDataInitialize))
240 *obj = &This->IDataInitialize_iface;
244 FIXME("interface %s not implemented\n", debugstr_guid(riid));
245 return E_NOINTERFACE;
248 IDataInitialize_AddRef(iface);
252 static ULONG WINAPI datainit_AddRef(IDataInitialize *iface)
254 datainit *This = impl_from_IDataInitialize(iface);
255 TRACE("(%p)\n", This);
257 return InterlockedIncrement(&This->ref);
260 static ULONG WINAPI datainit_Release(IDataInitialize *iface)
262 datainit *This = impl_from_IDataInitialize(iface);
265 TRACE("(%p)\n", This);
267 ref = InterlockedDecrement(&This->ref);
270 HeapFree(GetProcessHeap(), 0, This);
276 static void free_dbpropset(ULONG count, DBPROPSET *propset)
280 for (i = 0; i < count; i++)
284 for (p = 0; p < propset[i].cProperties; p++)
285 VariantClear(&propset[i].rgProperties[p].vValue);
287 CoTaskMemFree(propset[i].rgProperties);
289 CoTaskMemFree(propset);
295 DBPROPOPTIONS options;
299 static const WCHAR datasourceW[] = {'D','a','t','a',' ','S','o','u','r','c','e',0};
300 static const WCHAR persistsiW[] = {'P','e','r','s','i','s','t',' ','S','e','c','u','r','i','t','y',' ','I','n','f','o',0};
302 static const struct dbproperty dbproperties[] = {
303 { datasourceW, DBPROP_INIT_DATASOURCE, DBPROPOPTIONS_REQUIRED, VT_BSTR },
304 { persistsiW, DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, DBPROPOPTIONS_OPTIONAL, VT_BOOL }
307 static HRESULT set_dbpropset(BSTR name, BSTR value, DBPROPSET **propset)
314 max = sizeof(dbproperties)/sizeof(struct dbproperty) - 1;
322 r = strcmpW(dbproperties[n].name, name);
335 FIXME("unsupported property %s\n", debugstr_w(name));
341 V_VT(&src) = VT_BSTR;
342 V_BSTR(&src) = value;
344 hr = VariantChangeType(&dest, &src, 0, dbproperties[n].type);
347 ERR("failed to init property %s value as type %d\n", debugstr_w(name), dbproperties[n].type);
351 *propset = CoTaskMemAlloc(sizeof(DBPROPSET));
355 return E_OUTOFMEMORY;
358 (*propset)->rgProperties = CoTaskMemAlloc(sizeof(DBPROP));
359 if (!(*propset)->rgProperties)
362 CoTaskMemFree(*propset);
363 return E_OUTOFMEMORY;
366 (*propset)->cProperties = 1;
367 (*propset)->guidPropertySet = DBPROPSET_DBINIT;
368 (*propset)->rgProperties[0].dwPropertyID = dbproperties[n].id;
369 (*propset)->rgProperties[0].dwOptions = dbproperties[n].options;
370 (*propset)->rgProperties[0].dwStatus = 0;
371 memset(&(*propset)->rgProperties[0].colid, 0, sizeof(DBID));
372 (*propset)->rgProperties[0].vValue = dest;
377 /*** IDataInitialize methods ***/
378 static HRESULT WINAPI datainit_GetDataSource(IDataInitialize *iface, IUnknown *outer, DWORD clsctx,
379 LPWSTR initstring, REFIID riid, IUnknown **datasource)
381 static const WCHAR providerW[] = {'P','r','o','v','i','d','e','r','=',0};
382 static const WCHAR msdasqlW[] = {'M','S','D','A','S','Q','L',0};
383 datainit *This = impl_from_IDataInitialize(iface);
384 IDBProperties *dbprops;
390 TRACE("(%p)->(%p 0x%x %s %s %p)\n", This, outer, clsctx, debugstr_w(initstring), debugstr_guid(riid), datasource);
392 /* first get provider name */
393 provclsid = IID_NULL;
394 if (initstring && (prov = strstrW(initstring, providerW)))
396 WCHAR *start, *progid;
399 prov += sizeof(providerW)/sizeof(WCHAR)-1;
401 while (*prov && *prov != ';')
403 TRACE("got provider %s\n", debugstr_wn(start, prov-start));
406 progid = CoTaskMemAlloc((len+1)*sizeof(WCHAR));
407 if (!progid) return E_OUTOFMEMORY;
409 memcpy(progid, start, len*sizeof(WCHAR));
412 hr = CLSIDFromProgID(progid, &provclsid);
413 CoTaskMemFree(progid);
416 ERR("provider %s not registered\n", debugstr_wn(start, prov-start));
422 hr = CLSIDFromProgID(msdasqlW, &provclsid);
424 ERR("ODBC provider for OLE DB not registered\n");
427 /* check for provider mismatch if it was specified in init string */
428 if (*datasource && prov)
430 DBPROPIDSET propidset;
431 enum DBPROPENUM prop;
435 hr = IUnknown_QueryInterface(*datasource, &IID_IDBProperties, (void**)&dbprops);
438 WARN("provider doesn't support IDBProperties\n");
442 prop = DBPROP_INIT_DATASOURCE;
443 propidset.rgPropertyIDs = ∝
444 propidset.cPropertyIDs = 1;
445 propidset.guidPropertySet = DBPROPSET_DBINIT;
448 hr = IDBProperties_GetProperties(dbprops, 1, &propidset, &count, &propset);
449 IDBProperties_Release(dbprops);
452 WARN("GetProperties failed for datasource, 0x%08x\n", hr);
456 TRACE("initial data source provider %s\n", debugstr_w(V_BSTR(&propset->rgProperties[0].vValue)));
458 CLSIDFromProgID(V_BSTR(&propset->rgProperties[0].vValue), &initprov);
459 free_dbpropset(count, propset);
461 if (!IsEqualIID(&provclsid, &initprov)) return DB_E_MISMATCHEDPROVIDER;
466 if (!IsEqualIID(&provclsid, &IID_NULL))
467 hr = CoCreateInstance(&provclsid, outer, clsctx, riid, (void**)datasource);
469 if (FAILED(hr) && IsEqualIID(riid, &IID_IDBInitialize))
470 hr = create_db_init((void**)datasource);
473 /* now set properties */
478 hr = IUnknown_QueryInterface(*datasource, &IID_IDBProperties, (void**)&dbprops);
481 WARN("provider doesn't support IDBProperties\n");
486 while (start && (eq = strchrW(start, '=')))
488 static const WCHAR providerW[] = {'P','r','o','v','i','d','e','r',0};
489 WCHAR *scol = strchrW(eq+1, ';');
492 name = SysAllocStringLen(start, eq - start);
493 /* skip equal sign to get value */
495 value = SysAllocStringLen(eq, scol ? scol - eq : -1);
497 /* skip semicolon if present */
501 if (!strcmpW(name, providerW))
504 SysFreeString(value);
508 TRACE("property (name=%s, value=%s)\n", debugstr_w(name), debugstr_w(value));
510 hr = set_dbpropset(name, value, &propset);
512 SysFreeString(value);
513 if (FAILED(hr)) return hr;
515 hr = IDBProperties_SetProperties(dbprops, 1, propset);
516 free_dbpropset(1, propset);
517 TRACE("provider ret 0x%08x\n", hr);
520 IDBProperties_Release(dbprops);
526 /* returns character length of string representation */
527 static int get_propvalue_length(DBPROP *prop)
532 if (V_VT(&prop->vValue) == VT_BSTR) return SysStringLen(V_BSTR(&prop->vValue));
535 hr = VariantChangeType(&str, &prop->vValue, 0, VT_BSTR);
538 int len = SysStringLen(V_BSTR(&str));
546 static void write_propvalue_str(WCHAR *str, DBPROP *prop)
548 VARIANT *v = &prop->vValue;
552 if (V_VT(v) == VT_BSTR)
554 strcatW(str, V_BSTR(v));
559 hr = VariantChangeType(&vstr, v, VARIANT_ALPHABOOL, VT_BSTR);
562 strcatW(str, V_BSTR(&vstr));
567 static WCHAR *get_propinfo_descr(DBPROP *prop, DBPROPINFOSET *propinfoset)
571 for (i = 0; i < propinfoset->cPropertyInfos; i++)
572 if (propinfoset->rgPropertyInfos[i].dwPropertyID == prop->dwPropertyID)
573 return propinfoset->rgPropertyInfos[i].pwszDescription;
578 static void free_dbpropinfoset(ULONG count, DBPROPINFOSET *propinfoset)
582 for (i = 0; i < count; i++)
586 for (p = 0; p < propinfoset[i].cPropertyInfos; p++)
587 VariantClear(&propinfoset[i].rgPropertyInfos[p].vValues);
589 CoTaskMemFree(propinfoset[i].rgPropertyInfos);
591 CoTaskMemFree(propinfoset);
594 static HRESULT WINAPI datainit_GetInitializationString(IDataInitialize *iface, IUnknown *datasource,
595 boolean include_pass, LPWSTR *init_string)
597 static const WCHAR provW[] = {'P','r','o','v','i','d','e','r','=',0};
598 static const WCHAR colW[] = {';',0};
599 datainit *This = impl_from_IDataInitialize(iface);
600 DBPROPINFOSET *propinfoset;
601 IDBProperties *props;
602 DBPROPIDSET propidset;
603 ULONG count, infocount;
604 WCHAR *progid, *desc;
611 TRACE("(%p)->(%p %d %p)\n", This, datasource, include_pass, init_string);
613 /* IPersist support is mandatory for data sources */
614 hr = IUnknown_QueryInterface(datasource, &IID_IPersist, (void**)&persist);
615 if (FAILED(hr)) return hr;
617 memset(&clsid, 0, sizeof(clsid));
618 hr = IPersist_GetClassID(persist, &clsid);
619 IPersist_Release(persist);
620 if (FAILED(hr)) return hr;
623 ProgIDFromCLSID(&clsid, &progid);
624 TRACE("clsid=%s, progid=%s\n", debugstr_guid(&clsid), debugstr_w(progid));
626 /* now get initialization properties */
627 hr = IUnknown_QueryInterface(datasource, &IID_IDBProperties, (void**)&props);
630 WARN("IDBProperties not supported\n");
631 CoTaskMemFree(progid);
635 propidset.rgPropertyIDs = NULL;
636 propidset.cPropertyIDs = 0;
637 propidset.guidPropertySet = DBPROPSET_DBINIT;
640 hr = IDBProperties_GetProperties(props, 1, &propidset, &count, &propset);
643 WARN("failed to get data source properties, 0x%08x\n", hr);
644 CoTaskMemFree(progid);
649 IDBProperties_GetPropertyInfo(props, 1, &propidset, &infocount, &propinfoset, &desc);
650 IDBProperties_Release(props);
652 /* check if we need to skip password */
653 len = strlenW(progid) + strlenW(provW) + 1; /* including ';' */
654 for (i = 0; i < count; i++)
656 WCHAR *descr = get_propinfo_descr(&propset->rgProperties[i], propinfoset);
659 /* include '=' and ';' */
660 len += strlenW(descr) + 2;
661 len += get_propvalue_length(&propset->rgProperties[i]);
664 if ((propset->rgProperties[i].dwPropertyID == DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO) &&
665 (V_BOOL(&propset->rgProperties[i].vValue) == VARIANT_FALSE))
666 include_pass = FALSE;
669 len *= sizeof(WCHAR);
670 *init_string = CoTaskMemAlloc(len);
674 strcatW(*init_string, provW);
675 strcatW(*init_string, progid);
676 strcatW(*init_string, colW);
677 CoTaskMemFree(progid);
679 for (i = 0; i < count; i++)
683 if (!include_pass && propset->rgProperties[i].dwPropertyID == DBPROP_AUTH_PASSWORD) continue;
685 descr = get_propinfo_descr(&propset->rgProperties[i], propinfoset);
688 static const WCHAR eqW[] = {'=',0};
689 strcatW(*init_string, descr);
690 strcatW(*init_string, eqW);
691 write_propvalue_str(*init_string, &propset->rgProperties[i]);
692 strcatW(*init_string, colW);
696 free_dbpropset(count, propset);
697 free_dbpropinfoset(infocount, propinfoset);
701 TRACE("%s\n", debugstr_w(*init_string));
705 static HRESULT WINAPI datainit_CreateDBInstance(IDataInitialize *iface, REFCLSID provider,
706 IUnknown *outer, DWORD clsctx, LPWSTR reserved, REFIID riid,
707 IUnknown **datasource)
709 datainit *This = impl_from_IDataInitialize(iface);
711 TRACE("(%p)->(%s %p 0x%08x %s %s %p)\n", This, debugstr_guid(provider), outer, clsctx, debugstr_w(reserved),
712 debugstr_guid(riid), datasource);
714 return CoCreateInstance(provider, outer, clsctx, riid, (void**)datasource);
717 static HRESULT WINAPI datainit_RemoteCreateDBInstanceEx(IDataInitialize *iface, REFCLSID clsidProvider,
718 IUnknown *pUnkOuter, DWORD dwClsCtx, LPWSTR pwszReserved, COSERVERINFO *pServerInfo,
719 DWORD cmq, GUID **rgpIID, IUnknown **rgpItf, HRESULT *rghr)
721 datainit *This = impl_from_IDataInitialize(iface);
723 FIXME("(%p)->()\n", This);
728 static HRESULT WINAPI datainit_LoadStringFromStorage(IDataInitialize *iface, LPWSTR pwszFileName,
729 LPWSTR *ppwszInitializationString)
731 datainit *This = impl_from_IDataInitialize(iface);
733 FIXME("(%p)->(%s %p)\n", This, debugstr_w(pwszFileName), ppwszInitializationString);
738 static HRESULT WINAPI datainit_WriteStringToStorage(IDataInitialize *iface, LPWSTR pwszFileName,
739 LPWSTR pwszInitializationString, DWORD dwCreationDisposition)
741 datainit *This = impl_from_IDataInitialize(iface);
743 FIXME("(%p)->(%s %s %d)\n", This, debugstr_w(pwszFileName), debugstr_w(pwszInitializationString), dwCreationDisposition);
749 static const struct IDataInitializeVtbl datainit_vtbl =
751 datainit_QueryInterface,
754 datainit_GetDataSource,
755 datainit_GetInitializationString,
756 datainit_CreateDBInstance,
757 datainit_RemoteCreateDBInstanceEx,
758 datainit_LoadStringFromStorage,
759 datainit_WriteStringToStorage
762 HRESULT create_data_init(IUnknown *outer, void **obj)
766 TRACE("(%p)\n", obj);
768 if(outer) return CLASS_E_NOAGGREGATION;
772 This = HeapAlloc(GetProcessHeap(), 0, sizeof(*This));
773 if(!This) return E_OUTOFMEMORY;
775 This->IDataInitialize_iface.lpVtbl = &datainit_vtbl;
778 *obj = &This->IDataInitialize_iface;