Download link to the ODBC32 headers I've converted to D, which include sql.d, sqlext.d, sqltypes.d, sqlucode.d, and one example (sqltest.d); been working on these babys for a month.

http://spottedtiger.tripod.com/D_Language/D_Support_Projects_XP.html

David L.

-------------------------------------------------------------------
"Dare to reach for the Stars...Dare to Dream, Build, and Achieve!"

David L. Davis wrote:
> Download link to the ODBC32 headers I've converted to D, which include sql.d,
> sqlext.d, sqltypes.d, sqlucode.d, and one example (sqltest.d); been working on
> these babys for a month.
> 
> http://spottedtiger.tripod.com/D_Language/D_Support_Projects_XP.html
> 
> David L.
> 
> -------------------------------------------------------------------
> "Dare to reach for the Stars...Dare to Dream, Build, and Achieve!"

Sounds great!

I added this to: http://www.prowiki.org/wiki4d/wiki.cgi?DatabaseBindings

-- 
Justin (a/k/a jcc7)
http://jcc_7.tripod.com/d/

In article <cfk8f4$1pfl$1@digitaldaemon.com>, J C Calvarese says...
>
>David L. Davis wrote:
>> Download link to the ODBC32 headers I've converted to D, which include sql.d, sqlext.d, sqltypes.d, sqlucode.d, and one example (sqltest.d); been working on these babys for a month.
>> 
>> http://spottedtiger.tripod.com/D_Language/D_Support_Projects_XP.html
>> 
>> David L.
>> 
>> -------------------------------------------------------------------
>> "Dare to reach for the Stars...Dare to Dream, Build, and Achieve!"
>
>Sounds great!
>
>I added this to: http://www.prowiki.org/wiki4d/wiki.cgi?DatabaseBindings
>
>-- 
>Justin (a/k/a jcc7)
>http://jcc_7.tripod.com/d/

J C Calvarese: Thxs! It's nice to see that I have some support within this news
group. :))

-------------------------------------------------------------------
"Dare to reach for the Stars...Dare to Dream, Build, and Achieve!"

David L. Davis wrote:
> Download link to the ODBC32 headers I've converted to D, which include sql.d,
> sqlext.d, sqltypes.d, sqlucode.d, and one example (sqltest.d); been working on
> these babys for a month.
> 
> http://spottedtiger.tripod.com/D_Language/D_Support_Projects_XP.html
> 
> David L.
> 
> -------------------------------------------------------------------
> "Dare to reach for the Stars...Dare to Dream, Build, and Achieve!"

Okay, I've gotten around to looking at the ODBC32 headers. It looks good and complete, but there are some rough edges that I think need fixing.


First off, I don't think you put your latest files in the archive you uploaded. The files didn't compile for me without some changes.

Specifically:

I think line 225 of sqlucode should be:
  SQLRETURN SQLSetConnectOptionW
instead of:
  SQLRETURN SQL_API SQLSetConnectOptionW

sqlucode.d(28): identifier 'SQLRETURN' is not defined
Add "import std.c.windows.sqltypes;" to line 10 of sqlucode.d.

I think I had to make another change, too, but I forgot to record it. In any case, I assume you've already fixed these problem, but accidently uploaded the old versions.


Another issue is I think it's inconvenient to place some of the code in etc\c\windows and some of it in std\c\windows. Just put it all in etc\c\windows. If Walter wants to add it to Phobos, then it can all change to std\c\windows. I re-install DMD pretty often (usually whenever a new version is available) and I'd likely forget and delete the sql stuff along with everything else.


Also, it'd be easier for people to use if the directory structure is saved in the .zip file.


It'd be handy for the user if you'd include a batch file or makefile that compiles the code. Here's something I set up for the current module structure:

[build.bat]
@echo off

echo Compiling std.c.windows.sql*...
cd std\c\windows
dmd sql.d sqlext.d sqltypes.d sqlucode.d -c -I..\..\..
lib.exe -c ..\..\..\std_c_win_sql.lib sql.obj sqlext.obj sqltypes.obj sqlucode.obj
cd ..\..\..

echo Compiling etc.c.windows.odbc32dll...
cd etc\c\windows
dmd odbc32dll.d -c -I..\..\..
rem lib.exe -c ..\..\..\etc_c_win_odbc.lib odbc32dll.obj
cd ..\..\..

dmd sqltest.d etc\c\windows\odbc32dll.obj std_c_win_sql.lib
sqltest.exe
pause


It shouldn't be necessary to add an entry in the ODBC Manager to access an .mdb file. I think it's called a "DNSless connection". I've done it before, but it's been a while. I'll try to add that capability to your test program to show you what I mean, but I haven't done it yet.


Also, it'd be nice if the path to the odbc32.dll didn't have to be embedded in the file. That should be possible by using implib, but I realize that not everyone likes implib. At the very least, the program could guess better at where it is by looking for a registry entry or an environment setting. Not everyone has the .dll located at "C:\windows\system32\odbc32.dll". For example mine is at "H:\windows\system32\odbc32.dll". Also, Window9X users probably have it at "C:\windows\system\odbc32.dll".


I hope my criticisms don't come off as harsh. They're meant to be contructive. I tend to be most critical with things that I'm most interested in. And some of these suggestions should be easy to implement if you agree with my reasoning.

-- 
Justin (a/k/a jcc7)
http://jcc_7.tripod.com/d/

J C Calvarese wrote:
> It shouldn't be necessary to add an entry in the ODBC Manager to access an .mdb file. I think it's called a "DNSless connection". I've done it before, but it's been a while. I'll try to add that capability to your test program to show you what I mean, but I haven't done it yet.

Ah, I meant "DSNless connection".

It's like this...

Using ODBC connection without specifying a DSN :
Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\path\to\database.mdb

http://www.stardeveloper.com/articles/display.html?article=2000120101&page=1

I still think it's possible, but I keep on getting errors trying to adapt your test program to use this. Hmmm...

-- 
Justin (a/k/a jcc7)
http://jcc_7.tripod.com/d/

In article <cforih$18s1$1@digitaldaemon.com>, J C Calvarese says...
>
>J C Calvarese wrote:
>> It shouldn't be necessary to add an entry in the ODBC Manager to access an .mdb file. I think it's called a "DNSless connection". I've done it before, but it's been a while. I'll try to add that capability to your test program to show you what I mean, but I haven't done it yet.
>
>Ah, I meant "DSNless connection".
>
>It's like this...
>
>Using ODBC connection without specifying a DSN :
>Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\path\to\database.mdb
>
>http://www.stardeveloper.com/articles/display.html?article=2000120101&page=1
>
>I still think it's possible, but I keep on getting errors trying to adapt your test program to use this. Hmmm...
>
>-- 
>Justin (a/k/a jcc7)
>http://jcc_7.tripod.com/d/

J C Calvarese: Thank you very much for your comments and corrections! I've
updated the files and retested them...below are the comments from the readme
file within the new zip file:
========================================================
ODBC32.DLL header files for "D"

A special thanks to "J C Calvarese" from the "D" user's forum, for testing and pointing out a few problems that somehow got passed me. :(

1) Corrected errors that "J C Calvarese" had found.
2) I've put in the SQLDriverConnect() to do a DSN-Less Database connection,
instesd of using SQLConnect().
3) Added a few more comments into sqltest.d
4) Zipped everything with paths.
5) Modified "J C Calvarese" build.bat and rename it to build_sqltest.bat

* Below is an example of the batch file in action:
------------------------------------------------
C:\dmd>build_sqltest.bat
Compiling std.c.windows.sql*.d and odbc32dll.d ...
Digital Mars Librarian Version 8.00n
Copyright (C) Digital Mars 2000-2002 All Rights Reserved www.digitalmars.com
Digital Mars Librarian complete.
C:\dmd\bin\..\..\dm\bin\link.exe
sqltest,,,std_c_win_sql.lib+user32+kernel32/noi;
type in "sqltest" to run the program
Press any key to continue . . .

* An example of running the sqltest example program:
----------------------------------------------------
C:\dmd>sqltest

Library "C:\windows\system32\odbc32.dll" loaded, ODBC32.DLL handle=9961472
Connected to the Database
DSN-Less String="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\dmd\Demo.mdb"
ODBC created DSN String="DBQ=C:\dmd\Demo.mdb;Driver={Microsoft Access Driver
(*.mdb)};DriverId=25;FIL=MS Access;MaxBuffrSize=2048;PageTimeout=5;"
Executing "CREATE TABLE NAMEID (ID INTEGER, NAME VARCHAR(50))"
Table already exists...dropping it and then recreating it
Inserting 1st row into the NAMEID table: id=500, name='Babbage'
Inserting 2nd row into the NAMEID table: id=567, name='Jane'
Selecting the 1st row: id=500, name='Babbage'
Selecting the 2nd row: id=567, name='Jane'
Disconnecting from the Database.
Library "ODBC32.DLL" freed

C:\dmd>

6) I still need to put in code that'll find the ODBC32.dll instead of hardcoding it ( yes, I know hardcoding is bad! :P ). ==============================================

The updated file can be gotten at the same location: http://spottedtiger.tripod.com/D_Language/D_Support_Projects_XP.html

Thxs again,
David L.

-------------------------------------------------------------------
"Dare to reach for the Stars...Dare to Dream, Build, and Achieve!"