View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04708 | Bug reports | Response browsing | public | 2010-10-30 15:19 | 2010-11-03 20:41 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.90+ | ||||
| Fixed in Version | 1.90+ | ||||
| Summary | 04708: 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 | ||||
| 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' : And it worked. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 9343 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Any | ||||
| Database type & version | SQL server 2005 | ||||
| Server OS (if known) | Windows server 2003 | ||||
| Webserver software & version (if known) | IIS6 | ||||
| PHP Version | 5.3.3 | ||||
| Git branch / Pull Request URL | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-10-30 15:19 |
|
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 |