• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

C# JDE Access using odbc library list

is there anyone who is programming in C# that is getting data from a jde table using odbc library list.
could you please provide me with the setup required for both the odbc and the connection from the c# program. Thanks
 

adeel

VIP Member
I don't know what exact requirement you have and what you want to do: Personal ODBC is limited to one machine and required maintenance.
Here what you need.
1. Create db readeraccount or use your integrated access to db.
2. You can create odbc connection (sql, oracle) or whatever driver you need. open connection from C#. (google it lots of method about that).

I recommend:
1. Create db readeraccount (give access the databases you need)
2. Create inhouse db and create views/sp to access jde.
3. use the account within c# (and develop click once or web application) and publish to anyone as long as there is no sensitive data.
 
is there anyone who is programming in C# that is getting data from a jde table using odbc library list.
could you please provide me with the setup required for both the odbc and the connection from the c# program. Thanks
Hi adeel, I am ok with the connection to JDE from c# using odbc. My problem is that there are 2 ways in odbc to get data from:
1) a specific library 2) a library list

I am able to get the option 1 to work but cannot get option 2 for library list to work. I am thinking that there might be a syntax in the DSN in c# to
use the library list instead of the library option in odbc. But cannot get option2 to work. This is required because in JDE there are multiple libraries where the data resides in.

Thanks
 
Yes. As I mentioned under the server settings of the DSN there are 2 options for library. 1 single library which works ok, but 2 library list does not pick up the file(s) in that library list.
 
Top