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?
.

Relevant Pages

  • Re: Dateadd in SQL statement not working
    ... Omigod, I thought you said you were using SQL Server, which is what my ... version of SQL used by Jet, which is the database usually used by Access): ... But my confusion is not totally resolved: Why are you using a Sybase ODBC ... driver to connect to either a Jet or a SQL Server database? ...
    (microsoft.public.inetserver.asp.general)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: JDBC URL for Oracle Database With Failover (2 db servers)
    ... After you've loaded the driver, you can establish a connection using ... each form requires a database URL. ... For Oracle, the database URL has ...
    (comp.lang.java.databases)
  • RE: New JDBC 1.2 driver runs slower than JDBC 1.1; my db definitio
    ... If the support incident ends up verifying a slowdown in the new driver, ... New JDBC 1.2 driver runs slower than JDBC 1.1; ... I do think this would happen in general, not just for my database; ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)