• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 16446
  • Last Modified:

ODBC interbase

Hi all,
I want to connect an internase database using an ODBC DSN.
i'm creating the DSN file using call for the ODBCCP32.DLL
but wen i try to connect following error occurs

i'm using
          ODBC- 3.520.4403.2
          INTERSOLV interbase driver 3.11.01.00

ConfigDataSource(0, 4, PChar('INTERSOLV InterBase ODBC Driver (*.gdb),  
PChar('DSN=tst, DRIVER=C:\WINDOWS\SYSTEM\IBINT13.DLL,
DATABASE ='c:\test.gdb',
LOGONID=SYSDBA));


when i try to connect
got the error message

DIAG [S1C00] [INTERSOLV][ODBC InterBase driver]Optional feature not implemented. (0)

Can u please tell me wat is the optional paramaeter required and wat could be the values for those paramaeter

do i need to specify Translation, Charater set etc...

plese help me

regards

Raj
0
mrk_raj
Asked:
mrk_raj
  • 5
  • 3
  • 2
  • +6
2 Solutions
 
mrk_rajAuthor Commented:
please     help me
0
 
anzenCommented:

Which ODBC driver are you using ?

You could consider trying one of
the drivers listed here:

http://www.cvalde.com/misc/packages_and_utilities.htm



0
 
YodaMageCommented:
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
thegroupCommented:
Many drivers doesn't support new Dialect 3 datatypes, maybe this is your problem.

The database you are connected to is Interbase 6 o Interbase 5 or 5.5 ?

Interbase 6 uses Dialect 3, 2, 1
Interbase 5.5 uses Dialect 2,1
Inetrbase 5 uses Dialect 1
0
 
MoondancerCommented:
Please update and finalize this question.  Experts, if no response in 7 days, please provide me with closing recommendations.
Thanks,
Moondancer - EE Moderator
0
 
YodaMageCommented:
This could be Anzen...hell, I already got paid once for the link I posted here, give it to to Anzen.
0
 
sainiCommented:
I am using same ODBC driver and it is working fine.i am using registry to create ODBC DSN below is the code

procedure CreateDSN;
var
        DSNPath: String;
        DBPath: string;
        Driver: String;
        Reg: TRegistry;
        UID: String;
        PWD: STring;
        Tempstr:String;
        i:integer;
        winpath : Pchar;
begin
     if length(edDBPath.text)=0 then
         MessageBox(Handle,'Enter valid DB Location for the Reports.','Warning',MB_OK + MB_ICONEXCLAMATION)
     else
     begin
        DSNPath:='SOFTWARE\ODBC\ODBC.INI\TestDSN';
        Tempstr:=trim(eddbpath.text);
        if copy(Tempstr,1,1)='\' then
        begin
           i:=3;
           while (copy(Tempstr,i,1)<>'\')
           do
             i:=i+1;
             i:=i+1;
             while (copy(Tempstr,i,1)<>'\')
             do
               i:=i+1;
               Tempstr:=copy(Tempstr,0,i-1) + ':' + copy(Tempstr,i,length(Tempstr) - (i-1));
        end;
        dbpath:=Tempstr;
        GetMem(winpath,1024);
        GetSystemDirectoryA(winpath,1024);
        Driver:= winpath + '\INIBT13.DLL';
        Freemem(winpath);
        UID:='sysdba';
        PWD:='masterkey';
        reg:=TRegistry.create;
        Reg.RootKey:=HKey_Local_Machine;
        Reg.CreateKey(dsnPath);
        if reg.openkey(dsnpath,true) then
        begin
            Reg.writestring('Database',dbpath);
            Reg.writestring('Description','');
            Reg.writestring('driver',Driver);
            Reg.writestring('lastuser',UID);
            Reg.writestring('server',PWD);
            Reg.CloseKey;
            Reg.createkey('SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources');
            if reg.openkey('SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources',true) then
            begin
               Reg.writestring('TestDSN','INTERSOLV Interbase ODBC Driver (*.gdb)');
               Reg.CloseKey;
               Reg.free;
            end;
        end;
        FDbpath := Trim(Tempstr);
        close;
     end;//if length(edDBPath.text)=0 then
end;
0
 
moduloCommented:
Dear: saini

I've rejected your proposed answer as Experts Exchange holds an experiment to work without the answer button.

See:        http://www.experts-exchange.com/jsp/communityNews.jsp
Paragraph: Site Update for Wednesday, November 06, 2002

By this rejection the Asker will be notified by mail and hopefully he will take his responsibility to finalize the question or post an additional comment.
The Asker sees a button beside every post which says "Accept This Comment As Answer" (including rejected answers) -- so if he/she thinks yours is the best, you'll be awarded the points and the grade.

Thanks !

modulo

Community Support Moderator
Experts Exchange
0
 
YodaMageCommented:
Experts Exchange is moving forward with an idea to leave open question about for years, for this reason we like to be sure any proposed answerers are rejected by a moderator so that this question is sure to bog up the works and be right in the way.

>:-P
0
 
moduloCommented:
I partially agree YodaMage, just hope the Asker reacts on the three email notif's, otherwise we'll have to wait for a cleanup expert to propose the way the Q can be finalized....
We don't have one yet for this TA :(
But we're trying to get this in place!

The main TA Databases and Access are covered and also some others (check the link in Q: http://www.experts-exchange.com/Community_Support/CleanUp/Q_20319784.html)
Perhaps interested ?

modulo

Community Support Moderator
Experts Exchange
0
 
kacorretiredCommented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
       to split points as follows:  100 points for anzen
                                             100 points for YodaMage
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

kacor
EE Cleanup Volunteer
0
 
accarvajalCommented:
hi all!

I'm testing interbase 6 using gemini ODBC conectivity, and Visual C++. I use stored procedures, but when i call a specific non-return values stored procerdure, ODBC shows me an error: state: HY000, native = -84, procedure xxxxx does not return any values. In fact, such procedure does not return any values, because i don't need it. So, why the error?


thanks


Aldemar
0
 
kacorretiredCommented:
Hi accarvajal,

please ask it in a new question

with best regards
Janos
0
 
accarvajalCommented:
Hi!,

I'm using interbase 6 using gemini ODBC 2.0 driver

The procedure where i'm trying to execute just has input parameters for an INSERT instruction. The ODBC
backs me and error: "Dynamic SQL error. state:HY000, native = -84, procedure xxxxx does not return any
values".

I use "{call xxxxx(?,?,?,?,..)}" as sintax and SQLBindParameter for sending parameters to the stored procedure, and then SQLExecDirect.

So, It's imperative that i have to return values?

By the way!, I have another question:

If i'm using "{call xxxxx(?,?,?,?,..)}" as sintax and SQLBindParameter for sending parameters to the stored
procedure, and i need to return 1 or 2 values from stored procedure to the program, where do i have to put the marks (?) in the sintax call which receive the data?.

Example:


CREATE PROCEDURE MY_PROCEDURE (PARAM1 INTEGER, PARAM2 CHAR(2))
RETURNS (PARAM_OUTPUT INTEGER)  <------- "here's output parameter i need recover"
AS
BEGIN
      ...
END

So, how must i construct the sintax call?

{call my_procedure(?,?,?)} ---> the last '?' would be the return parameter?

Or

{call my_procedure(?,?,?)} ---> the first '?' would be the return parameter?

I'd appreciate your help

Aldemar
0
 
kacorretiredCommented:
Hi Aldemar,
Step 1.
please go to the InterBase topic:  http://www.experts-exchange.com/Databases/Interbase
then in the left side you'll find a panel containing: Ask a question, klick on

appears a new window

Step 2.
You place a short description of your question  in the field Question Title

Step 3.
In the Question Body you can write your question detailled (you can copy your question above and insert into this big field

Step 4.
Assign a difficulty e.g. give a Question Point Value  

So the experts answering yourquestion can get points for supporting you.

with best regard
Janos
0
 
kacorretiredCommented:
I forgot to tell you: this is a closed (accepted) question and the experts will not look at.this. So please place a new question

Janos
0
 
kacorretiredCommented:
An other remark: please divide your above question into 2 separate questions:
in the first ask your ODBC problem
in the second ask your stored procedure problem

wbr Janos
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 5
  • 3
  • 2
  • +6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now