Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DSN on advantage database
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Miscellaneous
Thread ID:
01453262
Message ID:
01453395
Views:
57
Create a file DSN, open it in any text editor and copy settings from there.

>
>i should like a sample to make a DSN advantage sybase
>
>
>here is a sample with free VFP tables.
>
>
>strDriver = "Microsoft Visual FoxPro Driver" 
>
>strAttributes = "DESCRIPTION=Temp DSN" 				+ CHR(0)
>strAttributes = strAttributes + "DSN=AmlineFreeTables" 	+ CHR(0)
>strAttributes = strAttributes + "SourceType=DBF" 	+ CHR(0)
>strAttributes = strAttributes + "Deleted=Yes" 		+ Chr(0) 
>strAttributes = strAttributes + "BackgroundFetch=No" + Chr(0)
>strAttributes = strAttributes + "Collate=Machine" 	+ Chr(0)
>strAttributes = strAttributes + "Exclusive=No" 	+ Chr(0)
>strAttributes = strAttributes + "SourceDB =" + SYS(5) + CURDIR() + CHR(0)
>*strAttributes = strAttributes + "UID=sa" + CHR(0)
>*strAttributes = strAttributes + "PWD=" + CHR(0)
>*'To show dialog, use Form1.Hwnd instead of vbAPINull.
>intRet = SQLConfigDataSource( vbAPINull, ODBC_ADD_DSN, ;
>   strDriver, strAttributes)
>
>
>thank in advance for help
>
>
>
>bernhart
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform