Click here to Skip to main content
14,608,244 members
   

Database

 
AnswerRe: MSDE and MS SQL 2005 Express Edition inquiry Pin
Paul Conrad4-May-06 14:37
professionalPaul Conrad4-May-06 14:37 
QuestionClone rows based on existing rows Pin
Ravi Bhavnani4-May-06 11:42
professionalRavi Bhavnani4-May-06 11:42 
AnswerRe: Clone rows based on existing rows Pin
goyal manish4-May-06 20:12
Membergoyal manish4-May-06 20:12 
GeneralRe: Clone rows based on existing rows Pin
Ravi Bhavnani5-May-06 8:47
professionalRavi Bhavnani5-May-06 8:47 
QuestionCheckBox Control and RowID Pin
karinb4-May-06 5:41
Memberkarinb4-May-06 5:41 
AnswerRe: CheckBox Control and RowID Pin
Paddy Boyd4-May-06 5:56
MemberPaddy Boyd4-May-06 5:56 
AnswerRe: CheckBox Control and RowID Pin
goyal manish4-May-06 20:18
Membergoyal manish4-May-06 20:18 
QuestionOle DB for OLAP Pin
Tarek Jabri4-May-06 4:50
MemberTarek Jabri4-May-06 4:50 
I am trying to connect to MDP provider using
OLE DB For OLAP following these steps:
1-i'v got the List of providers..and choose one of them
2-i called ParseDisplayName() ,..the i called BindMoniker() method as written in the code below...
3-When i Call ppIDBInitialize->Initialize(); ..i got Access voilation exception
can any one help me please....
Here is the code:

ULONG chEaten = 0;
hr = pIParseDisplayName->ParseDisplayName(pIBindCtx,rgEnumInfo[i].wszParseName, &chEaten, &pIMoniker);
ppIDBInitialize=NULL;
hr = BindMoniker(pIMoniker, 0, IID_IUnknown,(void**)&ppIDBInitialize);

rgProps[0].dwPropertyID = DBPROP_INIT_LOCATION;
rgProps[0].vValue.vt  = VT_BSTR;
rgProps[0].vValue.bstrVal  =  SysAllocString(L"server");

rgProps[1].dwPropertyID = DBPROP_INIT_DATASOURCE;
rgProps[1].vValue.vt  = VT_BSTR;
rgProps[1].vValue.bstrVal  = SysAllocString(L"FoodMart 2000");

rgProps[2].dwPropertyID = DBPROP_AUTH_INTEGRATED;
rgProps[2].vValue.vt  = VT_BSTR;
rgProps[2].vValue.bstrVal  = SysAllocString(L"SSPI");

// Create the structure containing the properties.
DBPROPSET PropSet;
PropSet.rgProperties      = rgProps;
PropSet.cProperties       = 3;
PropSet.guidPropertySet   = DBPROPSET_DBINIT;

IDBProperties *pIDBProperties=NULL;

// create properties pointer
hr=ppIDBInitialize->QueryInterface(IID_IDBProperties,(void**)&pIDBProperties);

// Set properties
hr=pIDBProperties->SetProperties(1, &PropSet);

// Initialize the data source object.
 hr = ppIDBInitialize->Initialize();   // Access voilation exception

QuestionODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.sysconstraints' Pin
thomasa4-May-06 3:39
Memberthomasa4-May-06 3:39 
AnswerFixed Pin
thomasa4-May-06 23:50
Memberthomasa4-May-06 23:50 
QuestionSQL 2005 Analysis Services - pivot table Pin
alex_kl4-May-06 3:22
Memberalex_kl4-May-06 3:22 
QuestionWhy can't I update my data ? Pin
nirishere4-May-06 2:47
Membernirishere4-May-06 2:47 
AnswerRe: Why can't I update my data ? Pin
jonathan154-May-06 5:06
Memberjonathan154-May-06 5:06 
GeneralRe: Why can't I update my data ? Pin
nirishere4-May-06 7:20
Membernirishere4-May-06 7:20 
GeneralRe: Why can't I update my data ? Pin
jonathan154-May-06 22:42
Memberjonathan154-May-06 22:42 
GeneralRe: Why can't I update my data ? Pin
nirishere7-May-06 11:26
Membernirishere7-May-06 11:26 
QuestionUnion statement Pin
phokojoe4-May-06 2:19
Memberphokojoe4-May-06 2:19 
GeneralRe: Union statement Pin
mr_123454-May-06 2:41
Membermr_123454-May-06 2:41 
AnswerRe: Union statement Pin
Colin Angus Mackay4-May-06 4:16
MemberColin Angus Mackay4-May-06 4:16 
QuestionInput data from file to report Pin
krishna194-May-06 2:15
Memberkrishna194-May-06 2:15 
QuestionStored Procedure union Pin
phokojoe4-May-06 2:08
Memberphokojoe4-May-06 2:08 
AnswerRe: Stored Procedure union Pin
Colin Angus Mackay4-May-06 4:20
MemberColin Angus Mackay4-May-06 4:20 
GeneralRe: Stored Procedure union Pin
phokojoe4-May-06 21:49
Memberphokojoe4-May-06 21:49 
GeneralRe: Stored Procedure union Pin
phokojoe9-May-06 22:23
Memberphokojoe9-May-06 22:23 
QuestionAdo controls Pin
kishgenius3-May-06 23:54
Memberkishgenius3-May-06 23:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.