Native SQL Driver From Windows Conquest -> Linux MySQL DB

Hello

Can the native sqldriver be used to talk with a MySQL database on a different server ?

i.e Conquest server on Windows, with MySQL database on a Linux server. I have this setup using MySQL ODBC, but cannot see how to use native sqldriver of Conquest in this instance.

Louis

I do recall these settings but was under the impression that SQLHOST is not used. Anyway will try pointing SQLHOST to the IP of my Linux server, and see if can get it going!

I have done a clean install of Conquest and use the Create MYSQL database option of conquest so that the necessary settings are added in dicom.ini. I then manually edited the dicom.ini and updated the following :

SQLHost = IP of Linux server
SQLServer = name of database on Linux server
Username = username given access on Linux server
Password = set accordingly

I also changed the path of the data directory to point to where I have the images stored for the Linux setups, and saved configuration.

The two below were left
MySql = 1
DoubleBackSlashToDB = 1

I re-started server with no issues. However when I head on to the Browse Database tab, I get this error

Quote

There was a problem loading libmysql.dll - mysql not functional

Louis

OK. Will wait for the fix in next release.

Louis

PS. Nice to meet face to face at RADAim, Gold Coast.

I successfully did a regen moving from ODBC to native MySQL for database on Linux server. However for one server when trying to add records, I get this error

Quote

13/08/2008 9:40:38 AM [CRGHPACSMR] ***Failed SQLExecDirect : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, EchoNumber, AcqDate, AcqTime, ReceivingC, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, PatientNam, PatientBir, PatientSex, StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, FrameOfRef, Manufactur, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.46.670589.11.17012.5.0.4548.2008072111564068891', '1.2.840.10008.5.1.4.1.1.4', '1', '20080721', '115413.82', '1', '20080721', '115413.82', 'SENSE-Flex-M', '3', '0', '1', 'MONOCHROME2', '880', '880', '12', 'ORIGINAL\\PRIMARY\\M_SE\\M\\SE', '100205', 'THOMPSON John', '19361211', 'M', '1.3.46.670589.11.17012.5.0.5896.2008072111285726418', '20080721', '115148', '269868537', 'LEFT SHOULDER', '301', '20080721', '115413.82000', 'AX T2 SPAIR CLEAR', 'MR', '1.3.46.670589.11.17012.5.0.3868.2008072111514450007', 'Philips Medical Systems', '1.3.46.67058
13/08/2008 9:40:38 AM [CRGHPACSMR] ***Error: 1054: S0022: [MySQL][ODBC 3.51 Driver][mysqld-4.1.20]Unknown column 'PatientNam' in 'field list'
13/08/2008 9:40:38 AM [CRGHPACSMR] ***Unable to DB.Add()
13/08/2008 9:40:38 AM [CRGHPACSMR] ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, EchoNumber, AcqDate, AcqTime, ReceivingC, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, PatientNam, PatientBir, PatientSex, StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, FrameOfRef, Manufactur, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.3.46.670589.11.17012.5.0.4548.2008072111564068891', '1.2.840.10008.5.1.4.1.1.4', '1', '20080721', '115413.82', '1', '20080721', '115413.82', 'SENSE-Flex-M', '3', '0', '1', 'MONOCHROME2', '880', '880', '12', 'ORIGINAL\\PRIMARY\\M_SE\\M\\SE', '100205', 'THOMPSON John', '19361211', 'M', '1.3.46.670589.11.17012.5.0.5896.2008072111285726418', '20080721', '115148', '269868537', 'LEFT SHOULDER', '301', '20080721', '115413.82000', 'AX T2 SPAIR CLEAR', 'MR', '1.3.46.670589.11.17012.5.0.3868.2008072111514450007', 'Philips Medical Systems', '1.3.46.67058
13/08/2008 9:40:38 AM [CRGHPACSMR] ***Error: 1054: S0022: [MySQL][ODBC 3.51 Driver][mysqld-4.1.20]Unknown column 'PatientNam' in 'field list'
13/08/2008 9:40:38 AM [CRGHPACSMR] ***Error saving to SQL: 100205\1.3.46.670589.11.17012.5.0.4548.2008072111541384886_0301_000001_12185844387879.v2

Display More

I cannot see at this stage why it's trying to use MySQL ODBC instead of the native sql one.

Yes it is set to 1.

Hi

I found out my issue why I get this message libmysql not functional from the Browse Database tab.

When I click on "make mysql database", I specified a database name say "conquestbeta" and the root password, and save.

I get this error each time I go in the Browse database.

In the dicom.ini file although I specified "conquestbeta" I still this

SQLServer = conquest

instead. Trying to talk to a database that is not there.

I have done few conquest installs recently on the latest beta version, and I keep seeing this issue in dicom.ini file when installing with Native Mysql driver.

The problem is rectified when I manually change SQLSERVER = conquestbeta, and restart server.

This appears a bug.