Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0],

7876
6
12-09-2013 10:19 AM
Highlighted
Honored Contributor
Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0],


As I started editing, I got the message below:

[ATTACH=CONFIG]29688[/ATTACH]

What might be the issue here?

Thank you

Best

Jamal
Reply
0 Kudos
6 Replies
Highlighted
MVP Regular Contributor
According to Microsoft this could be a bug based on what you may be trying to do.  A such, one work around suggestion might be to use a Float data type rather than a Decimal:

http://www-01.ibm.com/support/docview.wss?uid=swg21483818


However, as a first measure it might be best to install the Feature Pack for SQL Server 2008, service pack 3. It should be available as a 32- or 64-bit installer.  I would suggest this first to see if it clears up your issue before changing data types.
Reply
0 Kudos
Highlighted
Honored Contributor
According to Microsoft this could be a bug based on what you may be trying to do.  A such, one work around suggestion might be to use a Float data type rather than a Decimal:

http://www-01.ibm.com/support/docview.wss?uid=swg21483818


However, as a first measure it might be best to install the Feature Pack for SQL Server 2008, service pack 3. It should be available as a 32- or 64-bit installer.  I would suggest this first to see if it clears up your issue before changing data types.


Thank you very much William for the help,

The second reason can be the issue.

I got this problem while I�??m trying to access SQL server 2012 database (*.mdf) stored on the server machine from a client machine that has SQL server 2008 installed.

If this is the issue, do I need then to uninstall the SQL server 2008 and install the SQL server 2012 on the client machine?

Is it easy to uninstall the SQL server 2008 from the client machine?
Reply
0 Kudos
Highlighted
MVP Regular Contributor
I believe you would want your native client version to match the version of your server's database.  Please try to upgrade the client (either 32 or 64 bit) to match the server and let me know if this resolves the issue.
Reply
0 Kudos
Highlighted
Honored Contributor
I believe you would want your native client version to match the version of your server's database.  Please try to upgrade the client (either 32 or 64 bit) to match the server and let me know if this resolves the issue.


Many thanks William for the help,

There is an option on the SQL server to upgrdte to 2012. I tried it but I got other error messages. I preferred to format the client machine and install everything from scratch

[ATTACH=CONFIG]30419[/ATTACH]

Best

Jamal
Reply
0 Kudos
Highlighted
Regular Contributor
What William was saying was, upgrade your SQL Native client on your workstation, to match the SQL Native Client which was already installed on your SQL Server.
Reply
0 Kudos
Highlighted
Honored Contributor
What William was saying was, upgrade your SQL Native client on your workstation, to match the SQL Native Client which was already installed on your SQL Server.


Thanks Leo.

I did but I got error while I was trying to upgrade the client machine to match the SQL on the server machine.

However, I have formatted the client machine and installed everything from scratch. At the moment, all work fine.

Best

Jamal
Reply
0 Kudos