Jump to content
Fórum Script Brasil

ToPronto N'Area

Membros
  • Posts

    106
  • Joined

  • Last visited

About ToPronto N'Area

  • Birthday 05/26/1980

Contatos

Perfil

  • Gender
    Male
  • Location
    Campo Grande Ms

ToPronto N'Area's Achievements

0

Reputation

  1. Sim foi pelo designer, voce acredita que eu fazendo as divs pelo css, ela irá parar de piscar e de ficar desconfigurada no IE? Bom eu fiz a divs utilizando o tamanho do monitor, é melhor fixar o tamanho então, ou tem como fazer ela buscar o tamanho do monitor pelo css também? De klker forma muito obrigado, vou tentar hj novamente. Até mais.
  2. Olá pessoal sou novo em web, fiz um site www.rosadodesertobrasil.com.br e estou com dois problemas, um ele no google aparece muito bem, ta bonito o site, porem no internet explorer fica tudo desconfigurado, o outro problema é quanto a ficar piscando o site como se estivesse apertando o f5. ele faz isso de tempos em tempos, já verifiquei o css pra ver se tinha algo aberto mas não tem. O que poderá ser, alguém sabe a solução, desde já agradeço a todos. Até mais.
  3. kuroi, show de bola veja como ficou o relatorio https://docs.google.com/leaf?id=0B7BOn1qqQK...Uz&hl=pt_BR Olha só, sem querer abusar, mas o que você fez ali? prq não entendi é um tipo de formatação que pode ser feito dentro do sql? cara de klker forma muito obrigado pela ajuda. Valeu
  4. E ai pessoal, to com uma duvida bruta. Eu estou trabalhando em um relatorio de analise financeira, onde o programa irá buscar da tabela "Pagar" os campos subsetor, setor, valorpago, datapgto, situaçao o sql ficou este: With FrmComp sql = "select pagar.subsetor,sum(pagar.valorpago) as vlrpago, pagar.datapgto, setor.setor, setor.CODIGO from pagar inner join setor on pagar.setor = setor.codigo " sql = sql & "WHERE DATAPGTO >= #" & Format(.Ctxt(0).Text, "mm/dd/yyyy") & "# " sql = sql & "AND DATAPGTO <= #" & Format(.Ctxt(1).Text, "mm/dd/yyyy") & "#" sql = sql & "and SITUAÇAO LIKE '" & "Pag" & "' " End With sql = sql & " group by pagar.subsetor, setor.setor, SETOR.CODIGO, pagar.datapgto " sql = sql & " ORDER BY pagar.datapgto, pagar.subsetor" Até ai ele funciona perfeitamente se eu colocar nos ctxt um periodo mensal referente a um mes somente por ex. .ctxt(0).text = 01/03/2011 e .ctxt(1).text = 31/03/2011 Porem apartir do momento que eu coloque um periodo anual q é a verdadeira funcionalidade do relatorios pra fazer balanço anual, ai ele não traz o programa da forma correta. Ele me traz os subsetores um a um vou subir a imagem do relatorio para vocês verem. O certo é o que faz o select de um unico mes RelCertoMes03.jpeg - https://docs.google.com/leaf?id=0B7BOn1qqQK...I2&hl=pt_BR o errado é o que faz o select de varios meses RelErradomes 01 ao 03.jpeg - https://docs.google.com/leaf?id=0B7BOn1qqQK...Jk&hl=pt_BR Bom desde já agradeço a ajuda de todos, valeu pessoal os links são do google docs.
  5. Kuroi, to tentando, mas se eu coloco assim Cnn.Execute "ALTER TABLE [" & "produto" & "] alter COLUMN [" & "valorcompra" & "] double " Ele cria altera o campo pra duplo e deixa com duas casas decimais, se coloco double (10, 4) ele ta erro na expressão alter table. Sabe me dizer como escrevo pra ele mudar as casas? Desde já agradeço a ajuda.. valeu
  6. E ai moçada, olha só cnn.Execute "ALTER TABLE [" & "PEDIDO" & "] ADD COLUMN [" & "PGTOPARCIAL" & "] CURRENCY" eu sei q com esta linha de código eu crio um campo currency, e também q se trocar o currency por decimal (10, 4) eu crio um campo com precisao 10 e escala 4, isso no access, agora eu preciso saber como altero uma tabela minha no access para 5 casas decimais, tem alguma forma especifica? desde já agradeço a força! Até mais...
  7. Seguinte pessoal vou tentar explicar a questão. Seguinte um cliente me pediu pra pegar as informações de um programa em delphi, (Eu trabalho com vb e access as vezes sql), fui ver a criança! Ai q começou meus problemas. Bom o programa chama-se Siconv e funciona normalmente, ai fui la na pasta do progama e to procurando o bd e nada de achar, ai fui ver q ele tinha o oracle instalado na maquina, bingo já tinha ouvido falar neste fabuloso gerenciado de bd, beleza agora é só abrir achar o bd e exportar né! Não enfim não sabia nem abrir este bd, mas fuçando achei a home page para abrir o gerenciado do bd, beleza entrei digitei o usuario e a senha SYSTEM - MANAGER e acessei normalmente, até ai beleza, achei as tabelas vi onde elas ficam alocadas no pc. até ai beleza, peguei as tabelas a q me interessava chamava-se users.dbf e fui importar a bendita, porem quando tento abrir ela ou importar ela no access ela da uma mensagem "A tabela externa não está no formato esperado" ai trava nisto. até ai tudo bem ai continuei fuçando e achei o borland delphi instalado na maquina, entrei nele e la tinha sql explorer entrei e achei o bd do sistema "Siconv" este o nome do bd, pra entrar nele tinha de digita a senha, ai ele vem com o usuario SICONV e pede a senha, digitei todas as senhas possiveis q tinha pra este usuario, enfim dava uma mensagem de logon não podia ser feito, (depois eu fui descobrir q isso era prq este usuario estava bloqueado no gerenciador do oracle.) mas com a senha system e manager eu entro e acesso as tabelas faço pesquisas sql e tudo mais. porem não consegui achar uma forma de exportar = tem o sql 2005, ai voltei no oracle e achei uma parte q gerenciava os usuarios, ai decidi trocar a senha do usuario SICONV, pensei q de posse da senha dele poderia exportar, p**** nenhuma, me ferrei prq troquei a senha do siconv e o siconv é o usuario q o programa usava pra abrir o sistema, enfim agora nem o primeiro programa abre. me ferrei geral agora. Enfim o q eu preciso fazer agora é descobrir como me concectar há esta tabela atraves do vb pra fazer um laço pra exportar os dados para o access, e preciso ver se alguém ai sabe como trocar o sql.txt pra ele buscar o usuario siconv e a senha nova q eu digitei? vou postar o arquivo aqui abaixo... Desde já eu agradeço a ajuda de todos Eu acredito que seje este sql.txt q esteja armazenada a string de conexão. *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CARTAO)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE-38NGV55S1)(USER=Saude?Assessoria)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 17-NOV-2006 14:20:18 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:erro de adaptador de protocolo ns secondary err code: 0 nt main err code: 530 TNS-00530: Erro do adaptador de protocolo nt secondary err code: 50 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CARTAO)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE-38NGV55S1)(USER=Saude?Assessoria)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 17-NOV-2006 14:20:52 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:erro de adaptador de protocolo ns secondary err code: 0 nt main err code: 530 TNS-00530: Erro do adaptador de protocolo nt secondary err code: 50 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CARTAO)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE-38NGV55S1)(USER=Saude?Assessoria)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 17-NOV-2006 14:21:13 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:erro de adaptador de protocolo ns secondary err code: 0 nt main err code: 530 TNS-00530: Erro do adaptador de protocolo nt secondary err code: 50 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CARTAO)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE-38NGV55S1)(USER=Administrador)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 14-ABR-2007 21:02:51 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:erro de adaptador de protocolo ns secondary err code: 0 nt main err code: 530 TNS-00530: Erro do adaptador de protocolo nt secondary err code: 38 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 15-JAN-2008 14:08:25 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 15-JAN-2008 14:09:03 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 15-JAN-2008 14:11:06 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 15-JAN-2008 14:11:18 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 22-JAN-2008 13:50:32 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 31-JAN-2008 15:26:53 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 08-FEV-2008 14:13:52 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 19-FEV-2008 14:48:07 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 20-FEV-2008 14:36:46 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 20-FEV-2008 16:40:22 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 21-FEV-2008 15:21:11 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 22-FEV-2008 14:06:21 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 22-FEV-2008 16:29:56 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 25-FEV-2008 15:41:09 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 29-FEV-2008 12:23:49 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 04-MAR-2008 14:03:48 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 05-MAR-2008 16:31:28 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 06-MAR-2008 13:45:16 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 13-MAR-2008 13:58:44 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 14-MAR-2008 14:10:50 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 14-MAR-2008 14:21:30 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 17-MAR-2008 15:08:38 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 18-MAR-2008 15:37:42 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 19-MAR-2008 14:23:52 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 31-MAR-2008 15:44:06 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 31-MAR-2008 15:44:23 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 01-ABR-2008 14:54:27 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 02-ABR-2008 16:19:59 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 03-ABR-2008 15:03:47 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 07-ABR-2008 14:49:06 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 08-ABR-2008 15:35:47 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 09-ABR-2008 14:18:09 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 15-ABR-2008 13:56:24 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 24-ABR-2008 09:37:45 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 29-ABR-2008 14:37:15 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 30-ABR-2008 14:50:10 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 06-MAI-2008 15:52:37 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 30-MAI-2008 14:43:10 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 10-JUN-2008 14:27:49 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 25-JUN-2008 14:34:38 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 04-JUL-2008 14:05:09 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 10-JUL-2008 15:06:00 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 19-AGO-2008 16:51:29 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 25-AGO-2008 10:17:52 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 27-AGO-2008 10:09:42 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 03-SET-2008 14:35:14 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 20-NOV-2008 08:41:48 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 11-DEZ-2008 15:57:07 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 02-FEV-2009 13:53:40 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 04-AGO-2009 15:48:35 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:não há listener ns secondary err code: 12560 nt main err code: 511 TNS-00511: Não há listener nt secondary err code: 61 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12528, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=saude)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Siconv\Siconv.exe)(HOST=SAUDE)(USER=CARTAO)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 10-SET-2009 11:06:06 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:conexão recusada ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0
  8. cara prq tu não bloqueia o q não pode ser digitado Function Socodigo(Key As Integer) As String 'selecione os caracteres que desejar Const Números$ = "0" 'especifique aqui a letra q não vai poder digitar Socodigo = Key If Key <> 8 Then 'conferindo se é backspace 'vê se é um caracter permitido If InStr(Números$, Chr(Key)) = 0 Then Socodigo = 0 End If End If End Function depois no evento do keypress tu chama ele desta forma KeyAscii = sóNÚmeros(KeyAscii)
  9. Boa dica dr. Mas no caso vou tentar logar conectar com o vb para fazer o laço. Bom valeu pela ideia.
  10. E ai pessoal é o seguinte, eu não programo em delphi, programo em vb, mas um cliente me pediu pra acessar um sistema em delphi e pegar os dados para jogar no meu programa, e quem fez este programa em delphi sumiu no mundo, enfim sobrou pra mim! rsrsrs Então é o seguinte, já consegui descobrir a senha do bd e até consigo acessar ele na seguinte tela borland delphi 7 - sql explorer digito o usuario e a senha e beleza acesso já achei a tabela q eu quero, porem quando entro em dictionary e vou em "export to file", esta opção esta desabilitada. A pergunta é como faço pra exportar esta tabela? Ou como q eu faço pra habilitar esta opção? Tem outra forma de exportar esta tabela? Se alguém puder me ajudar desde já eu agradeço. Valeu
  11. Valeu dr, era isto mesmo, eu estava colocando entre parenteses. Obrigado
  12. Olá pessoal, seguinte eu tenho o seguinte código Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) On Error GoTo TRATAERRO Select Case KeyCode Case Is = 113 'vbKeyF2 'abrir ficha If Left(LblTit(7).Caption, 9) = "F2 - NOVO" Then cnn.Execute "Update pedido as p set p.cliente = '" & Ctxt(4).Text & "', p.vendedor = '" & _ Ctxt(5).Text & "', p.tipo = '" & "F" & "', p.condiçoes = '" & "1" & "', p.data = '" & _ Format(Now, "dd/mm/yyyy") & "', p.totalpedido = '" & Lblitens(3).Caption & "' where p.codigo like '" & _ Ctxt(1).Text & "'" DtaPedido.Refresh NovoPedido Else If Lblitens(3).Caption > "0,00" And DtaPedido.Recordset.Fields("tipo") = "P" Then MsgBox "Finalize este pedido antes, ou exclu-a os itens deste pedido!", vbInformation Exit Sub ElseIf Lblitens(3).Caption > "0,00" And DtaPedido.Recordset.Fields("tipo") = "F" Then NovoPedido AnulaLost = True FrmPdvFich.Ctxt(0).Text = Ctxt(1).Text FrmPdvFich.Ctxt(10).Text = IdUser FrmPdvFich.Show vbModal ElseIf Lblitens(3).Caption = "0,00" And DtaPedido.Recordset.Fields("tipo") = "P" Then AnulaLost = True FrmPdvFich.Ctxt(0).Text = Ctxt(1).Text FrmPdvFich.Show vbModal End If End If '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Case Is = vbKeyF3 'buscar ficha If Lblitens(3).Caption = "0,00" And DtaPedido.Recordset.Fields("tipo") = "P" Then Set deletar = Workspaces(0).OpenDatabase(banco) deletar.Execute ("Delete * from Pedido where codigo like '" & Ctxt(1).Text & "'") AnulaLost = True FrmPdvFicBusca.QPediu = 1 FrmPdvFicBusca.Show vbModal ElseIf Lblitens(3).Caption > "0,00" And DtaPedido.Recordset.Fields("tipo") = "P" Then MsgBox "Finalize este pedido antes, ou exclu-a os itens deste pedido!", vbInformation Exit Sub ElseIf Lblitens(3).Caption > "0,00" And DtaPedido.Recordset.Fields("tipo") = "F" Then cnn.Execute "Update pedido as p set p.cliente = '" & Ctxt(4).Text & "', p.vendedor = '" & _ Ctxt(5).Text & "', p.tipo = '" & "F" & "', p.condiçoes = '" & "1" & "', p.data = '" & _ Format(Now, "dd/mm/yyyy") & "', p.totalpedido = '" & Lblitens(3).Caption & "' where p.codigo like '" & _ Ctxt(1).Text & "'" AnulaLost = True FrmPdvFicBusca.QPediu = 1 FrmPdvFicBusca.Show vbModal End If '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Case Is = vbKeyF4 'excluir If nivel = "Administrador" Then If MsgBox("Confirma a exclusão deste pedido e seus registros?", vbQuestion + vbYesNo) = vbYes Then Set deletar = Workspaces(0).OpenDatabase(banco) deletar.Execute ("Delete * from detalhepedido where pedido like'" & Ctxt(1).Text & "'") deletar.Execute ("Delete * from Pedido where codigo like '" & Ctxt(1).Text & "'") Lblitens(3).Caption = "0,00" NovoPedido End If Else If MsgBox("O usuário não tem acesso para exclusão do pedido! " & Chr(13) & "Deseja solicitar autorização?", _ vbQuestion + vbYesNo) = vbYes Then frmautorizacao.QPediu = 2 frmautorizacao.Show vbModal Else MsgBox "O pedido não será excluído!", vbInformation Exit Sub End If End If '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Case Is = 5 'entrega '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Case Is = vbKeyF6 'finalizar AnulaLost = True With FrmFech For i = 0 To 6 .Ctxt(i).Text = "0,00" Next i .QPediu = "2" .Ctxt(0).Text = Format(Lblitens(3).Caption, "#,##0.00;(#,##0.00)") .CCar(0).Text = Ctxt(1).Text .Ctxt(4).Text = Format(Lblitens(3).Caption, "#,##0.00;(#,##0.00)") .Ctxt(8).Text = Format(Lblitens(3).Caption, "#,##0.00;(#,##0.00)") .Lbl(10).Caption = Ctxt(4).Text .Show .Ctxt(1).SetFocus End With '-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* End Select TRATAERRO: Select Case Err.Number Case Is = 0 Case Else MsgBox "Ocorreu um erro inexperado, sai da tela de venda e entre novamente!" & Chr(13) & _ "Informe o código " & Err.Number & " - " & Err.Description & " ao administrador do sistema!", vbInformation Exit Sub End Select End Sub o qual faz um monte de funções, e agora por questões de estética coloquei no meu programa labeis transparentes q ficam parecendo com botoes quando passa o mouse por cima dela, e se o cabloco clicar eu quero q chame este mesmo codigo q esta escrito no form_keydown, alguém sabe me dizer como chamo o evento? Valeu.
  13. alguém pode informar um finger print q tenha compatibilidade com o vb 6.0???
  14. Estou fazendo um calculo simples e não esta me retornando o valor correto, alguém tem uma ideia. QtdSec = rds![qtde] * qtdeproduto onde qtdesec = long / rds![qtde] campo do bd access decimal com precisão 10/4 / qtdeproduto = long valores qtdesec = 0 rds![qtde] = 0,5 qtdeproduto = 1 ele sempre me retorna 0 no calculo, alguém ta vendo onde eu estou errando? valeu pela força
×
×
  • Create New...