Help
hi all,
I want to access database on one PC(let’s consider A ) from remote PC (let’s consider B ) in LabView. I am using Mysql 5.1 with ODBC 5.1.
On B mysql 5.1 is configured as server while on A it is configured as development machine.
On both A and B, we have checked with command prompt. With command prompt it is working fine but when I tried to make UDL file (to access database in lab view) it is showing error as connection Failed.
And also please let us know setting about how to configure mysql as a server for particular database in “MySQLInstanceConfig.exe””
And similarly for client to access server database.
And guide also for software selection that we are using i.e. Mysql server 5.1 and connector/ODBC
Please send me correct procedure to make server client connection.
pravin
Page 1 of 1
Mysql 5.1 server and MyODBC5.1 Connection Problem
Rate Topic:
Back to top
MultiQuote
#2
- The 500 club
-
- Group: Premium Member
- Posts: 971
- Joined: 01-January 08
- Location:Australia
- Version:LabVIEW 2009
- Since:2005
Posted 06 February 2010 - 07:36 AM
pravin, on 05 February 2010 - 06:19 PM, said:
hi all,
I want to access database on one PC(let’s consider A ) from remote PC (let’s consider B ) in LabView. I am using Mysql 5.1 with ODBC 5.1.
On B mysql 5.1 is configured as server while on A it is configured as development machine.
On both A and B, we have checked with command prompt. With command prompt it is working fine but when I tried to make UDL file (to access database in lab view) it is showing error as connection Failed.
And also please let us know setting about how to configure mysql as a server for particular database in “MySQLInstanceConfig.exe””
And similarly for client to access server database.
And guide also for software selection that we are using i.e. Mysql server 5.1 and connector/ODBC
Please send me correct procedure to make server client connection.
pravin
I want to access database on one PC(let’s consider A ) from remote PC (let’s consider B ) in LabView. I am using Mysql 5.1 with ODBC 5.1.
On B mysql 5.1 is configured as server while on A it is configured as development machine.
On both A and B, we have checked with command prompt. With command prompt it is working fine but when I tried to make UDL file (to access database in lab view) it is showing error as connection Failed.
And also please let us know setting about how to configure mysql as a server for particular database in “MySQLInstanceConfig.exe””
And similarly for client to access server database.
And guide also for software selection that we are using i.e. Mysql server 5.1 and connector/ODBC
Please send me correct procedure to make server client connection.
pravin
Hi Pravin
Attached is a protocols (how-to) document I wrote for my library on the subject, hope it helps.
LabVIEW - Connect to mySQL.pdf (683.54K)
Number of downloads: 372
Check out my stuff!
--------------------
LAVA CR: LVOOP Theme Creator (Quick Drop Plugin), Rename LVOOP FP Object Labels (Quick Drop Plugin), Icons
Other: IE 2009 Update (Fix), Apply Icon To VIs Button (Fix), Icon Editor API (Repack), LVOOP Custom User Scripting Hooks, Application Build Script
Idea Exchange: Sending Packages (.opg, .vip, .vipc files) to NI Support is an acceptable way to Submit Code, Expose all available LabVIEW Project Methods via VI Server/Scripting, Expose "Replace With" LabVIEW Project Method via VI Sever/Scripting, Allow X-Control/X-Control Reference as a Class Data Member, Display Qualified Name in Inheritance Dialog Box for LabVIEW Classes, X-Control Display Icon (so an .xctl looks good in the Palettes), Show X-Control in User.lib Auto Generated Control Palette, Icon Editor API, Make Quick Drop Shortcuts (plugins) Available for LabVIEW Project Items, LVOOP Custom User Dynamic Dispatch and Static Dispatch Hooks, Public Folder for Icon Templates in new Icon Editor
--------------------
All day... / Pay It Forward
--------------------
LAVA CR: LVOOP Theme Creator (Quick Drop Plugin), Rename LVOOP FP Object Labels (Quick Drop Plugin), Icons
Other: IE 2009 Update (Fix), Apply Icon To VIs Button (Fix), Icon Editor API (Repack), LVOOP Custom User Scripting Hooks, Application Build Script
Idea Exchange: Sending Packages (.opg, .vip, .vipc files) to NI Support is an acceptable way to Submit Code, Expose all available LabVIEW Project Methods via VI Server/Scripting, Expose "Replace With" LabVIEW Project Method via VI Sever/Scripting, Allow X-Control/X-Control Reference as a Class Data Member, Display Qualified Name in Inheritance Dialog Box for LabVIEW Classes, X-Control Display Icon (so an .xctl looks good in the Palettes), Show X-Control in User.lib Auto Generated Control Palette, Icon Editor API, Make Quick Drop Shortcuts (plugins) Available for LabVIEW Project Items, LVOOP Custom User Dynamic Dispatch and Static Dispatch Hooks, Public Folder for Icon Templates in new Icon Editor
--------------------
All day... / Pay It Forward
Share this topic:
Page 1 of 1