Re: How to write your own database driver

elif wrote:

> 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
> that. We tried all possible settings of the driver.

Your question is more appropriate for an ODBC, OLEDB or sybase newsgroup. Have you looked into whether other sybase drivers already exist? Received on Thu May 11 2006 - 17:05:28 CEST