Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Proble in inserting the records from Navision to Oracle 10g
ajaybabuCh
Member Posts: 208
Hi
I am ajay. When I am trying to inserting the records from navision to Oracle10g I am getting the following error.
This message is for C/AL programmers :
The Call to member open failed. Microsoft OLE DB provider for ODBC drivers returned the following message:
[Oracle][ODBC][Ora]ORA-00984: column not allowed here.
Please see the following code :
See the following variables that i used in this case :
1)ADO(automation variable)--'Microsoft ActiveX Data Objects 2.7 Library'.Connection
2)RsReceiveData(Automation)-- Unknown Automation Server.Recordset
3)RsFReceiveData( Automation)-- 'Microsoft ActiveX Data Objects 2.7 Library'.Fields
4)FieldReceiveData( Automation)-- Unknown Automation Server.Field
automation server for the unknow automation is :
{00000300-0000-0010-8000-00AA006D2EA4} 2.7 and select the field or recordset.
see the code below for connection :(its working)
IF ISCLEAR(ADO) THEN
CREATE(ADO);
ADO.Open('data source=' + 'Testclient' + ';' + 'user id=' + 'sir' + ';' + 'password=' + 'sir');
ADO.CommandTimeout(600);
MESSAGE('connection established...');
See the code for inserting the records into Oracle table :(its not working )
//BATCHTRANS is the oracle table.
VendorLedgerEntry.RESET;
VendorLedgerEntry.SETFILTER("Document Date",'>%1',020306D);
IF VendorLedgerEntry.FIND('-') THEN BEGIN
CreateConnection;
CREATE(RsReceiveData);
RsReceiveData.Open('INSERT INTO SIR.BATCHTRANS (SIR.BATCHTRANS,SIR.TRANSTYPE) VALUES('+ FORMAT(VendorLedgerEntry."Entry No.")+','+
FORMAT(VendorLedgerEntry."Document Type")+')',ADO);
END;
RsReceiveData.Close;
could anybody give me the code to insert the records from navision to Oracle10g
Regards
ajay
I am ajay. When I am trying to inserting the records from navision to Oracle10g I am getting the following error.
This message is for C/AL programmers :
The Call to member open failed. Microsoft OLE DB provider for ODBC drivers returned the following message:
[Oracle][ODBC][Ora]ORA-00984: column not allowed here.
Please see the following code :
See the following variables that i used in this case :
1)ADO(automation variable)--'Microsoft ActiveX Data Objects 2.7 Library'.Connection
2)RsReceiveData(Automation)-- Unknown Automation Server.Recordset
3)RsFReceiveData( Automation)-- 'Microsoft ActiveX Data Objects 2.7 Library'.Fields
4)FieldReceiveData( Automation)-- Unknown Automation Server.Field
automation server for the unknow automation is :
{00000300-0000-0010-8000-00AA006D2EA4} 2.7 and select the field or recordset.
see the code below for connection :(its working)
IF ISCLEAR(ADO) THEN
CREATE(ADO);
ADO.Open('data source=' + 'Testclient' + ';' + 'user id=' + 'sir' + ';' + 'password=' + 'sir');
ADO.CommandTimeout(600);
MESSAGE('connection established...');
See the code for inserting the records into Oracle table :(its not working )
//BATCHTRANS is the oracle table.
VendorLedgerEntry.RESET;
VendorLedgerEntry.SETFILTER("Document Date",'>%1',020306D);
IF VendorLedgerEntry.FIND('-') THEN BEGIN
CreateConnection;
CREATE(RsReceiveData);
RsReceiveData.Open('INSERT INTO SIR.BATCHTRANS (SIR.BATCHTRANS,SIR.TRANSTYPE) VALUES('+ FORMAT(VendorLedgerEntry."Entry No.")+','+
FORMAT(VendorLedgerEntry."Document Type")+')',ADO);
END;
RsReceiveData.Close;
could anybody give me the code to insert the records from navision to Oracle10g
Regards
ajay
Ajay
0
Comments
Sorry I got the solutin but i forget to post
For inserting or deleting or modifying the following is the statement
ADO.EXECUTE(INSERT OR DELETE OR MODIFY QUERY)
Regards
Ajay
I'm still confused about the connection statement.
How does the ADO-variable get the information that this is an Oracle DB?
And what is the meaning of "data source=Testclient"? How do you define "Testclient"? Is this the computer oracle runs on?
Greets
'Fish
Member of OpenBC