5/16/2024 3:42:14 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
SlxOleDB and oracle synonyms
Posted: 23 Mar 07 4:11 AM
|
fiogf49gjkf0d Hi,
on an oracle DB I created a Synonym on the schema SYSDBA which link via databaseLink to an external Oracle DB. I tried to access to this synonym via a OraOLEDB.Oracle provider and it works properly, but with the SlxOleDB provider it gives me the error "Table name does not exists". The only way I found to access to this synonym is to create a local View defined with the synonym (create view.... as select * from synonym...), but for me this is not enough because I would like to modify the data on the synonym.
So, my question is: There is a way to use Oracle synonyms via SlxOleDb provider?
Thank you in advance.
Alessandro. |
|
|
|
Re: SlxOleDB and oracle synonyms
Posted: 25 Mar 07 10:21 AM
|
fiogf49gjkf0d SalesLogix is designed db agnostic and does NOT support features that are unique to a particular DB engine.
If anything, it favors MSSQL server.
Look to ANSI SQL 92 as a guide. - and NOT to Optional parts of the spec.
--
rjl |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|