Set buffersize for SQL connection

Discussion forum about all things SqlBase.
User avatar
markus.essmayr
Site Admin
Site Admin
Austria
Posts: 892
Joined: 06 Mar 2017, 06:07
Location: Austria

Set buffersize for SQL connection

Post by markus.essmayr » 31 Aug 2015, 08:35

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
Markus Eßmayr
teamdeveloper@t-mx.com

wwasilew
Germany
Posts: 28
Joined: 06 Mar 2017, 07:33
Location: Dortmund / Germany

Re: Set buffersize for SQL connection

Post by wwasilew » 01 Sep 2015, 12:46

Hi Marcus,

DBP_LONGBUFFER must be used with the Function SqlSetParameterAll normally.May be, Is that the reason for the problem?
Wladislaw Wasilewitsch
---------------------------------------------------
Software Developer
Materna TMT GmbH

User avatar
markus.essmayr
Site Admin
Site Admin
Austria
Posts: 892
Joined: 06 Mar 2017, 06:07
Location: Austria

Re: Set buffersize for SQL connection

Post by markus.essmayr » 02 Sep 2015, 14:55

Hello,

thanks for your answer.

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

Max
Markus Eßmayr
teamdeveloper@t-mx.com

User avatar
markus.essmayr
Site Admin
Site Admin
Austria
Posts: 892
Joined: 06 Mar 2017, 06:07
Location: Austria

Re: Set buffersize for SQL connection

Post by markus.essmayr » 15 Oct 2015, 12:46

Any ideas out there?
Markus Eßmayr
teamdeveloper@t-mx.com

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests