[Asp10.net] =?iso-8859-1?q?Conex=E3o?= ORACLE - URGENTE !!!!!!!!

Mon, 09 Feb 2004 13:11:34 -0800 

This is a multi-part message in MIME format.

--_=__=_XaM3_Boundary.1076357261.2A.270693.42.22952.52.42.101010.1604208249
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit


<html>
<body>
<br>
Boa tarde a todos,<br>
<br>
Estou precisando fazer conex�o com banco de dados Oracle, <br>
como n�o estou desenvolvendo o c�digo na maquina em que o <br>
banco de dados est� instalado, estou fazendo um teste em <br>
banco de dados similar&nbsp; Access (igual em rela��o as tabelas) <br>
ao que terei que utilizar, uso o seguinte trecho de c�digo <br>
para conex�o:<br>
<br>
<br>
Set Conexao = Server.CreateObject("ADODB.Connection")<br>
Conexao.Open "Provider = Microsoft.Jet.OLEDB.4.0;DATA <br>
SOURCE=" & Server.Mappath("db/vendalocacao.mdb")<br>
<br>
<br>
Consegui o seguinte exemplo para Oracle, e tenho 3 d�vidas:<br>
<br>
<br>
Set cnnOracle = Server.CreateObject("ADODB.Connection")<br>
cnnOracle.Open "Provider=MSDAORA.1;Password=x;User <br>
ID=hpuser;Data Source=DCTRTC01;Persist Security Info=True"<br>
<br>
<br>
1 - Est� corretor, n�o tenho como expliquei anteriormente <br>
como testar o c�digo e PRECISO SABER SE EST� CORRETO PARA <br>
IMPLEMENTA-LO AMANH�:<br>
<br>
2 - Onde indico o nome do banco, fa�o como no Access DATA <br>
SOURCE=" & Server.Mappath("db/vendalocacao.mdb") e continuo?<br>
<br>
Ficaria assim:<br>
<br>
<br>
Set cnnOracle = Server.CreateObject("ADODB.Connection")<br>
cnnOracle.Open "Provider=MSDAORA.1;Password=x;User <br>
ID=hpuser;Data Source= DATA SOURCE=" & Server.Mappath<br>
("db/vendalocacao.?");Persist Security Info=True"<br>
<br>
<br>
3 - Qual a extens�o do banco?<br>
<br>
Fico grata por qualquer tipo de ajuda, pois como escrevi <br>
antes PRECISO SABER SE EST� CORRETO PARA IMPLEMENTA-LO <br>
AMANH�...<br>
<br>
<br>
Muitiss�mo obrigada !!!!!!!!!!!!!!!!!!!!<br>
Cristina<br>
<br>
&nbsp;<br>
---<br>
Acabe com aquelas janelinhas que pulam na sua tela.<br>
AntiPop-up UOL - � gr�tis! <br>
<a href="http://antipopup.uol.com.br";>http://antipopup.uol.com.br</a><br>



</blockquote>
<!-- tag GrUpOs -->

<br>
:: <a href="http://www.asp10.net";>http://www.asp10.net</a><br>
==================================================<br>
:: Solu��es simples para problemas complexos<br>
:: Sistemas de Links, Not�cias, Faq, Loja,<br>
:: Estat�sticas, Artigos, Mural e muito mais.<br>
==================================================<br>
:: Para entrar, sair ou ver o hist�rico da lista<br>
:: Asp10.net visite <a href="http://www.asp10.net";>http://www.asp10.net</a><br>
==================================================<br>
<br>


 <br>
 <img width=1 height=1 src="http://banner.grupos.com.br/?157:62:1076357442:1";>

<!-- menu in -->
<br>
<center>
<!-- banner in -->
<a 
href="http://campanhas.grupos.com.br/click.phtml?id=1076357442&campanha=abril.info.email01&url=http://assineabril.com/index.html?destino=telainfo*campanha=4QFT*origem=shoppinggrupos";
 target="_blank">
<img src="http://imagens.grupos.com.br/banners/abril/728x90_info.gif"; width="728" 
height="90" border="0"></a>
<img width="0" height="0" 
src="http://view.campanhas.grupos.com.br/?abril.info.email01|1076357442">

<!-- banner out -->
<style>.agrupos{font-size:10px;font-family:"Tahoma,Verdana,Arial";color:#CECFCE;text-decoration:none;}</style>
<table cellpadding=0 cellspacing=0 width="75%" border=0>
 <tr>
  <td rowspan=3 valign=top><a href="http://www.grupos.com.br";>
  <img border=0 src="http://imagens.grupos.com.br/e/h.gif";></a></td>
  <td height=31>
  </td>
 </tr>
 <tr><td height=6 width="100%" bgcolor="#CECFCE"></td></tr>
 <tr><td valign=top align=right><a href="mailto:[EMAIL PROTECTED]" 
class=agrupos>cancelar assinatura</a> <a href="http://www.grupos.com.br/grupos/mrasp"; 
class=agrupos>- p�gina do grupo</a>
  </td>
 </tr>
</table>
</center>
</body>
</html>
<!-- menu out -->
<!-- tag GrUpOs. -->


--_=__=_XaM3_Boundary.1076357261.2A.270693.42.22952.52.42.101010.1604208249
Content-Type: text/plain; name=BodyPart
Content-Transfer-Encoding: base64

Qm9hIHRhcmRlIGEgdG9kb3MsDQoNCkVzdG91IHByZWNpc2FuZG8gZmF6ZXIgY29uZXjjbyBjb20g
YmFuY28gZGUgZGFkb3MgT3JhY2xlLCANCmNvbW8gbuNvIGVzdG91IGRlc2Vudm9sdmVuZG8gbyBj
82RpZ28gbmEgbWFxdWluYSBlbSBxdWUgbyANCmJhbmNvIGRlIGRhZG9zIGVzdOEgaW5zdGFsYWRv
LCBlc3RvdSBmYXplbmRvIHVtIHRlc3RlIGVtIA0KYmFuY28gZGUgZGFkb3Mgc2ltaWxhciAgQWNj
ZXNzIChpZ3VhbCBlbSByZWxh5+NvIGFzIHRhYmVsYXMpIA0KYW8gcXVlIHRlcmVpIHF1ZSB1dGls
aXphciwgdXNvIG8gc2VndWludGUgdHJlY2hvIGRlIGPzZGlnbyANCnBhcmEgY29uZXjjbzoNCg0K
PCUNClNldCBDb25leGFvID0gU2VydmVyLkNyZWF0ZU9iamVjdCgiQURPREIuQ29ubmVjdGlvbiIp
DQpDb25leGFvLk9wZW4gIlByb3ZpZGVyID0gTWljcm9zb2Z0LkpldC5PTEVEQi40LjA7REFUQSAN
ClNPVVJDRT0iICYgU2VydmVyLk1hcHBhdGgoImRiL3ZlbmRhbG9jYWNhby5tZGIiKQ0KJT4NCg0K
Q29uc2VndWkgbyBzZWd1aW50ZSBleGVtcGxvIHBhcmEgT3JhY2xlLCBlIHRlbmhvIDMgZPp2aWRh
czoNCg0KPCUNClNldCBjbm5PcmFjbGUgPSBTZXJ2ZXIuQ3JlYXRlT2JqZWN0KCJBRE9EQi5Db25u
ZWN0aW9uIikNCmNubk9yYWNsZS5PcGVuICJQcm92aWRlcj1NU0RBT1JBLjE7UGFzc3dvcmQ9eDtV
c2VyIA0KSUQ9aHB1c2VyO0RhdGEgU291cmNlPURDVFJUQzAxO1BlcnNpc3QgU2VjdXJpdHkgSW5m
bz1UcnVlIg0KJT4NCg0KMSAtIEVzdOEgY29ycmV0b3IsIG7jbyB0ZW5obyBjb21vIGV4cGxpcXVl
aSBhbnRlcmlvcm1lbnRlIA0KY29tbyB0ZXN0YXIgbyBj82RpZ28gZSBQUkVDSVNPIFNBQkVSIFNF
IEVTVMEgQ09SUkVUTyBQQVJBIA0KSU1QTEVNRU5UQS1MTyBBTUFOSMM6DQoNCjIgLSBPbmRlIGlu
ZGljbyBvIG5vbWUgZG8gYmFuY28sIGZh528gY29tbyBubyBBY2Nlc3MgREFUQSANClNPVVJDRT0i
ICYgU2VydmVyLk1hcHBhdGgoImRiL3ZlbmRhbG9jYWNhby5tZGIiKSBlIGNvbnRpbnVvPw0KDQpG
aWNhcmlhIGFzc2ltOg0KDQo8JQ0KU2V0IGNubk9yYWNsZSA9IFNlcnZlci5DcmVhdGVPYmplY3Qo
IkFET0RCLkNvbm5lY3Rpb24iKQ0KY25uT3JhY2xlLk9wZW4gIlByb3ZpZGVyPU1TREFPUkEuMTtQ
YXNzd29yZD14O1VzZXIgDQpJRD1ocHVzZXI7RGF0YSBTb3VyY2U9IERBVEEgU09VUkNFPSIgJiBT
ZXJ2ZXIuTWFwcGF0aA0KKCJkYi92ZW5kYWxvY2FjYW8uPyIpO1BlcnNpc3QgU2VjdXJpdHkgSW5m
bz1UcnVlIg0KJT4NCg0KMyAtIFF1YWwgYSBleHRlbnPjbyBkbyBiYW5jbz8NCg0KRmljbyBncmF0
YSBwb3IgcXVhbHF1ZXIgdGlwbyBkZSBhanVkYSwgcG9pcyBjb21vIGVzY3JldmkgDQphbnRlcyBQ
UkVDSVNPIFNBQkVSIFNFIEVTVMEgQ09SUkVUTyBQQVJBIElNUExFTUVOVEEtTE8gDQpBTUFOSMMu
Li4NCg0KDQpNdWl0aXNz7W1vIG9icmlnYWRhICEhISEhISEhISEhISEhISEhISEhDQpDcmlzdGlu
YQ0KDQogDQotLS0NCkFjYWJlIGNvbSBhcXVlbGFzIGphbmVsaW5oYXMgcXVlIHB1bGFtIG5hIHN1
YSB0ZWxhLg0KQW50aVBvcC11cCBVT0wgLSDJIGdy4XRpcyEgDQpodHRwOi8vYW50aXBvcHVwLnVv
bC5jb20uYnINCg==



--_=__=_XaM3_Boundary.1076357261.2A.270693.42.22952.52.42.101010.1604208249--

Responder a