Discussion:
using ODBC to connect to Novell NDS
(too old to reply)
Don Castiglioni
2005-07-13 00:21:43 UTC
Permalink
I'm having trouble running a remote query against a Novell NDS table. I
downloaded the ODBC drivers from Novell.
The connection string seems to be OK but the SQLEXEC fails and says the
variable cur1 is not found. Am I doing something wrong?

lcConnStr = "Driver={Novell ODBC Driver for NDS};" ;
+ "DSN=NDS_CA;DBQ=NDS:\\TRAVIS\Travis\Granger\CA;"
nHandle = SQLSTRINGCONNECT(lcConnStr)

SelectStr = "SELECT workforceID FROM UserNDS "
= SQLEXEC(nHandle, SelectStr, cur1)
Fred Taylor
2005-07-13 01:06:06 UTC
Permalink
Is cur1 the variable that contains the name of your cursor, or the cursor
name itself? If it's the cursor name, you need quotation marks around it.

= SQLEXEC(nHandle, SelectStr, "cur1")
--
Fred
Microsoft Visual FoxPro MVP
Post by Don Castiglioni
I'm having trouble running a remote query against a Novell NDS table. I
downloaded the ODBC drivers from Novell.
The connection string seems to be OK but the SQLEXEC fails and says the
variable cur1 is not found. Am I doing something wrong?
lcConnStr = "Driver={Novell ODBC Driver for NDS};" ;
+ "DSN=NDS_CA;DBQ=NDS:\\TRAVIS\Travis\Granger\CA;"
nHandle = SQLSTRINGCONNECT(lcConnStr)
SelectStr = "SELECT workforceID FROM UserNDS "
= SQLEXEC(nHandle, SelectStr, cur1)
Don Castiglioni
2005-07-13 22:17:44 UTC
Permalink
Thank you, putting the quotations around it fixed my problem.
Post by Fred Taylor
Is cur1 the variable that contains the name of your cursor, or the cursor
name itself? If it's the cursor name, you need quotation marks around it.
= SQLEXEC(nHandle, SelectStr, "cur1")
--
Fred
Microsoft Visual FoxPro MVP
Post by Don Castiglioni
I'm having trouble running a remote query against a Novell NDS table. I
downloaded the ODBC drivers from Novell.
The connection string seems to be OK but the SQLEXEC fails and says the
variable cur1 is not found. Am I doing something wrong?
lcConnStr = "Driver={Novell ODBC Driver for NDS};" ;
+ "DSN=NDS_CA;DBQ=NDS:\\TRAVIS\Travis\Granger\CA;"
nHandle = SQLSTRINGCONNECT(lcConnStr)
SelectStr = "SELECT workforceID FROM UserNDS "
= SQLEXEC(nHandle, SelectStr, cur1)
Loading...