Problema com registro MSSQL

TrojanHorse · Novembro 24, 2011

Olá boa noite a todos, estou utilizando um windows server 2003, com xampp 1.7.7 e SQLSERVER 2005 EXPRESS, possuo um servidor de game no mesmo, mas estou tendo problemas no arquivo register.php do meu site ele só está registrando no mysql e não no mssql preciso que registre nos 2 segue a baixo o register.php e os prints dos db MySQL e MSSQL.

MySQL

SQLSERVER

REGISTER.PHP

<?php include('inc/header.php'); ?>
<h1><?php echo $lang['h1_register']; ?></h1>
<?php
// Auf Fehler kontrollieren
$checkacc = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `username`=\''.mysql_real_escape_string($_POST['username']).'\'');
$checkmail = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `email`=\''.mysql_real_escape_string($_POST['email']).'\'');
$errors = array();
if($_POST['username'] == '' || $_POST['password'] == '' || $_POST['reppassword'] == '' || $_POST['email'] == '' || $_POST['day'] == '' || $_POST['month'] == '' || $_POST['year'] == '' || $_POST['captcha'] == '')
	$errors[] = $lang['register_error_fillin'];
if($_POST['username'] != '' && mysql_num_rows($checkacc) > 0)
	$errors[] = $lang['register_error_usernameexist'];
if($_POST['email'] != '' && mysql_num_rows($checkmail) > 0)
	$errors[] = $lang['register_error_emailexist'];
if(($_POST['password'] != '' && $_POST['reppassword'] != '') && $_POST['password'] != $_POST['reppassword'])
	$errors[] = $lang['register_error_password'];
if(($_POST['username'] != '') && (strlen($_POST['username']) > 10 || strlen($_POST['username']) < 4))
	$errors[] = $lang['register_error_userlength'];
if(($_POST['password'] != '') && (strlen($_POST['password']) > 11 || strlen($_POST['password']) < 6))
	$errors[] = $lang['register_error_passlength'];
if($_POST['email'] != '' && !preg_match('/^[a-zA-Z0-9-_.]+@[a-zA-Z0-9-_.]+\.[a-zA-Z]{2,4}$/', $_POST['email']))
	$errors[] = $lang['register_error_email'];
if(($_POST['day'] != '' && $_POST['year'] != '' && $_POST['month'] != '') && (strlen($_POST['day']) > 2 || strlen($_POST['year']) > 4 || strlen($_POST['year']) < 4))
	$errors[] = $lang['register_error_bday'];
if($_POST['captcha'] != '' && ($_SESSION['captcha'] != md5($_POST['captcha'])))
	$errors[] = $lang['register_error_captcha'];

// Buttonklick
if(isset($_POST['regsbm'])) {
	if(count($errors) > 0) {
		// Fehler ausgeben
		echo '<div class="fail">';
		foreach($errors as $error) {
			echo $error.'<br/>';
		}
		echo '</div>';
	} else {
		// Account erstellen
		// Insert into MSSQL
		@odbc_exec($mssql, 'USE [ACCOUNT_DBF] INSERT INTO [dbo].[ACCOUNT_TBL] (account, password, isuse, member, id_no1, id_no2, realname, reload, OldPassword, TempPassword, cash) VALUES (N\''.mssql_escape_string($_POST['username']).'\', N\''.mssql_escape_string(md5($_CONFIG['pwdsalt'].$_POST['password'])).'\', N\'T\', N\'A\', NULL, 0, N\'P\', NULL, 0, NULL, 0)');
		@odbc_exec($mssql, 'INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse, secession, email) VALUES (N\''.mssql_escape_string($_POST['username']).'\', N\'A000\', N\'2\', N\'F\', \'20080818 00:51:35.700\', N\'20010101\', N\'20990101\', N\'20050101\', N\'O\', NULL, NULL)');
		// Insert into MySQL
		// Website
		mysql_query('INSERT INTO `'.TABLE_PREFIX.'users`(username, password, email, birthday, regdate) VALUES(\''.mysql_real_escape_string($_POST['username']).'\', \''.mysql_real_escape_string(md5($_POST['password'])).'\', \''.mysql_real_escape_string($_POST['email']).'\', \''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\', \''.date('Y-m-d H:i:s').'\')');
		// Ticket System
		mysql_query('INSERT INTO `'.TS_TABLE_PREFIX.'user`(username, password, email, birthday) VALUES(
\''.mysql_real_escape_string($_POST['username']).'\',
\''.md5(mysql_real_escape_string($_POST['password'])).'\',
\''.mysql_real_escape_string($_POST['email']).'\',
\''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\')');
		echo '<div class="success">'.$lang['register_success'].'</div>';
	}
}
?>
<form action="" method="post">
<table>
   	<tr>
       	<td><?php echo $lang['register_username']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_username']; ?>" rel="tooltip"><input type="text" name="username" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_password']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_password']; ?>" rel="tooltip"><input type="password" name="password" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_reppassword']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_reppassword']; ?>" rel="tooltip"><input type="password" name="reppassword" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_email']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_email']; ?>" rel="tooltip"><input type="text" name="email" /></a></td>
       </tr>
   	<tr>
       	<td style="vertical-align: top;"><?php echo $lang['register_bday']; ?>:</td>
           <td>
           	<a title="<?php echo $lang['tooltip_register_day']; ?>" rel="tooltip"><input type="text" name="day" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a>
               <a title="<?php echo $lang['tooltip_register_month']; ?>" rel="tooltip"><select name="month" style="width: 130px;">
               	<option value="1"><?php echo $lang['month_jan']; ?></option>
               	<option value="2"><?php echo $lang['month_feb']; ?></option>
               	<option value="3"><?php echo $lang['month_mar']; ?></option>
               	<option value="4"><?php echo $lang['month_apr']; ?></option>
               	<option value="5"><?php echo $lang['month_may']; ?></option>
               	<option value="6"><?php echo $lang['month_jun']; ?></option>
               	<option value="7"><?php echo $lang['month_jul']; ?></option>
               	<option value="8"><?php echo $lang['month_aug']; ?></option>
               	<option value="9"><?php echo $lang['month_sep']; ?></option>
               	<option value="10"><?php echo $lang['month_oct']; ?></option>
               	<option value="11"><?php echo $lang['month_nov']; ?></option>
               	<option value="12"><?php echo $lang['month_dec']; ?></option>
               </select></a>
               <a title="<?php echo $lang['tooltip_register_year']; ?>" rel="tooltip"><input type="text" name="year" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a><br/>
               <?php echo $lang['register_bday_eg']; ?>
           </td>
       </tr>
   	<tr>
       	<td><img src="inc/captcha.php" /></td>
           <td><a title="<?php echo $lang['tooltip_register_captcha']; ?>" rel="tooltip"><input type="text" name="captcha" size="5" /></a></td>
       </tr>
   	<tr>
       	<td></td>
           <td><input type="submit" name="regsbm" value="<?php echo $lang['input_register']; ?>" /></td>
       </tr>
   </table>
</form>
<br style="clear: both;" />
<?php include('inc/footer.php'); ?>

_____________________________________________________________________________________________

Aguardo resposta obrigado.

advaldomesquita · Novembro 24, 2011

Como você esta se conectando no SQLServer? Qual eh o servidor principal? Como que esta declarada a variavel @odbc_exec ????

TrojanHorse · Novembro 24, 2011

A.Jr blza, acho que resolvi um dos problemas RETIREI O @ DOS @odbc agora está aparecendo o seguinte erro sou muito iniciante em sql >>>>>>

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver]

Nome de coluna 'OldPassword' invalido., SQL state S0022 in SQLExecDirect in C:\xampp\htdocs\register.php on line 39

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][sql Server]Nome de objeto 'dbo.ACCOUNT_TBL_DETAIL' invalido., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\register.php on line 40 >>>> APARECE ISSO QUANDO FAZ CADASTRO.

advaldomesquita · Novembro 24, 2011

Como você esta se conectando no SQLServer?

coloque o 'USE [ACCOUNT_DBF]' nos dois inserts....

TrojanHorse · Novembro 24, 2011

Com usuário 'sa' e senha, tirei não deu certo ele não joga no db mssql =( o que devo fazer?

TrojanHorse · Novembro 24, 2011

Esse é o Register.php que meu amigo editou.

<?php include('inc/header.php'); ?>
<h1><?php echo $lang['h1_register']; ?></h1>
<?php
// Auf Fehler kontrollieren
$checkacc = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `username`=\''.mysql_real_escape_string($_POST['username']).'\'');
$checkmail = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `email`=\''.mysql_real_escape_string($_POST['email']).'\'');
$errors = array();
if($_POST['username'] == '' || $_POST['password'] == '' || $_POST['reppassword'] == '' || $_POST['email'] == '' || $_POST['day'] == '' || $_POST['month'] == '' || $_POST['year'] == '' || $_POST['captcha'] == '')
	$errors[] = $lang['register_error_fillin'];
if($_POST['username'] != '' && mysql_num_rows($checkacc) > 0)
	$errors[] = $lang['register_error_usernameexist'];
if($_POST['email'] != '' && mysql_num_rows($checkmail) > 0)
	$errors[] = $lang['register_error_emailexist'];
if(($_POST['password'] != '' && $_POST['reppassword'] != '') && $_POST['password'] != $_POST['reppassword'])
	$errors[] = $lang['register_error_password'];
if(($_POST['username'] != '') && (strlen($_POST['username']) > 10 || strlen($_POST['username']) < 4))
	$errors[] = $lang['register_error_userlength'];
if(($_POST['password'] != '') && (strlen($_POST['password']) > 11 || strlen($_POST['password']) < 6))
	$errors[] = $lang['register_error_passlength'];
if($_POST['email'] != '' && !preg_match('/^[a-zA-Z0-9-_.]+@[a-zA-Z0-9-_.]+\.[a-zA-Z]{2,4}$/', $_POST['email']))
	$errors[] = $lang['register_error_email'];
if(($_POST['day'] != '' && $_POST['year'] != '' && $_POST['month'] != '') && (strlen($_POST['day']) > 2 || strlen($_POST['year']) > 4 || strlen($_POST['year']) < 4))
	$errors[] = $lang['register_error_bday'];
if($_POST['captcha'] != '' && ($_SESSION['captcha'] != md5($_POST['captcha'])))
	$errors[] = $lang['register_error_captcha'];

// Buttonklick
if(isset($_POST['regsbm'])) {
	if(count($errors) > 0) {
		// Fehler ausgeben
		echo '<div class="fail">';
		foreach($errors as $error) {
			echo $error.'<br/>';
		}
		echo '</div>';
	} else {
		// Account erstellen
		//try to connect in mssql server wttout ODBC connection
		$con_mssql = mssql_connect('KPFI2RZHGUVMSS4\SQLEXPRESS','sa','XXXXXXXX');
		mssql_select_db('ACCOUNT_DBF');
		// Insert into MSSQL
		$pusername = @$_POST['username']; //Post wsername
$ppassword = @$_POST['password']; //Post password
$username = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $pusername);
$password = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $ppassword);
$hash = "serus";
$pass = md5($hash . $password);
mssql_query("INSERT INTO ACCOUNT_TBL (account, password) VALUES ('$username', '$pass');");
		// Insert into MySQL
		// Website
		mysql_query('INSERT INTO `'.TABLE_PREFIX.'users`(username, password, email, birthday, regdate) VALUES(\''.mysql_real_escape_string($_POST['username']).'\', \''.mysql_real_escape_string(md5($_POST['password'])).'\', \''.mysql_real_escape_string($_POST['email']).'\', \''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\', \''.date('Y-m-d H:i:s').'\')');
		// Ticket System
		mysql_query('INSERT INTO `'.TS_TABLE_PREFIX.'user`(username, password, email, birthday) VALUES(
\''.mysql_real_escape_string($_POST['username']).'\',
\''.md5(mysql_real_escape_string($_POST['password'])).'\',
\''.mysql_real_escape_string($_POST['email']).'\',
\''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\')');
		echo '<div class="success">'.$lang['register_success'].'</div>';
	}
}
?>
<form action="" method="post">
<table>
   	<tr>
       	<td><?php echo $lang['register_username']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_username']; ?>" rel="tooltip"><input type="text" name="username" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_password']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_password']; ?>" rel="tooltip"><input type="password" name="password" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_reppassword']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_reppassword']; ?>" rel="tooltip"><input type="password" name="reppassword" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_email']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_email']; ?>" rel="tooltip"><input type="text" name="email" /></a></td>
       </tr>
   	<tr>
       	<td style="vertical-align: top;"><?php echo $lang['register_bday']; ?>:</td>
           <td>
           	<a title="<?php echo $lang['tooltip_register_day']; ?>" rel="tooltip"><input type="text" name="day" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a>
               <a title="<?php echo $lang['tooltip_register_month']; ?>" rel="tooltip"><select name="month" style="width: 130px;">
               	<option value="1"><?php echo $lang['month_jan']; ?></option>
               	<option value="2"><?php echo $lang['month_feb']; ?></option>
               	<option value="3"><?php echo $lang['month_mar']; ?></option>
               	<option value="4"><?php echo $lang['month_apr']; ?></option>
               	<option value="5"><?php echo $lang['month_may']; ?></option>
               	<option value="6"><?php echo $lang['month_jun']; ?></option>
               	<option value="7"><?php echo $lang['month_jul']; ?></option>
               	<option value="8"><?php echo $lang['month_aug']; ?></option>
               	<option value="9"><?php echo $lang['month_sep']; ?></option>
               	<option value="10"><?php echo $lang['month_oct']; ?></option>
               	<option value="11"><?php echo $lang['month_nov']; ?></option>
               	<option value="12"><?php echo $lang['month_dec']; ?></option>
               </select></a>
               <a title="<?php echo $lang['tooltip_register_year']; ?>" rel="tooltip"><input type="text" name="year" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a><br/>
               <?php echo $lang['register_bday_eg']; ?>
           </td>
       </tr>
   	<tr>
       	<td><img src="inc/captcha.php" /></td>
           <td><a title="<?php echo $lang['tooltip_register_captcha']; ?>" rel="tooltip"><input type="text" name="captcha" size="5" /></a></td>
       </tr>
   	<tr>
       	<td></td>
           <td><input type="submit" name="regsbm" value="<?php echo $lang['input_register']; ?>" /></td>
       </tr>
   </table>
</form>
<br style="clear: both;" />
<?php include('inc/footer.php'); ?>

Esse é o Register.php que meu amigo editou.

<?php include('inc/header.php'); ?>
<h1><?php echo $lang['h1_register']; ?></h1>
<?php
// Auf Fehler kontrollieren
$checkacc = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `username`=\''.mysql_real_escape_string($_POST['username']).'\'');
$checkmail = mysql_query('SELECT * FROM `'.TABLE_PREFIX.'users` WHERE `email`=\''.mysql_real_escape_string($_POST['email']).'\'');
$errors = array();
if($_POST['username'] == '' || $_POST['password'] == '' || $_POST['reppassword'] == '' || $_POST['email'] == '' || $_POST['day'] == '' || $_POST['month'] == '' || $_POST['year'] == '' || $_POST['captcha'] == '')
	$errors[] = $lang['register_error_fillin'];
if($_POST['username'] != '' && mysql_num_rows($checkacc) > 0)
	$errors[] = $lang['register_error_usernameexist'];
if($_POST['email'] != '' && mysql_num_rows($checkmail) > 0)
	$errors[] = $lang['register_error_emailexist'];
if(($_POST['password'] != '' && $_POST['reppassword'] != '') && $_POST['password'] != $_POST['reppassword'])
	$errors[] = $lang['register_error_password'];
if(($_POST['username'] != '') && (strlen($_POST['username']) > 10 || strlen($_POST['username']) < 4))
	$errors[] = $lang['register_error_userlength'];
if(($_POST['password'] != '') && (strlen($_POST['password']) > 11 || strlen($_POST['password']) < 6))
	$errors[] = $lang['register_error_passlength'];
if($_POST['email'] != '' && !preg_match('/^[a-zA-Z0-9-_.]+@[a-zA-Z0-9-_.]+\.[a-zA-Z]{2,4}$/', $_POST['email']))
	$errors[] = $lang['register_error_email'];
if(($_POST['day'] != '' && $_POST['year'] != '' && $_POST['month'] != '') && (strlen($_POST['day']) > 2 || strlen($_POST['year']) > 4 || strlen($_POST['year']) < 4))
	$errors[] = $lang['register_error_bday'];
if($_POST['captcha'] != '' && ($_SESSION['captcha'] != md5($_POST['captcha'])))
	$errors[] = $lang['register_error_captcha'];

// Buttonklick
if(isset($_POST['regsbm'])) {
	if(count($errors) > 0) {
		// Fehler ausgeben
		echo '<div class="fail">';
		foreach($errors as $error) {
			echo $error.'<br/>';
		}
		echo '</div>';
	} else {
		// Account erstellen
		//try to connect in mssql server wttout ODBC connection
		$con_mssql = mssql_connect('KPFI2RZHGUVMSS4\SQLEXPRESS','sa','XXXXXXXX');
		mssql_select_db('ACCOUNT_DBF');
		// Insert into MSSQL
		$pusername = @$_POST['username']; //Post wsername
$ppassword = @$_POST['password']; //Post password
$username = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $pusername);
$password = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $ppassword);
$hash = "serus";
$pass = md5($hash . $password);
mssql_query("INSERT INTO ACCOUNT_TBL (account, password) VALUES ('$username', '$pass');");
		// Insert into MySQL
		// Website
		mysql_query('INSERT INTO `'.TABLE_PREFIX.'users`(username, password, email, birthday, regdate) VALUES(\''.mysql_real_escape_string($_POST['username']).'\', \''.mysql_real_escape_string(md5($_POST['password'])).'\', \''.mysql_real_escape_string($_POST['email']).'\', \''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\', \''.date('Y-m-d H:i:s').'\')');
		// Ticket System
		mysql_query('INSERT INTO `'.TS_TABLE_PREFIX.'user`(username, password, email, birthday) VALUES(
\''.mysql_real_escape_string($_POST['username']).'\',
\''.md5(mysql_real_escape_string($_POST['password'])).'\',
\''.mysql_real_escape_string($_POST['email']).'\',
\''.mysql_real_escape_string($_POST['year']).'-'.mysql_real_escape_string($_POST['month']).'-'.mysql_real_escape_string($_POST['day']).'\')');
		echo '<div class="success">'.$lang['register_success'].'</div>';
	}
}
?>
<form action="" method="post">
<table>
   	<tr>
       	<td><?php echo $lang['register_username']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_username']; ?>" rel="tooltip"><input type="text" name="username" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_password']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_password']; ?>" rel="tooltip"><input type="password" name="password" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_reppassword']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_reppassword']; ?>" rel="tooltip"><input type="password" name="reppassword" /></a></td>
       </tr>
   	<tr>
       	<td><?php echo $lang['register_email']; ?>:</td>
           <td><a title="<?php echo $lang['tooltip_register_email']; ?>" rel="tooltip"><input type="text" name="email" /></a></td>
       </tr>
   	<tr>
       	<td style="vertical-align: top;"><?php echo $lang['register_bday']; ?>:</td>
           <td>
           	<a title="<?php echo $lang['tooltip_register_day']; ?>" rel="tooltip"><input type="text" name="day" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a>
               <a title="<?php echo $lang['tooltip_register_month']; ?>" rel="tooltip"><select name="month" style="width: 130px;">
               	<option value="1"><?php echo $lang['month_jan']; ?></option>
               	<option value="2"><?php echo $lang['month_feb']; ?></option>
               	<option value="3"><?php echo $lang['month_mar']; ?></option>
               	<option value="4"><?php echo $lang['month_apr']; ?></option>
               	<option value="5"><?php echo $lang['month_may']; ?></option>
               	<option value="6"><?php echo $lang['month_jun']; ?></option>
               	<option value="7"><?php echo $lang['month_jul']; ?></option>
               	<option value="8"><?php echo $lang['month_aug']; ?></option>
               	<option value="9"><?php echo $lang['month_sep']; ?></option>
               	<option value="10"><?php echo $lang['month_oct']; ?></option>
               	<option value="11"><?php echo $lang['month_nov']; ?></option>
               	<option value="12"><?php echo $lang['month_dec']; ?></option>
               </select></a>
               <a title="<?php echo $lang['tooltip_register_year']; ?>" rel="tooltip"><input type="text" name="year" style="background: url('img/input_txtsmall.png'); width: 28px;" /></a><br/>
               <?php echo $lang['register_bday_eg']; ?>
           </td>
       </tr>
   	<tr>
       	<td><img src="inc/captcha.php" /></td>
           <td><a title="<?php echo $lang['tooltip_register_captcha']; ?>" rel="tooltip"><input type="text" name="captcha" size="5" /></a></td>
       </tr>
   	<tr>
       	<td></td>
           <td><input type="submit" name="regsbm" value="<?php echo $lang['input_register']; ?>" /></td>
       </tr>
   </table>
</form>
<br style="clear: both;" />
<?php include('inc/footer.php'); ?>

advaldomesquita · Novembro 24, 2011

No gtalk com o user, executei alguns testes basicos no DB, como select nas bases e fui ver com o profiler o momento do insert.

Mas (sempre tem o mas), o SQLExpress não possui Profier.

Existe um software free que faz isso nas versoes express:

http://sqlprofiler.googlepages.com/

PAra quem quiser experimentar é uma ótima.

Vou detalhar mais desta ferramenta esta semana em meu blog.

Abçs

Entrar

Arquivado

Problema com registro MSSQL

Recommended Posts

TrojanHorse 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

advaldomesquita 93

Compartilhar este post

Link para o post

Compartilhar em outros sites

TrojanHorse 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

advaldomesquita 93

Compartilhar este post

Link para o post

Compartilhar em outros sites

TrojanHorse 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

TrojanHorse 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

advaldomesquita 93

Compartilhar este post

Link para o post

Compartilhar em outros sites

Consulta sem duplicação

Modelagem para questionário

Converter jpg para webp

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante