Hello Sergey,

ok !

  TEXT To lcConnString NOSHOW TEXTMERGE PRETEXT 15
"driver=Advantage StreamlineSQL ODBC;
DataDirectory=C:\cdbk90\amline\AdsBob\JM;
SERVER=NotTheServer;Compression=;
DefaultType=Advantage;
Rows=False;
Language=ANSI;
AdvantageLocking=ON;
Locking=Record;
MemoBlockSize=64;
MaxTableCloseCache=5;
ServerTypes=6;
TrimTrailingSpaces=False"
  ENDTEXT


 CREATE CONNECTION NORTHWINDCONNECTION CONNSTRING &lcConnString   

This code give me a error ( Command contains unrecognized phrase/keyword (Error 36) )

  TEXT To lcConnString NOSHOW TEXTMERGE PRETEXT 15
"driver=Advantage StreamlineSQL ODBC;
DataDirectory=C:\cdbk90\amline\AdsBob\JM;
SERVER=NotTheServer;Compression=;
DefaultType=Advantage;
Rows=False;
Language=ANSI;
Locking=Record;
MemoBlockSize=64;
MaxTableCloseCache=5;
ServerTypes=6;
TrimTrailingSpaces=False"
  ENDTEXT


 CREATE CONNECTION NORTHWINDCONNECTION CONNSTRING &lcConnString   

This code do'nt give a error. ( until AdvantageLocking=ON; )

do you know the reason ?

bernhart



>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