Scott, Sorry for my question not being as detailed. I will make sure to be more detailed in any post. Patrick that was it. Thank you to both. Jerry ... View more

Can anyone please just point me in the right direction? I just want to know how to pull the sas error message to my C# application using oledb to run my sql. Thank You ... View more

Can anyone else help? ... View more

Chris, That is pretty much all I need to is treat sas/share like a database. Here is an example of how i'm using it: using System.Data.OleDb; string conn = "Provider=sas.ShareProvider.1;Data Source=Share1;Location=server1;Mode=Read|Share Deny None"; OleDbConnection connSAS = new OleDbConnection(conn); connSAS.Open(); OleDbCommand sasCommand = connSAS.CreateCommand(); sasCommand.CommandType = CommandType.Text; sasCommand.CommandText = "update system.temp set fname='bob' where id = 10"; try { sasCommand.ExecuteNonQuery(); } catch (System.Exception exc) { MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } Is it possible from what i'm doing to get the exact error back from SAS or do I have to take a different approach? Thanks for your help that is a big problem for me and your help is appreciated. Jerry ... View more

Chris, Would it be more advantages to use IOM? I'm not too familier with it but if it can speed up my app talking to SAS/Share server then I can look into it. Have you used it? What are you thoughts on it, if you don't mind? Thanks again ... View more

Chris, Thank you so much for your response. It is a windows forms "C#" app. I sending regular sql statements to SAS/Share server using OleDB. This is a sample of the updates I pass in. "update system.user set UserNumber = '001' where ID = 1 and PRJID = 11" Lets assume that UserNumber has a unique key constraint and that someone else already has '001'. I need to get the sas error message because it tells me what table and what constraint was violated. Any help pointing me in the right direction would be appreciated. Thank You ... View more

Linus, Thank you that link has helped. I should have "SAS" as one of my options when i'm trying to create a DSN and I don't so I think that might be the reason why this hasn't worked. Thank you again and I will post my results. Jerry ... View more

Linus, Within Visio when I try reverse engineering the only option that shows anything about says is when I select "Generic OLE DB Provider". Then it shows me a list of SAS IOM Data Provider 9.1 SAS Local Data Provider 9.1 SAS OLAP Data Provider 9.1 SAS Share Data Provider 9.1 When I select "SAS Local Data Provider 9.1" it asks for a data source and location and then user name and password. What should the source and location be? Thanks you ... View more

Flip, I should have SAS/ACCESS Interface to ODBC Software installed. I'm still new to sas so i'm not sure how to play around with this. What would be the best way to see if I have it installed? Thanks again so much for your help I do appreciate it. Jerry ... View more

Flip, Thanks for the reply. Is there any software that will recognize SAS tables and display them then I can do the linking? So how do SAS users represent there data schemas? Thanks Jerry ... View more

Cynthia & Linus thank you both for your replies. A database entity relationship diagram is what am looking to do. Where it shows how all the tables relate to one another. I want it to show table name and all the variables and how they join to other tables. I need a visual representation of my directory of sas data tables. Thank you again for your help. Jerry Message was edited by: jerry898969 ... View more