Skip to main content
Nintex Community Menu Bar
Solved

Does Nintex Forms support SQL Connections to ports other than 1433?

  • May 18, 2021
  • 3 replies
  • 45 views

mvdmolen
Forum|alt.badge.img+2

I am setting up a SQL Request for my form. I can't seem to connect, our database server is not using the default 1433.

 

Can I set this field this way?

 

Server: MySQLServerMyInstance,9999

 

where 9999 is the port number

Best answer by mvdmolen

Got it to work! And yes it looks any port goes. I could not find it in the Nintex documentation.

 

So the Server field in the SQL Request Control follows the syntax: ServerInstance,Port

 

 

3 replies

Forum|alt.badge.img+12
  • Rookie
  • May 19, 2021

@mvdmolen did you try to explore web request control?


mvdmolen
Forum|alt.badge.img+2
  • Author
  • May 19, 2021

I need to query the database directly from the form. Not sure how a web request control would be able to do that.

 

Does the SQL Request control support ports other than the default SQL Server Port 1433?

 

If so, what would the syntax be for the Control Settings?


mvdmolen
Forum|alt.badge.img+2
  • Author
  • Answer
  • May 19, 2021

Got it to work! And yes it looks any port goes. I could not find it in the Nintex documentation.

 

So the Server field in the SQL Request Control follows the syntax: ServerInstance,Port