Jump to content
Sign in to follow this  
Priyanka Shahi

Problem connecting to a database through 'SQL Connector'

Recommended Posts

I am trying to set up the connection between PLC and a local database for the first time. Tried many times but an unsuccessful attempt. I think I might be making mistake in configuring the connection parameters in UniLogic. In my case I am using   SQL server. Can somebody help me to explain the database connection parameters?

I have attached my settings below.

Question.PNG

Share this post


Link to post
Share on other sites

1) You have it configured as MySQL, while it looks like you need SQL Server

2) The PLC doesn't know what is CTP-1. Give it the IP of the computer, (or the Host in case you have the DNS in the PLC Configured correctly)

3) In the Identification Type try using Instance, and then set the instance Name as SQLEXPRESS

4) Set the Database name to be USERTBD

5) Set a Username and Password that are acceptable by your SQL Server.

6) Disable firewall on the computer that hosts the SQL Server. 

Share this post


Link to post
Share on other sites

Thank you for the reply. I mistakenly attached the wrong image. I actually have SQL server confirmation for the first step. I tried to connect using the IP address of my PC where my local database resides and I believe my DNS is configured properly as I have successfully done setting for email which would not work if I have a wrong setting for DNS.  I disabled the firewall on the PC too.  I am still not connected to the database. Maybe I am using wrong information in database name section. 

Share this post


Link to post
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.
Note: Your post will require moderator approval before it will be visible.

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.

Sign in to follow this  

×
×
  • Create New...