| pls help in session problem [message #231309] |
Mon, 16 April 2007 07:12  |
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  |
 |
Michel Cadot
Messages: 68686
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
