Welcome to The Forum

Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads

Vb6 (Yes 6), Microsoft Sql Server And Empty Strings


TestingM
 Share

Recommended Posts

Does anyone know how to send an empty parameter string to a SQL Server stored procedure properly? If my string is empty, VB6 sends 8000 space characters to SQL Server which is somewhat annoying.

 

I'm using an ADODB command to send the query.

 

Technically I guess I could send some weird character code that will never occur normally but that's not perfect.

Link to comment
Share on other sites

It's going to a stored procedure, not an insert statement. It starts off as a zero length string in VB6 but SQL Server Profiler shows 8000 spaces being sent to SQL Server.

 

Fair enough. Do you have an example of the procedure you're using now? It might help me get round to try and fix it. I would (try) to build one myself but I would have nothing to go by.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share