How to write your own database driver
Date: 11 May 2006 07:11:16 -0700
Message-ID: <1147356676.039739.85080_at_g10g2000cwb.googlegroups.com>
Hello,
I have a problem for which I have a new idea how to solve it. But I'm not sure if it is possible, so I'm writing to you.
There's a software which connects to a database and reads data from the database and then visualizes that data. But it doesn't support a certain database. (sybase) We made it work with a oledb driver anyway. But it doesn't work smoothly, there are some problems. Now I can't change the database and I have no access to the software code. So I thought maybe I can write a custom driver. One of the problems is that the software puts quotes around the string and so the software can't read any column names and table names that are longer than 28 characters. Could I write the driver so that it only looks at the first 28 characters of the string, or could I make a similar workaround within the driver?
I'd be happy to get comments or any pointers to references on the topic.
Cheers,
Elif
PS: I tried the 'Enable Quotes' option. The error is sth different than