Solved

ODBC interbase

Posted on 2002-05-08
19
16,335 Views
Last Modified: 2013-12-09
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
Comment
Question by:mrk_raj
  • 5
  • 3
  • 2
  • +6
19 Comments
 

Author Comment

by:mrk_raj
ID: 7005128
please     help me
0
 
LVL 4

Assisted Solution

by:anzen
anzen earned 100 total points
ID: 7006662

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
 
LVL 4

Accepted Solution

by:
YodaMage earned 100 total points
ID: 7006788
0
 
LVL 1

Expert Comment

by:thegroup
ID: 7027947
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
 
LVL 1

Expert Comment

by:Moondancer
ID: 7096335
Please update and finalize this question.  Experts, if no response in 7 days, please provide me with closing recommendations.
Thanks,
Moondancer - EE Moderator
0
 
LVL 4

Expert Comment

by:YodaMage
ID: 7096369
This could be Anzen...hell, I already got paid once for the link I posted here, give it to to Anzen.
0
 

Expert Comment

by:saini
ID: 7177468
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
 

Expert Comment

by:modulo
ID: 7426594
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 4

Expert Comment

by:YodaMage
ID: 7434280
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
 

Expert Comment

by:modulo
ID: 7434317
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
 
LVL 10

Expert Comment

by:kacor
ID: 9824436

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
 

Expert Comment

by:accarvajal
ID: 10337061
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
 
LVL 10

Expert Comment

by:kacor
ID: 10337295
Hi accarvajal,

please ask it in a new question

with best regards
Janos
0
 

Expert Comment

by:accarvajal
ID: 10344139
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
 
LVL 10

Expert Comment

by:kacor
ID: 10344289
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
 
LVL 10

Expert Comment

by:kacor
ID: 10344319
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
 
LVL 10

Expert Comment

by:kacor
ID: 10344396
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now