How to upload pdf file to sql sever

General
1

Some one can guild line me for uplaod or insert pdf file to sql database

2

  1. do you know how do insert data into an sql database? If you don't do a google search using 'node-red mysql example' and you find a tutorial.

  2. does your database have a column defined as 'blob'? If you don't, do a google search using 'sql blob' and read about what you need to define in the database to store a large file. Then check the schema of your database and make sure to add one. depending on if this is afor a business, you may have to talk to your DBA. If not, you'll need to create the table with that data type.

3

Hi. That is a fairly loaded question.

Before we can assist, you really need to share more info.

for example...

  • Where are you stuck?
    • Do you have the "Upload" part working?
    • Do you have the SQL Server INSERT part working?
    • Do you have the Database and its Tables created already?
    • Are you expecting to use SQL Stored Procedures or INSERT queries?
    • Are you wanting to upload the text from the PDF (into a text field) OR the actual file (as a blob?)
  • what SQL Server version are you using?
    • is the SQL Server local or remote
    • are you using built-in security or SQL Server logins?
  • Are you using node-red-contrib-mssql-plus (this is the most capable / most supported node)
4

[quote="Steve-Mcl, post:3, topic:58886"]

  • Do you have the "Upload" part working?
    ํYes,
  • Do you have the SQL Server INSERT part working?
    Yes, using node red.
  • Do you have the Database and its Tables created already?
    No, please recommend data type.
  • Are you expecting to use SQL Stored Procedures or INSERT queries?
    Just INSERT queries.
  • Are you wanting to upload the text from the PDF (into a text field) OR the actual file (as a blob?)actual file .pdf
    what SQL Server version are you using?ver 2014 express.
  • is the SQL Server local or remote: Local
  • are you using built-in security or SQL Server logins? No need
  • Are you using node-red-contrib-mssql-plus (this is the most capable / most supported node)
    Yes using node mssql-plus.

Thanks

5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.