Creating MySQL and Oracle (OCI) plugins.

[Blando]

Environment:

Windows 7 x64 Ultimate
Visual Studio 2008 w/ Qt Integration
Qt 4.6.2 libraries VS2008

• configure (no other switches)

ABSTRACT:

I have Qt configured and built already. I have working examples and everything appears fine. What I now is to build the MySQL and the Oracle OCI plugins. I have downloaded the required sources for both databases. (the include, lib)
I have followed the Qt Documentation for building the plugins but I get LNK errors for both builds. Below is the error I get for building MySQL plugin. The Oracle one is very similar.

..\..\..\..\plugins\sqldrivers\qsqlmysqld4.dll : fatal error LNK1120: 50 unresol
ved externals
NMAKE : fatal error U1077: '"c:\My Programs\Microsoft Visual Studio 9.0\VC\BIN\l
ink.EXE"' : return code '0x460'
Stop.
NMAKE : fatal error U1077: '"c:\My Programs\Microsoft Visual Studio 9.0\VC\BIN\n
make.exe"' : return code '0x2'
Stop.

..\..\..\..\plugins\sqldrivers\qsqlmysqld4.dll : fatal error LNK1120: 50 unresol
ved externals
NMAKE : fatal error U1077: '"c:\My Programs\Microsoft Visual Studio 9.0\VC\BIN\l
ink.EXE"' : return code '0x460'
Stop.
NMAKE : fatal error U1077: '"c:\My Programs\Microsoft Visual Studio 9.0\VC\BIN\n
make.exe"' : return code '0x2'
Stop.

To copy to clipboard, switch view to plain text mode 

Any help would be greatly appreciated. What am I doing wrong?

-Blando

[ChrisW67]

The MySQL and Oracle link libraries are not being found by the linker. Related error messages should be showing above the snippet you posted.

You need to put the MySQL/Oracle bin or lib directories in the linker's library search path. The VC++ linker can be told to look in other places using the LIB environment variable or /LIBPATH command line option. If this were your own project you could adjust the LIBS variable in your PRO file.

[Blando]

I think I have already done this.

Starting from scratch just trying to build OCI.

cd c:\Qt\4.6.2\sql\plugins\sqldrivers\oci
qmake oci.pro

cd c:\Qt\4.6.2\sql\plugins\sqldrivers\oci
qmake oci.pro

To copy to clipboard, switch view to plain text mode 

• Results in: "Cannot open include file: 'oci.h' ...." <---GOOD

nmake distclean
set include=%include%c:\Oracle\sdk\include;
qmake oci.pro
nmake

nmake distclean
set include=%include%c:\Oracle\sdk\include;
qmake oci.pro
nmake

To copy to clipboard, switch view to plain text mode 

• Results in: "fatal error LNK1104: cannot open file 'oci.lib'......" <---GOOD

Finally,

nmake distclean
set lib=%lib%c:\Oracle\sdk\lib\msvc;
qmake oci.pro
nmake

nmake distclean
set lib=%lib%c:\Oracle\sdk\lib\msvc;
qmake oci.pro
nmake

To copy to clipboard, switch view to plain text mode 

• ..\..\..\..\plugins\sqldrivers\qsqlocid4.dll : fatal error LNK1120: 29 unresolved externals
  NMAKE : fatal error U1077: '"c:\My Programs\Microsoft Visual Studio 9.0\VC\BIN\link.EXE"' : return c
  ode '0x460'
  Stop.
  NMAKE : fatal error U1077: '"c:\My Programs\Microsoft Visual Studio 9.0\VC\BIN\nmake.exe"' : return
  code '0x2'
  Stop.

I'm not sure what else I need to do. I have done everything in the documentation.
I also added c:\Oracle to PATH and still get the 29 unresolved externals problem.

I am using the Oracle Instant Client Basic (c:\Oracle) and Oracle Instant Client SDK (c:\Oracle\sdk)

I believe if I can get this resolved then I will be able to fix MySQL as well. Similar issues for both.

A foot in the right direction would be great.

Thanks.
-Blando

[Blando]

Marvelous.

SOLVED:

My problem was that I wasn't using the correct version and/or I had a version mismatch.

I deleted my entire c:\Oracle and started fresh.

I followed The Oracle God, Mark Williams, tutorial here.

I did exactly what he stated, using the older version 11.1.0.6.0

• Download Oracle Instant Client BASIC x32 11.1.0.6.0

• Download Oracle Instant Client SDK x32 11.1.0.6.0

• Download Oracle C++ Call Interface Visual C++ 9 (VS 2008) x32

I built his sample code to make sure everything was right. Once I was able to build successfully then I went to Qt.

Visual Studio Command Line
cd c:\Qt\4.6.2\src\plugins\sqldrivers\oci
set include=%include%c:\Oracle\sdk\include;
set lib=%lib%c:\Oracle\sdk\lib\msvc\vc9;
set path=%path%c:\Oracle\vc9; <--directory you will create from Mark Williams instructions posted above.
set path=%path%c:\Oracle;
qmake oci.pro
nmake

Error Free!!

Created sample Qt app to test.

#include "oci_test_app.h"
#include <QtGui/QApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QMessageBox>
 
bool createConnection()
{
	QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
	db.setHostName("test");
	db.setDatabaseName("test");
	db.setUserName("test");
	db.setPassword("test");
	if(!db.open())
	{
		QMessageBox::critical(0, QObject::tr("Database Error"), db.lastError().text());
		return false;
	}
 
}
int main(int argc, char *argv[])
{
	QApplication a(argc, argv);
	if(!createConnection())
		return 1;
	OCI_TEST_APP w;
	w.show();
	return a.exec();
}

#include "oci_test_app.h"
#include <QtGui/QApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QMessageBox>

bool createConnection()
{
	QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
	db.setHostName("test");
	db.setDatabaseName("test");
	db.setUserName("test");
	db.setPassword("test");
	if(!db.open())
	{
		QMessageBox::critical(0, QObject::tr("Database Error"), db.lastError().text());
		return false;
	}

}
int main(int argc, char *argv[])
{
	QApplication a(argc, argv);
	if(!createConnection())
		return 1;
	OCI_TEST_APP w;
	w.show();
	return a.exec();
}

To copy to clipboard, switch view to plain text mode 

No errors on build. Error free compilation.
Got the Oracle Error Message on run. <-- GOOD
Now we are set to go.

-Blando