Help needed 
Author Message
 Help needed

6/04/01

I am currently working on a project in which I am going to support multiple
database brands through the ODBC interface; to do this, I need certain
capabilities of the database.

I have tested these brand name databases:
Microsoft Access (3.5 and 4.0)
Paradox 5.x
Excel (yeah, the spread sheet; it can be an ODBC data source, too)

I know I want to support these, but do not have them installed on my system:
Informix
Oracle
(MS) SQL Server

I would like some volunteers who have the target databases installed (plus
any other brand names you think I should have). What you would need to do is
copy a program onto disk and follow some simple instructions (like, 'click
on this button'). The software will generate a text report file which looks
like this:

06-04-2001                    ODBC DRIVER/DBMS REPORT
14:50:35

Connection String Attributes:
DSN=RA206
DBQ=C:\Software_Development\Testdata\remitaid\ra206.mdb
DriverId=25
FIL=MS Access
MaxBufferSize=2048
PageTimeout=5
UID=admin
****************************************************************************
***************
NOTE NOTE NOTE
PLEASE REMOVE ANY UID or PWD strings from the connection attributes on the
report.
I will try to catch these myself, but I often forget to do things like this!
****************************************************************************
***************
Data Source Name:RA206
Database Name   :C:\Software_Development\Testdata\remitaid\ra206
DBMS Name       :ACCESS
DBMS Version    :04.00.0000
Driver Name     :ODBCJT32.DLL
Driver ODBC Ver :03.51

Supported Capabilities
Transactions (DML) : Y
CREATE TABLE       : Y
DROP   TABLE       : Y
ALTER  TABLE       : N
CREATE INDEX       : Y
DROP   INDEX       : Y
Nullable Columns   : N
Max Concurrent Stmt:  0 (Unable to determine)

           Datatypes Supported
 SQL Type     DBMS Literal     Column Size
 --------     ------------     -----------
     -11      GUID                     36
      -7      BIT                       1
      -6      BYTE                      3
      -4      LONGBINARY       1073741823
      -3      VARBINARY               510
      -2      BINARY                  510
      -1      LONGCHAR         1073741823
       1      CHAR                    255
       2      CURRENCY                 19
       4      INTEGER                  10
       4      COUNTER                  10
       5      SMALLINT                  5
       7      REAL                      7
       8      DOUBLE                   15
       9      DATETIME                 19
      12      VARCHAR                 255

*** END OF REPORT ***

All you need to do is send me the text report. You can keep the software for
your own use. (That's all I use it for).

The program is a single Win32 EXE, 57Kb unzipped (I can ZIP it for you if
you want). It does not install any DLLs or write to or read from the system
registry or do any of that other annoying stuff.

What's in it for you? Well, nothing except my thanks, and the promise that
if you need something like this in the future I will volunteer.  Plus you
get the software to play with. (Unsupported). It connects to any ODBC
datasource, and has a little edit window where you can enter your own SQL
statements and it will bring back the results.

Just send me an e-mail with a return address (where I can either click
'reply' or on a mail link if your regular e-mail return address has
spam-blocking characters of some kind) and indicate which of the desired
databases you can process.. Also indicate if you'd prefer the software in
ZIP form and I'll ZIP before sending.

Thanks,
Michael Mattias
Tal Systems
Racine WI USA



Sat, 22 Nov 2003 03:55:10 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ***HELP***HELP***NEED INFORMATION***HELP***HELP

2. Help needed converting 2.1 for DOS files - Clarion Expert needed

3. Help !!!, Need a Clarion RDD, Please help

4. HELP: Need help with Ms-Dos batch lang..

5. COBOL HELP NEEDED, PLEASE HELP ME!

6. Help on help needed

7. Smalltalk help needed in Dallas.. immediate professional help needed...

8. Serious, VERY serious SmallTalk help needed in Dallas.. immediate professional help needed.

9. Smalltalk help needed in Dallas.. LOCAL professional help needed...

10. Smalltalk help needed in Dallas.. LOCAL Candidates ONLY immediate professional help needed...

11. Smalltalk help needed in Dallas.. LOCAL professional help needed...

12. Smalltalk help needed in Dallas.. LOCAL professional help needed...

 

 
Powered by phpBB® Forum Software