Can you connect to a SQLServer database using the evaluation copy of DIAdem?

[GSantin]

I downloaded the evaluation copy of DIAdem. The data I want to analyze is in a SQLServer database. How can I setup a connection to this database? Does it require VB coding?

[Ferraro]

Hi GSantin

Connecting to a database in DIAdem does not require VB coding. To load data using the Data NAVIGATOR you need to do the following

1. Start DIAdem, make sure you are in the Data NAVIGATOR, top icon on left hand side.

2. Either press the icon labeled "Change data storage" or press CTRL-D on your key board. This brings up the data storage manager, where you can assign a connection to your SQL/ODBC compatible database.

3. Scroll down till you see SQL, double click on "New data storage" under the SQL section

4. Give the connection a name, i.e "Mydb"

5. You will now have to point your new db connection at the database, locate it using the browse button (button with 3 dots) then click ok

6. Your database should now appear in the Da
ta NAVIGATOR, and you should be able to drag and drop columns of data into the Data Portal.

DIAdem also has the ability to perform queries on your database however this does require some coding. We are in the process of putting together a fully functional example program that gives you query capability on databases without any programming. Keep your eye on the following web page

http://digital.ni.com/express.nsf/bycode/ex8wvc?opendocument〈=&node=

Hope this helps
Let me know if this works for you

Tom Ferraro
DIAdem Product Manager
512-683-6841

[GSantin]

Hi Tom,

My problem when I get to the dialog "Properties of the SQL" is that the selection does not include SQLServer. The options are MS Access (OLE DB)
MS Access (ODBC)
Oracle (OLE DB Oracle)
Oracle (OLE DB MS)
Oracle (ODBC)
ADO Connection String
The database that I want to connect to is SQLServer.
I don't believe it is contained in a file as the others are.
Is there a way to connect to an SQLServer Database?

Thanks for the help.
Gloria Santin

[Ferraro]

Hi Gloria

You can connect to SQL Server DB using the ADO connection string selection.

You will be required to create a connection string, if you are not familiar with this, the easiest way to create and verify a connection string is to right-click your desktop and select New->Microsoft Data Link. This brings up a pretty straightforward dilaog for configuring your database connection (including a connection test). After that, the "data link" is on your desktop as a text file. Open the file and copy-paste the connection string.

An excellent resource for connection strings is this webpage: http://www.able-consulting.com/tech.htm.

Let me know how it works

Tom

[GSantin]

Hi Tom,

My Desktop does not have Microsoft Data Link. I have a Windows2000 OS. Could give me an example of the connection string and using the Data Source(ODBC) utility in the Administrative Tools maybe I can create one?

Thanks,
Gloria

[Herbert Engels]

Gloria,
the attached VBS script puts up the WINDOWS dialog that creates the connection string. It then writes the string to a file and displays it in the DIAdem SCRIPT editor (if running in DIAdem). I tested on XP but it should run on 2000 just the same.
Hope that helps,
Herbert