mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 6:45 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 49 posts ]  Go to page Previous  1, 2, 3, 4
Author Message
 Post subject: Re: Using ADO & Stored Procedures in C/SIDE
PostPosted: Wed Jan 04, 2012 9:18 am 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
can we use this to automate customer master from database 1 to another databases?
thanks


Top
 Profile E-mail  
 
 Post subject: Re: Using ADO & Stored Procedures in C/SIDE
PostPosted: Wed Jan 04, 2012 9:25 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4224
Location: New Delhi
Country: India (in)
jr macarilay wrote:
is there a way to use Windows Authentication with this?

i tried 'Integrated Security=TRUE' but im getting an error


Use

Quote:
ConnectionString := 'Data Source='+ServerName+';'
+ 'Initial Catalog='+NavDb+';'
+ 'Trusted_Connection=True;';

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: Using ADO & Stored Procedures in C/SIDE
PostPosted: Sun Jan 08, 2012 3:00 pm 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
hi all...
now i can execute from nav to SP
i want to execute insert,update (and maybe delete row) to several databases
so... how do i send the parameter (example : customer no, customer name, etc) become parameter in my storeprocedure?
thanks


Top
 Profile E-mail  
 
 Post subject: Re: Using ADO & Stored Procedures in C/SIDE
PostPosted: Mon Jan 09, 2012 4:01 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7493
Location: Milan
Country: Italy (it)
Give this a look : http://dynamicsuser.net/blogs/waldo/archive/2008/01/06/using-stored-procedures-in-c-side.aspx

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 49 posts ]  Go to page Previous  1, 2, 3, 4

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: