sql server connect: MDAC 2.8 not accepting nulls -- sql server connect

MDAC 2.8 not accepting nulls

sankarvs
2/28/2006 1:35:27 PM

sql server connect:

Hi,
My Windows XP client machines are using MDAC 2.8 SP1 to connect to a
clustered SqlServer 2005 database. SqlServer definition says null values are
acceptable in foreign key columns. But MDAC 2.8 SP1 says nulls are not
accepted. The same application connecting to the same database/table from
other clients using up to MDAC 2.7 do not have any problem. Is this a bug? If
so any idea on ways to get around it?
Any input is appreciated.
Thanks.
--

RE: MDAC 2.8 not accepting nulls

Goose
3/17/2006 8:53:03 AM

What object are you using in ADODB to update the table?
Would you mind posting some example code? I am trying to reproduce.

Thanks,
Adam

[quoted text, click to view]

RE: MDAC 2.8 not accepting nulls

sankarvs
3/20/2006 10:21:31 AM

The application uses ODBC (System DSN) connection to the SqlServer database.
A simple insert statement fails:
insert into temp1( gf_code, gf_key ) values( :sGFCode, :sGFKey )

where gf_key is a foreign key linked to another string column

--
SankarVS

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.