Categories > TinyButStrong general >

mssql conection

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Rromulo
Date: 2008-01-07
Time: 18:26

mssql conection

TinyButStrong Error when merging block [blk1] : Data source Id 'mssql link' is unsupported because function 'tbsdb_mssql_open' is not found.


index.php
<?php
include_once('tbs_class_php5.php') ;

$cnx_mssql_id = mssql_connect ('usuariosql.br', 'usuariosql', 'usuariosql') or die('Could Not Connect to ODBC

Database!') ;

mssql_select_db('usuariosql',$cnx_mssql_id) ;


$TBS = new clsTinyButStrong ;

$TBS->LoadTemplate('index.html') ;

$TBS->MergeBlock('blk1',$cnx_mssql_id,'SELECT * FROM seg_modulo') ;


mssql_close($cnx_mssql_id) ;

$TBS->Show() ;
?>

index.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<body>

<table border="1" align="center" cellpadding="2" cellspacing="0">
  <tr bgcolor="#CACACA">
    <td width="150"><strong>Mod_Codigo</strong></td>
    <td width="150"><strong>Mod_Descricao</strong></td>
  </tr>
  <tr bgcolor="#F0F0F0">
    <td>[blk1.Mod_Codigo;block=tr]</td>
    <td>[blk1.Mod_Descricao]</td>
  </tr>
  <tr bgcolor="#E6E6E6">
    <td>[blk1.Mod_Codigo;block=tr]</td>
    <td>[blk1.Mod_Descricao]</td>
  </tr>
  <tr bgcolor="#E6E6E6">
    <td colspan="4" bgcolor="#FFCFB9">[blk1;block=tr;nodata]There is no data. </td>
  </tr>
</table>
<p align="center">There are [blk1.#] displayed lines.</p>
</body>
</html>
By: TomH
Date: 2008-01-07
Time: 18:49

Re: mssql conection

Hi

The error message implies (to me at least) that the database plugin for MS SQL has not yet been loaded.

From your code, you seem to not have it installed yet

(1) download from http://www.tinybutstrong.com/plugins.php see SQL-Server
(2) include after loading TBS
include_once('tbs_class_php5.php');
include_once('tbsdb_mssql.php');

Hope that helps,
TomH