C# JDE Access using odbc library list

[vince Donato]

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]

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.

 

[vince Donato]

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

 

[adeel]

Did you try creating system DSN ? Try that.

 

[vince Donato]

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.