Discussion:
SQL Server error
(too old to reply)
unknown
2009-12-15 15:41:12 UTC
Permalink
I am receiving this error when attempting to run a report
created with infomaker:
Select error: SQLSTATE=S1C00
[Microsoft][ODBC SQL Server Driver]
optional field not implemented

Can you offer advice for this? Thanks.
Paul Horan[Sybase]
2009-12-17 18:55:17 UTC
Permalink
Always provide the version/build of IM that you're working with...

It would also be handy to know the version of MS SQL.
--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/
Post by unknown
I am receiving this error when attempting to run a report
Select error: SQLSTATE=S1C00
[Microsoft][ODBC SQL Server Driver]
optional field not implemented
Can you offer advice for this? Thanks.
unknown
2009-12-17 22:01:47 UTC
Permalink
I am working with Version 11.1 and MS SQL Server 7
Post by Paul Horan[Sybase]
Always provide the version/build of IM that you're working
with...
It would also be handy to know the version of MS SQL.
--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/
Post by unknown
I am receiving this error when attempting to run a report
Select error: SQLSTATE=S1C00
[Microsoft][ODBC SQL Server Driver]
optional field not implemented
Can you offer advice for this? Thanks.
unknown
2009-12-18 17:24:54 UTC
Permalink
I eventually figured it out. I needed to select the check
mark for selecting the default database within the
administrative tools - DNS system configuration. Thanks for
responding anyhow paul!
Post by unknown
I am receiving this error when attempting to run a report
Select error: SQLSTATE=S1C00
[Microsoft][ODBC SQL Server Driver]
optional field not implemented
Can you offer advice for this? Thanks.
Loading...