How to link my access database to ODBC?

[karpaga]

-2147217900

[karpaga]

-2147217900

[karpaga]

Hi mike,

I tried to rename a table 'data' to 'Names'  using the vi attached .

It results with an error -2147217900

[MikeS81]

Hi kavi,

is it a new "problem"? Can you now create your mdb file within LabVIEW.

Mike

Message Edited by MikeS81 on 07-01-2009 01:09 PM

[karpaga]

s mike.I cant do it.

[MikeS81]

---

karpaga wrote:

Hi mike,

I tried to rename a table 'data' to 'Names'  using the vi attached .

It results with an error -2147217900

---

Hi kavi,

you have to use a SELECT and a DROP command, because Access has no rename command.

See the attached image.

Mike

[karpaga]

Thanks a lot now i can create mdb and open connection .its working!

[karpaga]

I can rename a table.Thanku mike

[srinivasan.accent@gmail.com]

hi,

 im new to labview.. now i have a problem in creating a database.. im using labviw 7.0... so for creating database i download labsql toolkit... and database toolkit..  i know some basic command in sql.. so i used labsql... but what is the problem is i dont know to use that toolkit in labview 7.0.. by seeing thread i knew  'll get answer for my problem..

my project is to check the pins pcb.. for example consisder 4 pins .. im applying sine,traingular,sawtooth and square for the 4 pins.. now i want to store the output pin in database for the further process.. can u help me...

[srinivasan.accent@gmail.com]

hi,

 i created .mdb file  and i connect with System DSN...i want to know that whether u used labsql or database tookit.... 

i attached the format of the table should be saved in database.........