#1  
Old 20th February 2018, 10:06 PM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default Parameters in excel

When trying to add parameters in Excel, I get the following error

SQLDescribeParam not supported

is there a way to add parameters to excel queries?
  #2  
Old 5th March 2018, 12:19 PM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default

Hi, I"m not able to progress my project without a response to this? Any updates on how parameters work when connecting through excel?
  #3  
Old 5th March 2018, 04:44 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Parameters in excel

bluephlame wrote:

>
> Hi, I"m not able to progress my project without a response to this? Any
> updates on how parameters work when connecting through excel?


Hi,

sorry, overlooked the message in this NG. Technically the NGs are "peer-to-peer
support" and answered are only guaranteed for emails to the support@nexusdb.com
address.

What version of the ODBC driver are you using?

Looking at the source, it should not return "SQLDescribeParam not supported" in
the current version:

function SQLDescribeParam(hstmt: SQLHSTMT;
ipar: SQLUSMALLINT;
pfSqlType: pSQLSMALLINT;
pcbParamDef: pSQLULEN;
pibScale: pSQLSMALLINT;
pfNullable: pSQLSMALLINT): SQLRETURN cdecl stdcall;
begin
try
if pfSqlType <> nil then
pfSqlType^ := SQL_Char;
if pcbParamDef <> nil then
pcbParamDef^ := 255;
if pibScale <> nil then
pibScale^ := 0;
if pfNullable <> nil then
pfNullable^ := SQL_NULLABLE_UNKNOWN;
result := ODBCSetSQLSUCCESS;
except
on E: Exception do begin
Result := ODBCTriggerError(e);
end;
end;
end;
  #4  
Old 5th March 2018, 08:13 PM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default

I version 2 and 3.1 installed.

Version 2 is the one that connects to the data source (version 3 does not connect)
  #5  
Old 13th March 2018, 11:13 AM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Parameters in excel

bluephlame wrote:

>
> I version 2 and 3.1 installed.
>
> Version 2 is the one that connects to the data source (version 3 does
> not connect)


The required funcionallity was not yet available in v2 (which hasn't been sold
for 12 years now).

There are no plans to produce an updated v2 odbc driver.

If the v3 odbc driver can't connect, then there is either a configuration
problem or you are running an ancient NexusDB server.

Kind Regards,
Thorsten
  #6  
Old 13th March 2018, 12:22 PM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default

How can I determine what the database version is?

Looking at it from Task Manager the File version of nxServer.exe is 2.0.8.4 but this is often not related to the actual product version.

The product has shipped with Nexus DB enterprise Manager 2.0804 Release D11 and ODBC driver 201

How can I check the configuration of the server?


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use with Access or Excel Ken Randall nexusdb.public.support.odbc 3 4th May 2015 05:42 PM
ODBC Driver and Excel Bernhard Roos nexusdb.public.support 1 17th April 2013 06:59 PM
accessing data from Excel Dalles Campanati nexusdb.public.support 2 12th January 2008 01:48 AM
OT - Excel OLE help Harold.legg nexusdb.public.discussions 2 26th June 2005 01:42 AM
OT - Excel import to NexusDB Srinivasan Iyer nexusdb.public.discussions 3 12th December 2003 01:58 PM


All times are GMT +11. The time now is 12:09 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.