September 12, 2005 at 10:37 am
Hello,
I am trying to obtain the database definition for a SQL Server Database, using the ODBC with the Controller: ODBC Microsoft SQL Server Version 03.85.1117.
When it shows me all the definition for a particular table all this definition is Ok.
Only the comments (Extended Properties) for the tables, are not equal to reallity.
In SQL I have the tables with a long comment (more that 100 Characters), but when I see the definiton tru ODBC it only shows 30 Characters.
Somebody knows why this is happening?
Thaks a Lot
September 12, 2005 at 2:25 pm
Sorry, no idea, but I wouldn't be surprised if there is some ODBC limitation.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 12, 2005 at 3:17 pm
Can you be a bit more specific :
1. What do you mean by Controller?
2. What is your DRIVER version ?
3. What is your ODBC DRIVER MANAGER version ?
* Noel
September 12, 2005 at 3:26 pm
Noeld...
1. Controller is like Driver:
2. My Driver version is: 03.85.1117
Other Data About the Driver of SQL Server are:
File Name: SQLSRV32.DLL
Date: 08/19/2004.
3. How I can Obtain the ODBC DRIVER MANAGER version?
September 12, 2005 at 3:35 pm
OK this is what I need you to Post:
1. Open the Data Sources (ODBC) applet on the Control Panel!
2. Go to the DRIVERS Tab and check the version of your SQL Server driver
3. Go to the About tab and check the version of your ODBC Driver Manager
Last but not least check the version of the MDAC:
Registry Key :
* Noel
September 12, 2005 at 3:45 pm
Your answers
2. SQL Server Version = 2000.85.1117.00
3. ODBC Driver Manager Version = 2.81.1117.0
September 12, 2005 at 3:46 pm
Your answers
2. SQL Server Version = 2000.85.1117.00
3. ODBC Driver Manager Version = 2.81.1117.0
Thanks...
September 12, 2005 at 3:49 pm
The ODBC standard is old so funny things happen with Microsoft generic ODBC driver, try the links below the first to test drive a third party driver that connects to SQL Server through TDS(tabular data stream) protocol and the second link is to download the Microsoft .NET ODBC provider and the last link is Dave Roth ODBC expert. Hope this helps.
http://www.datadirect.com/index.ssp
http://www.roth.net/perl/odbc/
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
September 12, 2005 at 3:52 pm
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply