U++ forum: Welcome to the forum

[SOLVE] Compile Error for OleDB with MSC9 Compiler [message #38736]

Fri, 11 January 2013 05:45

navi
Messages: 107
Registered: February 2012
Location: Sydney, Australia

Experienced Member

I am trying to connect to MS Access DB using OleDB.

attached is the project and the database both in as Access mdb format and in SQLite3. SQLite3 is easy and works straight away. but cant get the Access DB to work. I read in a thread that to connect to AccessDB use OleDB. and other post that says MINGW doesnt work and did not work for me either. Another post suggesting that MSC works with OleDB. unfortunately there is no example of use of OleDB in Example section.

On Debug mode gets these following linking error.

----- SQLTestProj001 ( GUI MAIN MSC9 DEBUG DEBUG_FULL BLITZ WIN32 MSC ) (11 / 11)
Linking...
main.obj : error LNK2019: unresolved external symbol "public: virtual __thiscall Upp::OleDBSession::~OleDBSession(void)" 
	(??1OleDBSession@Upp@@UAE@XZ) referenced in function "public: __thiscall mywindow::mywindow(void)" (??0mywindow@@QAE@
	XZ)
main.obj : error LNK2019: unresolved external symbol "public: bool __thiscall Upp::OleDBSession::Open(class Upp::String)"
	 (?Open@OleDBSession@Upp@@QAE_NVString@2@@Z) referenced in function "public: __thiscall mywindow::mywindow(void)" (??
	0mywindow@@QAE@XZ)
main.obj : error LNK2019: unresolved external symbol "public: __thiscall Upp::OleDBSession::OleDBSession(void)" (??0OleDB
	Session@Upp@@QAE@XZ) referenced in function "public: __thiscall mywindow::mywindow(void)" (??0mywindow@@QAE@XZ)
J:\Out\MyApps\SQLTestProj001\MSC9.Debug.Debug_Full.Gui.Main\SQLTestProj001.exe : fatal error LNK1120: 3 unresolved extern
	als

There were errors. (0:01.01)

if compiled in optimal mode as suggested here, get the following errors instead.

----- Sql ( GUI MSC9 BLITZ WIN32 MSC ) (10 / 11)
BLITZ: Session.cpp Script.cpp MassInsert.cpp SqlSchema.cpp util_td.cpp IntroSch.cpp ExportSch.cpp
c:\upp\uppsrc\richtext\txtop.cpp(54) : fatal error C1001: An internal error has occurred in the compiler.
(compiler file 'f:\dd\vctools\compiler\utc\src\p2\main.c[0x6DFF4F50:0x0000002C]', line 182)
 To work around this problem, try simplifying or changing the program near the locations listed above.
Please choose the Technical Support command on the Visual C++ 
 Help menu, or open the Technical Support help file for more information
Internal Compiler Error in C:\Program Files (x86)\Microsoft Visual Studio 9.0\Vc\Bin\cl.exe.  You will be prompted to sen
	d an error report to Microsoft later.

regards
Navi

Attachment: SQLTestProj001 11-01-2013 #1532.rar
(Size: 9.42KB, Downloaded 247 times)

[Updated on: Fri, 11 January 2013 08:19]

Report message to a moderator