12-05-2018 06:28 PM - edited 12-05-2018 06:29 PM
Hello, I currently use access to create a database, in the file that I use I use a connection string, it works very well, I do not use .UDL. now I want to use SQL server or Mysql metiante the same method I need help. Thank you.
Solved! Go to Solution.
12-05-2018 09:08 PM
The connection strings for MySQL and MS SQL are all pretty much the same. Just change the relevant fields to the values matching your database and you should be good to go.
Here is an example of a DSN for MySQL.
[ODBC]
DRIVER=MySQL ODBC 5.1 Driver
UID=user
SERVER=1.2.3.4
PORT=0
OPTION=0
PWD=password
12-05-2018 10:15 PM
Hello Mark Yedinak I hope you excuse my little experience. Now I have installed the 2014 SQL server 32bit. and MySQL Community Server 8.0.13 x64 I could not make a connection. I managed to do it using .UDL I have w10 64; labview 16 32bit. Can you give me an example with more details please, I have been with this problem for weeks. thank you.
@Mark_Yedinak ha escrito:
The connection strings for MySQL and MS SQL are all pretty much the same. Just change the relevant fields to the values matching your database and you should be good to go.
Here is an example of a DSN for MySQL.
[ODBC]
DRIVER=MySQL ODBC 5.1 Driver
UID=user
SERVER=1.2.3.4
PORT=0
OPTION=0
PWD=password
12-06-2018 12:28 AM
hi i'm using 2008 version and this connection string works for me.
[SQLDB]
DataBase=database name
Server=server name
Username=username
Password=yourpassword
replace the fields with your table and server info.
if you are using windows authentication the following connection string should work.
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;InitialCatalog=FIMCertificateManagement;Data Source=your server name;database=database name;
the connections string can by obtained from udl file, just open it in a text file.
12-06-2018 08:54 AM
The UDL is a helpful tool even if you don't want to use them. Create an empty .UDL, open it and configure it to work with your SQL server, then open it in a text editor and copy the Connection string. 🙂
/Y
12-06-2018 08:57 AM
I've found www.connectionstrings.com pretty useful...
12-07-2018 10:39 AM
thanks for your reply. get the communication with this string
Driver={SQL Server Native Client 11.0};Uid=sa;Pwd=serincop20514005932;Server=DESKTOP-08H2FR3\SERINCOPDB;Database=datosvictor;
I use the sql server 2014.
when I want to install my project (.exe) in Labview. to another pc. Is it necessary to install all the sql server packages or is there a runtime? as access runtime
.
12-07-2018 11:23 AM
You may need to install the DB driver, but that should be the only thing you need to install. Obviously you will need the DSN so that you can connect.
12-10-2018 01:47 AM
@Victorfasanando wrote:
when I want to install my project (.exe) in Labview. to another pc. Is it necessary to install all the sql server packages or is there a runtime? as access runtime
As Mark said, I think a driver should be enough.
But there's also a compact edition. I think Citadel (LV DSC) installs that too.
The driver allows communication to SQL databases, the SQL Server compact version allows running a database locally.
I'm not an expert on this, but I know there's a free SQL Server Database client. It looks like it's the compact version, but I might be wrong.
You might also like Sql Server Management Studio, to manage the free client.
12-11-2018 04:02 PM
thank you for your answers I will study your recommendations