Can I transfer data from lookout to microsoft sql server 2005/2008?

[Mike@Forshock]

Robert,

It is on an SQL server what you are wanting to do is view it.  What program are you wanting to use the data in?  Access and Excel can be used to generate reports with an ODBC connection.

Mike

[RobertGuirguis]

What I want to do is import a value say logger1 into sql server database the same way as in excel. Like, I want to use sql server management studio for viewing data as an example.

[Ryan.S]

Robert,

MS SQL Server, My SQL or Access all support the standard SQL statement. The example Mike gave you uses the SQLExec object to execute the "insert" SQL statement to insert the data to other database through the ODBC driver.

Do you really want to insert the data into the SQL Server? or you just want to view the Citadel database data from other software?

There is the "National Instruments Citadel 5 Database" data source after you install the Citadel on the computer. Use this ODBC driver to create the data source. And use this data source in other SQL software to connect the database.

Have you set up the data source successfully? After you create the data source and you can click "Test Connection" to test the connection.

[RobertGuirguis]

Hi,

I want to import the citadel 5 database into sql server and view that data. So I need to use the import/export wizard to import that database. Any idea on how to do that? 

Robert

[Mike@Forshock]

Robert,

If you want only to view the data that can be done with SQL and the Citadel 5 ODBC.  The is no simple import for the database; Citadel 5 is a layer on top the MS SQL database that manages the data.

Mike

[RobertGuirguis]

I found out that sql server and filemaker for example have an import and export wizard that imports the data from an odbc source. Now, the problem I have now is that I can't see the citadel 5 database in the odbc administrator. When I try to add it, it does not appear in the list. Could that be because I am on windows server? Thanks

Robert

[Mike@Forshock]

Please list all the connections in the System DSN area of the ODBC Manager.

Mike

[RobertGuirguis]

Mike,

All I have on the list when I click add is:

1.MySQL odbc 5.1 driver

2.SQL native client

3.SQL server

[Mike@Forshock]

Robert,

What version of Windows Server are you running?  I have used 2008 without issue.

From what it seems their are ODBC drivers missing/not installed in order to access the database.  NI support may be the only ones to help from here.

Mike

[RobertGuirguis]

I'm using windows server 2008, but I'm not the administrator. Meaning, that I'm not allowed to install anything..