Hi,

I prepare the conversion of a user to sql.
The user has 3 branches, each branch has its own database.
The head office has a customer file. All branch offices access this.
With the embedded database I only make a entry inside workspace file (Datapath)
and delete the file inside the datapath
Code:
[Workspace]
Home=..\
AppSrcPath=.\AppSrc
AppHtmlPath=.\AppHtml
BitmapPath=.\Bitmaps
DataPath=.\datasky;k:\vdf181\projekte\Mobeg\datazeil
...
How can I do it by using MSSQL.
How can I connect to more as one database
For one:
Code:
        If (uppercase(sUser) eq "MOBEGGOE") Begin
          Move ("SERVER=SQL-PC\SQLEXPRESS;UID=Mobeguser;PWD=xxx;DATABASE="+sSQLDB) to sConnectionString 
          Set psSQLPasswort to "xxx"
          Get CreateConnectionID of oCLIHandler "KUS" sConnectionString 0 to iResult  
        End
Who can help me with a sample or where can I read about?