LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Edit a particular element in a data base table

Solved!
Go to solution

Mike the acces file i created is an mdb file but give the the extension as mdb.udl.why?

 

 

kavi
0 Kudos
Message 11 of 52
(1,271 Views)
Mike the access file i need to update is an mdb but u gave the file extension as mdb.udl.why?
kavi
0 Kudos
Message 12 of 52
(1,268 Views)

Hi kavi,

i use an udl file to connect to the database (i use also a mdb file).

The only thing you need to change is to set the "Marks value" into quotation marks.

 

See this link for more information about udl.

 

Mike

Message Edited by MikeS81 on 06-25-2009 01:40 PM
0 Kudos
Message 13 of 52
(1,259 Views)
Mike reply me pls
kavi
0 Kudos
Message 14 of 52
(1,254 Views)

Mark has already replies to your question as

The only thing you need to change is to set the "Marks value" into quotation marks.

 

Try this out and check what result you are getting.

0 Kudos
Message 15 of 52
(1,250 Views)

I tried with it with mdb.udl extension and Marks with in Quatation  gives an error

 

Error -2147287038 occurred at NI_Database_API.lvlib:DB Tools Open Connec (String).vi->NI_Database_API.lvlib:DB Tools Open Connec (Path).vi->Database_Example_Update_LV85(2).vi

 

 

 I have not created UDL just i create create system dsn for my access file.

 

 

Wat to do now?

kavi
0 Kudos
Message 16 of 52
(1,243 Views)

DSN file is sufficient to make the connection.

 

try the query with your dsn connection.

0 Kudos
Message 17 of 52
(1,239 Views)

Hi Kavi,

have you ever had a connection to your database?

If you don't get an error from your "OPen Database" vi, then use your posted example, but put the 101 into quotation marks.

 

If you also need to create a connection to your database, then this link should help.

http://decibel.ni.com/content/docs/DOC-4602

 

You also can create a *.udl file and double click it. Select "Microsoft Jet... Provider" as provider. Change to the next tab and select your mdb file. Check the connection and close the window (use ok for it). After that you can use your udl file as connection information on the "DB Tools Open Connection.vi".

 

Mike

0 Kudos
Message 18 of 52
(1,235 Views)
reply me
kavi
0 Kudos
Message 19 of 52
(1,234 Views)

I dont get an error from the vi i already send to u.I also Put the Mark values inside the Quotations still im getting error from

 

 

 DB TOOLS Execute Queries

 

Error -2147217904 occurred at NI_Database_API.lvlib:Conn Execute.vi->Database_Example_Update_LV85(2).vi

Possible reason(s):
.  Invalid string: specified field does not exist or contains an unsupported character

kavi
0 Kudos
Message 20 of 52
(1,230 Views)