Set buffersize for SQL connection

[markus.essmayr]

Hi,

I'm connecting to my SQL Server database using this code:

Code: Select all

Set SqlDatabase = STRING_Null
Set SqlUser = STRING_Null
Set SqlPassword = STRING_Null
Set SqlUDL = 'SQLOLEDB;Data Source=MYDBSERVERNAME;Initial Catalog=MYDBNAME;Integrated Security=SSPI;Connect Timeout=5;Network Library=DBMSSOCN;'
Call SqlConnect( hSql )

The cool thing is, I don't need any SQL.INI to establish the database connection.
But as I need to load and save large binary data, I'd like to increase the long buffer size.
Unfortunately using SqlSetParameter with DBP_LONGBUFFER doesn't work and SqlSetParameter always returns FALSE.

Does anybody know what I'm doing wrong?

Thanks in advance!
Max

[wwasilew]

Hi Marcus,

DBP_LONGBUFFER must be used with the Function SqlSetParameterAll normally.May be, Is that the reason for the problem?

[markus.essmayr]

Hello,

thanks for your answer.

I tried both, SqlSetParameter and SqlSetParameterAll - neither of them work!

Max

[markus.essmayr]

Any ideas out there?