Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Setting Connection String programmatically 2006-02-22 -- J Shankar > When using the "Microsoft SQL" driver with clarion 6.3 what should be put in
> the following fields of the "Edit Table Properties" of the data dictionary
>
> 1) Driver options
> 2) Owner name
> 3) Path Name
>
> Where can I find the documentation on this and for other database drivers
1) Driver options - Any driver option supported by the driver
2) Owner name - Database Connect String
3) Path Name - Owner.TableName
Example :
TELDEPT
FILE,DRIVER('MSSQL',GLO:SQL_DriverOptions),OWNER(GLO:SQL_ConnectString),NAME('dbo.TELDEPT')
GLO:Server = GETINI('Connection','Server','(local)','.\TELAPPR.INI')
GLO:Database = GETINI('Connection','Database','******','.\TELAPPR.INI')
GLO:DbUser = GETINI('Connection','DbUser','******','.\TELAPPR.INI')
GLO:DbPWord = GETINI('Connection','DbPWord','******','.\TELAPPR.INI')
GLO:Trusted = GETINI('Connection','Trusted','N','.\TELAPPR.INI')
GLO:SQL_DriverOptions = GETINI('Connection','DriverOptions','','.\TELAPPR.INI')
IF GLO:Trusted = 'Y'
GLO:SQL_ConnectString = CLIP(GLO:Server) & ',' & CLIP(GLO:Database) & ';APP=TELAPPR'
GLO:SQL_DriverOptions = '/LOGONSCREEN=False,/TRUSTEDCONNECTION=True' &
CHOOSE(GLO:SQL_DriverOptions <> '',',' & CLIP(GLO:SQL_DriverOptions),'')
ELSE
GLO:SQL_DriverOptions = '/LOGONSCREEN=False,/TRUSTEDCONNECTION=False' &
CHOOSE(GLO:SQL_DriverOptions <> '',',' & CLIP(GLO:SQL_DriverOptions),'')
END
Today is November 21, 2024, 9:53 am This article has been viewed 35243 times.
|
|