Click here to Skip to main content
15,884,099 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am working on a Windows forms application, a migration project from Vb6 and need to connect to Sage300 CRE database. I see ADODB connection in Vb6, like
"Driver=Timberline Data;DBQ=<database>; CODEPAGE=1252; DatabaseType=1; DictionaryMode=1;MaxColSupport=255;ShortenNames=0;StandardMode=0; 
    UID=<username>;PWD=<password>"
So far from my search, I get as I should use ODBC connection for the same from my .net code. I need to retrieve Table, Columns, PrimaryKey, ForeignKey schema info from the connection object calling GetSchema() method. And ODBC GetSchema() does not exist for primary key & Foreign Key. Is there any other provider type I can use to connect to Sage300CRE, that helps me get the above mentioned schema info too?

What I have tried:

I have tried ODBC connection to different databases like Firebird and got to know the GetSchema limitation and switched to Firebird Ado.net provider in that case. So would want to know if similar options available for Sage300CRE too?
Posted
Updated 8-Feb-18 7:56am
Comments
CHill60 8-Feb-18 9:05am    
You should direct this quesiton to the Sage support team!

1 solution

I'd suggest to read this: An Introduction to the Sage 300 ERP .Net API | Stephen Smith's Blog[^]
After quick research i'm pretty shure that it's the only way to retrive entire information about database objects such as tables, keys, etc.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900