Pulling SQL Server data from Unix

How can I pull data from a MSSQL server in UNIX. Do I need an entry in
.odbc.ini, or other client tools to run a select on a table.
is this even possible
pls let me know
ThanksSee this old post.
7dc3ba3fd9e90c" target="_blank">http://groups.google.co.in/group/co...
7dc3ba3fd9e90c
Thanks
Hari
SQL Server MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:041F3647-E106-493A-8EDF-C0A2D83EEB87@.microsoft.com...
> How can I pull data from a MSSQL server in UNIX. Do I need an entry in
> .odbc.ini, or other client tools to run a select on a table.
> is this even possible
> pls let me know
> Thanks
>

Pulling SQL Server data from Unix

How can I pull data from a MSSQL server in UNIX. Do I need an entry in
.odbc.ini, or other client tools to run a select on a table.
is this even possible
pls let me know
ThanksSee this old post.
http://groups.google.co.in/group/comp.databases.ms-sqlserver/browse_thread/thread/218b790b3b3cffbf/5c7dc3ba3fd9e90c?q=accessing+sql+server+from+UNIX&rnum=1&hl=en#5c7dc3ba3fd9e90c
Thanks
Hari
SQL Server MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:041F3647-E106-493A-8EDF-C0A2D83EEB87@.microsoft.com...
> How can I pull data from a MSSQL server in UNIX. Do I need an entry in
> .odbc.ini, or other client tools to run a select on a table.
> is this even possible
> pls let me know
> Thanks
>

Pulling SQL Server data from Unix

How can I pull data from a MSSQL server in UNIX. Do I need an entry in
..odbc.ini, or other client tools to run a select on a table.
is this even possible
pls let me know
Thanks
See this old post.
http://groups.google.co.in/group/com...7dc3ba3fd9e90c
Thanks
Hari
SQL Server MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:041F3647-E106-493A-8EDF-C0A2D83EEB87@.microsoft.com...
> How can I pull data from a MSSQL server in UNIX. Do I need an entry in
> .odbc.ini, or other client tools to run a select on a table.
> is this even possible
> pls let me know
> Thanks
>

pulling multiple entry's with jscript

I am new to jscript and trying to learn how to pull multiple entry's from a table. I know with php you can use a while loop but that doesn't seem to work with jscript. Here is what I have so far.

var sSql = "select nIndex,sDescription from StatisticalDiskIdentification " +
"JOIN PivotStatisticalMonitorTypeToDevice ON " +
"StatisticalDiskIdentification.nPivotStatisticalMonitorTypeToDeviceID = " +
"PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID " +
"where (PivotStatisticalMonitorTypeToDevice.nStatisticalMonitorTypeID='2') and " +
"PivotStatisticalMonitorTypeToDevice.nDeviceID = " + nDeviceID;

while (oRs = oDb.Execute(sSql)){

if ( !oRs.EOF )
{
// Display various columns in the debug log (Event Viewer).
var sDisplay;
nIndex = "" + oRs("nIndex");
Context.LogMessage("nIndex=" + nIndex);
sDesc = "" + oRs("sDescription");
Context.LogMessage("Description =" + sDesc);
}
Context.SetResult( 0, " Ok");
oRs.MoveNext();
}

Thanks for any help

You should move Execute outside of the loop if your intention is to iterate through the recordset.
!oRs.EOF should be the loop condition instead.