Problem with the ODBC Text Driver

[Christoffer Bergman]

I have a problem with the ODBC Text Driver:

I open the "Data Sources (ODBC)" in the Control Panel (I
run Windows NT) and select to Add a User DSN. I choose to
use the Microsoft Text Driver and in the ODBC Text Setup I
click on "Options >>" and Define Format. In this dialog I
have the possibility to select TAB Delimited instead of
the default, which is CSV Delimited, but if I do that I
sometimes receive a message that says:
"Failed to save table attributes of (null) into (null).".
If I don't get this error message here, I will get a
message later that says:
"Driver's SQLSetConnectAttr failed"

My guess is that I need to set the Tab-attribute for one
specific table, but when I define my ODBC I don't yet have
a table. The table is created by my software with "CREATE
TABLE" at a later point, and by then it has to know if it
should be TAB or CSV delimited to know how to create it.

Because of this I have never been able to create an ODBC
connection to a text-file that is anything but CSV
delimited.

Is there anybody that knows why? Does anybody have a
suggestion about how I may solve this?

Thanks
Christoffer

[Jan Csisko]

Hi Christoffer,

you might want to try the same test with a `system` instead of `user` dsn.

Hope this helps,
Regards,
Jan

"Christoffer Bergman" <christoff...@audiodev.com> wrote in message news:<07ad01c2a5d9$0d80db30$d5f82ecf@TK2MSFTNGXA12>...