How do i connect to a remote SQL database

[GokulGKM]

hi,

     How do i connect to a remote SQL database using labview,ODBC and the db connectivity toolset.

[Yamaeda]

1. Set up ODBC to the correct address and make sure Test connection works.

2. Use the configured ODBC name with Open Database.

/Y

[Ranjeet_Singh]

UDL is best option.

[NIquist]

There are step by step instructions right in the manual (below).  Basically you can set up an ODBC connection on your PC and use its name when you open a connection OR you can send a full connection string right to the DB Tools Open Connection VI.  Either way you'll probably need permissions set up by whoever is administering the server (assuming the database is secured).

http://sine.ni.com/psp/app/doc/p/id/psp-360/lang/en

[Yamaeda]

---

@Ranjeet_Singh wrote:

UDL is best option.

---

I agree, UDL is better, but that was not the question. 😉

/Y

[Ranjeet_Singh]

---

@Yamaeda wrote:

---

@Ranjeet_Singh wrote:

UDL is best option.

---

I agree, UDL is better, but that was not the question. 😉

/Y

---

why not? For connecting to remote database, we can use the UDL

[GokulGKM]

yes i tried UDL it work .but i may about how to connect through  ODBC.

[Ranjeet_Singh]

Yes there are other ways but advantage is whenever required, we can change the connection string. Hence we dont need to hardcode it