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
Messages: 487
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: 65137
Registered: March 2007
Location: Nanterre, France, http://...
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.

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

Current Time: Thu Aug 17 01:12:52 CDT 2017

Total time taken to generate the page: 0.06677 seconds