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!
|
|
Oracle vs MS SQL
Posted: 28 Aug 06 9:40 AM
|
fiogf49gjkf0d Does SLX have a function for determining if a connection is Oracle vs SQL?
Is ther a SQL stmt that'll work against both I can use (for example "Select @@VERSION")?
I can always write a function to parse the connection string, but this seams pretty weak.
Thanks |
|
|
|
Re: Oracle vs MS SQL
Posted: 28 Aug 06 10:09 AM
|
fiogf49gjkf0d What's wrong with checking the connection string? That's how I would do it. If you execute the slx_getNativeConnInfo proc you'll get back a connection string to the underlying database (SQL or Oracle - minus the sysdba password). The provider would be easily identifyable in the string. |
|
|
|
Re: Oracle vs MS SQL
Posted: 28 Aug 06 10:34 AM
|
fiogf49gjkf0d OK, I'll go with that then.
Previously there was a global identifying the type and I'd assume SLX knows internally, but I couldn't find anything in the docs, but that they'd share it with us.
Thanks |
|
|
|
Re: Oracle vs MS SQL
Posted: 28 Aug 06 10:38 AM
|
fiogf49gjkf0d Oh yeah, now that you mention that, I think this does work to get the database type (although have not confirmed)
dbtype = Application.BasicFunctions.SystemInfoFor("DatabaseType")
Give that a try.
-Ryan |
|
|
| |
|