View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
04708Bug reportsResponse browsingpublic2010-10-30 15:192010-11-03 20:41
Reporteruser1329Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90+ 
Fixed in Version1.90+ 
Summary04708: Error when wanting to browse responses of surveys - mssqlnative database driver missing
Description

Limesurvey with MSSQL using mssqlnative driver gives the error message:

"Couldn't create 'select tables like' query for connection type 'databaseType'"

This is because of a missing entry in the common.php file corresponding to the possible database types.

I noticed it while switching from the odbc_mssql adodb driver to the native mssql php driver provided by Microsoft.

Steps To Reproduce

1- perform the necessary steps to install the MSSQL PHP native driver from Microsoft
2- in config.php, enter mssqlnative as databasetype
3- Go to a survey and try to browse responses. The error message above will appear.

Additional Information

In order to solve it in my situation, I simply added the following lines at line 652 of the common.php file:

case 'mssqlnative' :
return "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE' and TABLE_NAME LIKE '$table'";

And it worked.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)9343
I will donate to the project if issue is resolvedNo
BrowserAny
Database type & versionSQL server 2005
Server OS (if known)Windows server 2003
Webserver software & version (if known)IIS6
PHP Version5.3.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2010-10-30 22:23

administrator   ~13380

Last edited: 2010-10-30 22:23

Thank you! Fixed in rev 9369
c_schmitz

c_schmitz

2010-11-03 20:41

administrator   ~13405

Fix was released in latest 1.90+ version.

Issue History

Date Modified Username Field Change
2010-10-30 15:19 user1329 New Issue
2010-10-30 22:21 c_schmitz Assigned To => c_schmitz
2010-10-30 22:21 c_schmitz Status new => assigned
2010-10-30 22:23 c_schmitz Note Added: 13380
2010-10-30 22:23 c_schmitz Status assigned => resolved
2010-10-30 22:23 c_schmitz Fixed in Version => 1.90+
2010-10-30 22:23 c_schmitz Resolution open => fixed
2010-10-30 22:23 c_schmitz Note Edited: 13380
2010-11-03 20:41 c_schmitz Note Added: 13405
2010-11-03 20:41 c_schmitz Status resolved => closed