Sybase ODBC - invalid attribute in connection

Author

invalid attribute in connection - ODBC!

KCC

2006-04-05, 9:23 am

Dear all gurus,

We have sybase ASE ODBC driver version 4.20.00.67.When I tried to test the DSN
created in Control Panel>ODBC I'm
encountering the following error:
----------- error begin ----------------
"[Merant][ODBC Sybase ASE driver] invalid attribute in connection
string: Description"
----------- error end ----------------

In the contrast I can connect to the database through DSN from my pc
where I'm using an older driver.

Do all gurus ..have any ideas for this solutions.How can I connect using the
above mentioned ODBC driver.

Thanks in advance.

---== Posted via the PFCGuide Web Newsreader ==---
http://www.mcse.ms/_newsgroups/group_list.asp

Paul

2006-04-05, 8:23 pm

Hi

What values are you configuring and how are you testing the connection?
What platform? (OS version)
Sounds like Description is getting passed in as a connection string and I am
not sure how that is happening.
Are you testing in an application and passing that value as a property?

If I do this in ODBC Test:

SQLDriverConnect:
In: ConnectionHandle = 0x003B1348, WindowHandle = 0x0015CA10,
InConnectionString = " DSN=ase4265;UID=sa;P
WD=;Description=test
",
StringLength1 = 40, OutConnectionString = 0x00160338,
BufferLength = 300, StringLength2Ptr = 0x0015CA28,
DriverCompletion = SQL_DRIVER_COMPLETE=
1
Return: SQL_SUCCESS_WITH_INF
O=1
Out:
*OutConnectionString
=
" DSN=ase4265;UID=sa;P
WD=;Description=test
;N...", *StringLength2Ptr = 66
dbc: szSqlState = "01S00", *pfNativeError = 0, *pcbErrorMsg = 98
szErrorMsg = "[DataDirect][ODBC Sybase Wire Protocol
driver]Invalid attribute in connection string: Description."

Apparently the driver is not liking this as a connection property. If you
remove "Description" from the connection string it shoudl work ok

-Paul

"KCC" <database_baby@yahoo.com> wrote in message
news:4433a82f$1@foru
ms-1-dub...
> Dear all gurus,
>
> We have sybase ASE ODBC driver version 4.20.00.67.When I tried to test the
> DSN
> created in Control Panel>ODBC I'm
> encountering the following error:
> ----------- error begin ----------------
> "[Merant][ODBC Sybase ASE driver] invalid attribute in connection
> string: Description"
> ----------- error end ----------------
>
> In the contrast I can connect to the database through DSN from my pc
> where I'm using an older driver.
>
> Do all gurus ..have any ideas for this solutions.How can I connect using
> the
> above mentioned ODBC driver.
>
> Thanks in advance.
>
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.mcse.ms/_newsgroups/group_list.asp

Sponsored Links