Connection to MSSQL

[kjellv]

hi
Can you hint me about this connection which does not work, I get no SQL error, but only "/dfUserID" in the error box.

Data Source = ServerName in MSSM
Initial Catalog = my database, HOLLYWD
User ID = User Name in MSSM
Password = my logon pw to my PC

Call SalWaitCursor( TRUE )
Set SqlDatabase = STRING_Null
Set SqlUser = STRING_Null
Set SqlPassword = STRING_Null
Set SqlResultSet = TRUE
Set SqlIsolationLevel = 'RL'
Set sConnectionString = 'SQLOLEDB;Data Source=(LocalDB)\\MSSQLLocalDB;Initial Catalog=HOLLYWD;User ID=dfUserId;Password=dfPassword;Persist Security Info=True;'
Call SqlCreateSession( hSqlLocal, sConnectionString )
Call SqlSetSessionParameter( hSqlLocal, DBP_AUTOCOMMIT, FALSE, '' )

[FRBhote]

If dfUserId and dfPassword are variables, then you need to concatenate them in the string.

[kjellv]

If dfUserId and dfPassword are variables, then you need to concatenate them in the string.

hi
I did this
Set sConnectionString = 'SQLOLEDB;Data Source=ASUS;Initial Catalog=HOLLYWD;User ID=' || dfUserId||';Password='||dfPassword||';Persist Security Info=True;'

I debugged this
"SQLOLEDB;Data Source=ASUS;Initial Catalog=HOLLYWD;User ID=sa;Password=p7pusWEr;Persist Security Info=True;"

The error show this
/sa

and as you see from the att. my ULD connections works with the same settings?