Home » RDBMS Server » Server Administration » pls help in session problem
pls help in session problem [message #231309] Mon, 16 April 2007 07:12 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hello people,

Pls Immediate help required
Im using macro in excel in which i was create a session of oracle backend. This is command in which im getting error pls help me.

Dim OraSession As Object
Dim OraDatabase As Object
Dim EmpDynaset As Object



Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase("accl", "accl/alfina", 0&)
Set EmpDynaset = OraDatabase.CreateDynaset("select documentno,documentdate,slcode,vendname,particulars,debitamount from ledger a,vendmast b where SUBSTR(documentno,2,3) IN ('206','226') and unitid= " & UNIT & " and periodid= " & PERIOD & " and documentdate between to_date('" & a & "','dd/mm/yyyy') and to_date('" & b & "','dd/mm/yyyy') and glcode ='" & gl & "' and b.vendcode=slcode", 0&)


Advance Thank
Re: pls help in session problem [message #231310 is a reply to message #231309] Mon, 16 April 2007 07:19 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why do you think giving us the error is useless?

In addition, give us the Oracle version number (4 figures), both server and client.

Regards
Michel
Previous Topic: Server Name
Next Topic: could not acess to oracle web administration interface
Goto Forum:
  


Current Time: Sat Dec 07 02:04:55 CST 2024