C / C++ / MFC

Re: Need some help with visual c++ and sql2000 ado connection

16-Jan-07 2:48

XTr1NiTy wrote:
But at compile time i get a whole lot of errors...

Don't be stingy! Share those errors with us.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

KarstenK16-Jan-07 2:55

KarstenK

16-Jan-07 2:55

You better include the (full) path, so the compiler finds the dll.

You better include the typical errors, often helps reading and understanding the error messages. Most the are right. Dead | X|

Greetings from Germany

Re: Need some help with visual c++ and sql2000 ado connection

XTr1NiTy16-Jan-07 3:04

XTr1NiTy

16-Jan-07 3:04

Thank for the quick reply guys Smile | :)

the errors are :
I will try the full path quickly maybe it will help D'Oh! | :doh:

--------------------Configuration: iDL_Scan - Win32 (WCE ARMV4I) Debug--------------------
Compiling resources...
Compiling...
StdAfx.cpp
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(409) : warning C4146: unary minus operator applied to unsigned type, result still unsigned
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(791) : error C2146: syntax error : missing ';' before identifier '_NewEnum'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(791) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1582) : error C2146: syntax error : missing ';' before identifier 'DataSource'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1582) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1582) : error C2501: 'DataSource' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1584) : error C2146: syntax error : missing ';' before identifier 'ActiveCommand'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1584) : error C2501: 'IDispatchPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1584) : error C2501: 'ActiveCommand' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1595) : error C2146: syntax error : missing ';' before identifier 'GetDataSource'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1595) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1601) : error C2146: syntax error : missing ';' before identifier 'GetActiveCommand'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1601) : error C2501: 'IDispatchPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1834) : error C2146: syntax error : missing ';' before identifier 'DataFormat'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1834) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1834) : error C2501: 'DataFormat' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1856) : error C2146: syntax error : missing ';' before identifier 'GetDataFormat'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(1856) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2488) : error C2146: syntax error : missing ';' before identifier 'DSO'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2488) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2488) : error C2501: 'DSO' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2490) : error C2146: syntax error : missing ';' before identifier 'Session'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2490) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2490) : error C2501: 'Session' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2496) : error C2146: syntax error : missing ';' before identifier 'GetDSO'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2496) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2497) : error C2146: syntax error : missing ';' before identifier 'GetSession'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2497) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2806) : error C2146: syntax error : missing ';' before identifier 'Row'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2806) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2806) : error C2501: 'Row' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2808) : error C2146: syntax error : missing ';' before identifier 'ParentRow'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2808) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2808) : error C2501: 'ParentRow' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2814) : error C2146: syntax error : missing ';' before identifier 'GetRow'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2814) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2840) : error C2146: syntax error : missing ';' before identifier 'Stream'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2840) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2840) : error C2208: 'struct ADODB::Stream' : no members defined using this type
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2846) : error C2146: syntax error : missing ';' before identifier 'GetStream'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2846) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2868) : error C2146: syntax error : missing ';' before identifier 'OLEDBCommand'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2868) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2868) : error C2501: 'OLEDBCommand' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2874) : error C2146: syntax error : missing ';' before identifier 'GetOLEDBCommand'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2874) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2905) : error C2146: syntax error : missing ';' before identifier 'Rowset'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2905) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2905) : error C2501: 'Rowset' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2909) : error C2146: syntax error : missing ';' before identifier 'RowPosition'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2909) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2909) : error C2501: 'RowPosition' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2915) : error C2146: syntax error : missing ';' before identifier 'GetRowset'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2915) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2921) : error C2146: syntax error : missing ';' before identifier 'GetRowPosition'
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(2921) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tli(17) : error C2065: '_com_issue_errorex' : undeclared identifier
c:\myprojects\idl_scan\armv4idbg\msado15.tli(21) : error C2143: syntax error : missing ';' before 'tag::id'
c:\myprojects\idl_scan\armv4idbg\msado15.tli(21) : error C2433: 'IUnknownPtr' : 'inline' not permitted on data declarations
c:\myprojects\idl_scan\armv4idbg\msado15.tli(21) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers
c:\myprojects\idl_scan\armv4idbg\msado15.tli(21) : fatal error C1004: unexpected end of file found
Error executing clarm.exe.

iDL_Scan.exe - 60 error(s), 1 warning(s)

Re: Need some help with visual c++ and sql2000 ado connection

prasad_som16-Jan-07 3:07

prasad_som

16-Jan-07 3:07

I wonder, why you need to include .tlh.
Doesn't importing .tlb suffice.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Re: Need some help with visual c++ and sql2000 ado connection

XTr1NiTy16-Jan-07 3:12

XTr1NiTy

16-Jan-07 3:12

prasad_som wrote:
I wonder, why you need to include .tlh.
Doesn't importing .tlb suffice.

Prasad

I have no idea, but afaik i dont import it explicitly.

Re: Need some help with visual c++ and sql2000 ado connection

KarstenK16-Jan-07 3:47

KarstenK

16-Jan-07 3:47

I think that you have to use some option of the #import commando, but I have no clue which. Confused | :confused:

Greetings from Germany

Re: Need some help with visual c++ and sql2000 ado connection

David Crow16-Jan-07 6:37

Re: Need some help with visual c++ and sql2000 ado connection

16-Jan-07 6:37

XTr1NiTy wrote:
c:\myprojects\idl_scan\armv4idbg\msado15.tlh(409) : warning C4146: unary minus operator applied to unsigned type, result still unsigned

See here.

For the others, have you included stdafx.h before the #import statement?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

XTr1NiTy16-Jan-07 3:33

XTr1NiTy

16-Jan-07 3:33

Sorry about that, i know its looong, and that happens when i include the file. If i dont include msado15.dll it doesnt give any errors, but that is with commenting out this code i got from examples (would it work for a sql 2000 database?) :

<br />
HRESULT hr;<br />
CoInitialize(NULL);<br />
try<br />
{<br />
ADODB::_ConnectionPtr connection;<br />
hr = connection.CreateInstance(__uuidof(ADODB::Connection));<br />
if(FAILED(hr))<br />
{<br />
throw __com_error(hr);<br />
}<br />
<br />
ADODB::_RecordsetPtr recordset;<br />
hr = recordset.CreateInstance(__uuidof(ADOBD::RecordSet));<br />
if(FAILED(hr))<br />
{<br />
throw _com_error(hr);<br />
}<br />
<br />
connection->CursorLocation = ADODB::adUseClient;<br />
connection->Open(L"Provider=sqloledb;Data Source=Sunserver;"L"Initial Catalog=IT_DB;User Id=testassword=test;", L,"",L"",ADODB::adConnectUnspecified);<br />
<br />
recordset->Open("SELECT * from Users",connection.GetInterfacePtr(),ADODB::adOpenForwardOnly,ADODB::adLockReadOnly, ADODB::adCmdText);<br />
<br />
<br />
while(!recordset->ADOEOF)<br />
{<br />
_variant_t var;<br />
var = recordset->Fields->GetItem(L"Username")->GetValue();<br />
std::cout << static_cast(_bstr_t(var.bstrVal)) << std::endl;<br />
recordset->MoveNext();<br />
};<br />
<br />
recordset->Close();<br />

Linker errors in vc++

siddharthsan16-Jan-07 1:25

siddharthsan

16-Jan-07 1:25

hi,
while compling FlashPlayer7, i got some of the below linker errors,and iam sure that the settings are correct,

win32camera.obj : error LNK2001: unresolved external symbol "public: virtual unsigned long __stdcall CBaseFilter::NonDelegatingRelease(void)" (?NonDelegatingRelease@CBaseFilter@@UAGKXZ)
win32camera.obj : error LNK2001: unresolved external symbol _IID_IIPDVDec
win32camera.obj : error LNK2001: unresolved external symbol "public: __thiscall CMediaType::CMediaType(struct _AMMediaType const &,long *)" (??0CMediaType@@QAE@ABU_AMMediaType@@PAJ@Z)
win32camera.obj : error LNK2001: unresolved external symbol "long __stdcall CopyMediaType(struct _AMMediaType *,struct _AMMediaType const *)" (?CopyMediaType@@YGJPAU_AMMediaType@@PBU1@@Z)
strmbasd.lib(wxdebug.obj) : error LNK2001: unresolved external symbol __imp__strrchr
strmbasd.lib(dllentry.obj) : error LNK2001: unresolved external symbol __imp__strrchr
strmbasd.lib(dllsetup.obj) : error LNK2001: unresolved external symbol "class CFactoryTemplate * g_Templates" (?g_Templates@@3PAVCFactoryTemplate@@A)
strmbasd.lib(dllentry.obj) : error LNK2001: unresolved external symbol "class CFactoryTemplate * g_Templates" (?g_Templates@@3PAVCFactoryTemplate@@A)
strmbasd.lib(dllsetup.obj) : error LNK2001: unresolved external symbol "int g_cTemplates" (?g_cTemplates@@3HA)
strmbasd.lib(dllentry.obj) : error LNK2001: unresolved external symbol "int g_cTemplates" (?g_cTemplates@@3HA)
Debug\SAFlashPlayer.exe : fatal error LNK1120: 7 unresolved externals
Error executing link.exe.

Thanks
siddharth

Rage16-Jan-07 1:34

Rage

16-Jan-07 1:34

You need to compile those functions somewhere. They are missing in the build, or are not part of the library or .dll you are including in your project.

MuraliKrishnaP16-Jan-07 1:36

MuraliKrishnaP

16-Jan-07 1:36

(my first post)

this is because you are not specifying required library files.

go to project settings -> link tab -> in object library modules specify required lib files (giving spaces).

HTH,

-- Murali Krishna

siddharthsan16-Jan-07 1:54

siddharthsan

16-Jan-07 1:54

hi,
Thanks
I checked the lib files,no problem in that,
but now also it's showing the same error.........

Regards
siddharth

Roger Stoltz16-Jan-07 2:12

Roger Stoltz

16-Jan-07 2:12

siddharthsan wrote:
i got some of the below linker errors,and iam sure that the settings are correct

Well, if you're sure your settings are correct then the linker errors you've got must only exist in your imagination, or your linker is pulling your leg...;)

More seriously:
It's obvious that your settings are incorrect for the configuration you're trying to build, otherwise there wouldn't be any linker errors. Make sure that you verify the same configuration as the one you're trying to build.
You are missing some libraries in your linker statement.

--
Roger

"It's supposed to be hard, otherwise anybody could do it!" - selfquote

David Crow16-Jan-07 2:51

16-Jan-07 2:51

Have you accounted for all of these possibilities?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

KarstenK16-Jan-07 2:52

KarstenK

16-Jan-07 2:52

the "int g_cTemplates" have you to delcare in a *.h and implement in a cpp file. Dont ferget to set it to a proper value (=0).

I guess you have not included the implemention in the build i.g. the cpp Files.

Sleepy | :zzz:

Greetings from Germany

chacoo26-Feb-07 22:13

chacoo

26-Feb-07 22:13

Pls check library directory in vc option. Make sure that baseclasses directory is before vc library directory. Because there may be STRMBASD.LIB and STRMBASE.LIB in vc library directory.

Hope this will help you.

unicode

manu_220516-Jan-07 1:24

16-Jan-07 1:24

Hi I have a array of WCHAR type and my data is in buffer in unicode format whenever i try to read byte from buffer it add some nonprintable character at last .

And if i try to read byte in char array it just display only first character.
what is the reason

manu

Rage16-Jan-07 1:25

Rage

16-Jan-07 1:25

post some code ? Probably your end of string char does not match.

manu_220516-Jan-07 1:33

16-Jan-07 1:33

WCHAR *m_pbytTemp=new WCHAR[From-To+1];
memset(m_pbytTemp,0x0,From-To);
memcpy(m_pbytTemp,&m_pbytFileBuffer[To],From-To);
m_pbytTemp[From-To]=L'\0';

manu

Rajesh R Subramanian16-Jan-07 1:42

Rajesh R Subramanian

16-Jan-07 1:42

manu_2205 wrote:
memset(m_pbytTemp,0x0,From-To);
memcpy(m_pbytTemp,&m_pbytFileBuffer[To],From-To);

~~memset(m_pbytTemp,0x0,From-To);~~
Use wmemset()while working with Unicode!

~~memcpy(m_pbytTemp,&m_pbytFileBuffer[To],From-To);~~
Similarly use wmemcpy()!

Nobody can give you wiser advice than yourself. - Cicero
ப்ரம்மா

manu_220516-Jan-07 1:50

16-Jan-07 1:50

But m_pbytFileBuffer is of Byte *(to hold the bytes)

manu

David Crow16-Jan-07 2:58

16-Jan-07 2:58

Then shouldn't you be using something like W2A()?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

manu_220516-Jan-07 1:20