#1  
Old 20th February 2018, 11: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, 01: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, 05: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, 09: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, 12:13 PM
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, 01: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?
  #7  
Old 13th March 2018, 06:29 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Parameters in excel

bluephlame wrote:

>
> 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?


That is indeed the version of the server, and it is a version that has been
superceeded in 2006.
  #8  
Old 15th March 2018, 05:49 PM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default

So no known workaround?

I cant upgrade the database as I don't control it, it's part of a 3rd party app.
  #9  
Old 15th March 2018, 07:11 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Parameters in excel

The functionallity to support parameters was not yet implemented in the version
2 ODBC drivers.

And before version 3, clients were only compatible with a server with the same
major version number.

Both these limitations have been removed with the introduction of version 3,
*12 years ago*.

bluephlame wrote:

>
> So no known workaround?
>
> I cant upgrade the database as I don't control it, it's part of a 3rd
> party app.


  #10  
Old 15th March 2018, 09:01 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Parameters in excel

> So no known workaround?

You won't get live updates, but you can get access to a copy of the
data in a newer version. For test, you can use the "Live backup"
function in the v2 Enterprise Manager (turn on the "keep indices"
checkbox), and copy to an alias on a v3 or v4 nxServer that you set up.
You can then access the data from this server via the newer ODBC driver.

--
Eivind Bakkestuen [NDD]


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 06:42 PM
ODBC Driver and Excel Bernhard Roos nexusdb.public.support 1 17th April 2013 07:59 PM
accessing data from Excel Dalles Campanati nexusdb.public.support 2 12th January 2008 02:48 AM
OT - Excel OLE help Harold.legg nexusdb.public.discussions 2 26th June 2005 02:42 AM
OT - Excel import to NexusDB Srinivasan Iyer nexusdb.public.discussions 3 12th December 2003 02:58 PM


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


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