Can't Add/Update

[Tom]

Hello,

I've tried almost everything and I can not figure out this error I am getting. When I try to "add" or "update" my database, I get this error:

Error # = 0
Description = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = IM006
NativeError = 0

This happens on all examples of asp-db pro and even the built in example that is installed.

My machine was freshly formated yesterday because of a hard drive failure, so the Installation is pretty clean.

My specs are:
NT4 SP6a w/ Dual CPU
IIS4
FrontPage 2000 Extensions
Office 2000 Installed
Latest ODBC Drivers Installed (2.5?)
My database is a Access 2000 db.
I'm using a System DSN
Object is correctly registered w/ MTS
I can view/browse the database fine, but when "add" or "update" is clicked, I get the error.

Please Help!

Tom

[Mark]

Tom,

Please read Tech Tip #5 and see if that helps. Let me know. Thanks.
http://www.aspdb.com/techtips

Mark.



------------
Tom at 6/30/00 4:50:09 AM

Hello,

I've tried almost everything and I can not figure out this error I am getting. When I try to "add" or "update" my database, I get this error:

Error # = 0
Description = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = IM006
NativeError = 0

This happens on all examples of asp-db pro and even the built in example that is installed.

My machine was freshly formated yesterday because of a hard drive failure, so the Installation is pretty clean.

My specs are:
NT4 SP6a w/ Dual CPU
IIS4
FrontPage 2000 Extensions
Office 2000 Installed
Latest ODBC Drivers Installed (2.5?)
My database is a Access 2000 db.
I'm using a System DSN
Object is correctly registered w/ MTS
I can view/browse the database fine, but when "add" or "update" is clicked, I get the error.

Please Help!

Tom