Create an ODBC Driver

[mohfa]

< i'm very sorry to write in english , why in this forum : cause i have been told to post my question here in delphipraxis forum >. sorry again .

Hi every body , i have finished programming my DBMS ( a BDE replacment with my propre Table , Query , Database ) , my DBMS
uses SQL 92 .

so i want to create - write - my DBMS Driver.
i have been told to convert my DBMS pas files into C or C++ then use MVC++ to create this ODBC Driver.

could you please help me to create this ODBC Driver using Delphi .

I really need your help.

michy

[Bernhard Geyer]

Why do you want to create in 2007 a ODBC-Driver?

If I use .NET i want a native ADO.NET Provider, if I use Delphi (Win32) I would like to see native TDataset-Components. No Installation of ODBC-Driver and no setup of ODBC-Entry. And for Win64 - there is no ODBC any more.

[mohfa]

yes sir of course , But i was asked by 2 of my customers to give them an odbc driver for my DBMS .

really i need all ur help


regards michy

[mohfa]

please is there any help.

[shmia]

Do you know microsoft's ODBC documentation ?
http://msdn2.microsoft.com/en-us/library/ms709326.aspx
You need several weeks to fully understand how to write a ODBC driver.
You have to implement about 15 to 25 functions in your ODBC DLL.

[mohfa]

Zitat von shmia:

Do you know microsoft's ODBC documentation ?
http://msdn2.microsoft.com/en-us/library/ms709326.aspx
You need several weeks to fully understand how to write a ODBC driver.
You have to implement about 15 to 25 functions in your ODBC DLL.

yes sir , that's what i did the problem is with the DLL Exported Functions especiqlly with ConfigDriver and ConfigDSN functions.
so what i did :
i imlemented a unit named ODBCConst : where i declared all the Functions and this is a simple of the Unite :

Delphi-Quellcode:

function SQLAllocConnect(henv :Longint;var phdbc :Longint): Integer;
   stdcall;
function SQLAllocEnv(var phenv :Longint): Integer;
   stdcall;
function SQLAllocStmt(hdbc :Longint;var phstmt :Longint): Integer;
   stdcall;
function SQLBindCol(hstmt :Longint;icol :Word; fCType :Smallint;
   var rgbValue ;cbValueMax :Longint;var pcbValue): Integer;
   stdcall;
function SQLBindParameter(StatementHandle :Longint; ParameterNumber :Word;
   InputOutputType :Smallint; ValueType :Smallint;
   ParameterType :Smallint;
   ColumnSize :Longint; DecimalDigits :Smallint;
      ParameterValuePtr : Pointer;
   BufferLength :Longint;
      StrLen_or_IndPtr : Pointer
      ): Integer;
   stdcall;
function SQLConfigDriver(
  hwndParent: HWND;
  fRequest: WORD;
  lpszDriver: LPCSTR;
  lpszArgs: LPCSTR;
  lpszMsg: LPSTR;
  cbMsgMax: WORD;
  var pcbMsgOut: WORD): BOOL; stdcall; 
 function ConfigDSN(
  hwndParent: HWND;
  fRequest: WORD;
  lpszDriver: LPCSTR;
  lpszAttributes: LPCSTR): BOOL; stdcall; 
.....

ok as you see i have declared the functions SQLConfigDriver , and ConfigDSN
i export these 2 functions from the DLL File ( the ODBC Driver ), and i use a form to config the DSN the Driver is installed in the ODBC manager but the Result is so is there any thing wrong here
.

if you want i can send you my ODBC Driver and you can see or help . ,any thanks

if possible could you please send me an exe,ple of an ODBC Driver .

Regards MICHY

[Union]

Therer is an PostGres driver availabe under http://www.postgresql.org/ftp/odbc/versions/src/

[mkinzler]

Same for FireBird: http://sourceforge.net/project/showf...kage_id=119024

[mohfa]

Zitat von Union:

Therer is an PostGres driver availabe under http://www.postgresql.org/ftp/odbc/versions/src/

many thanks Union but this driver is written in C language and that's what i was asked to do : convert your Pas file into C then creating your ODBC Driver will be as easy as you think.

[mohfa]

i'm really still for someone to help me .