Discussions - microsoft.public.data.odbc

	AIX ODBC driver for MSSQL
	Does anyone know of a method to connect to an MSSQL database server directly from an AIX Unix server? By flipme1 - Nov 10 - 2 new of 2 messages

	ODBC connection without knowing user and password
	Hi, I have provided an application from our data provider which creates a System DSN when run on any PC. It creates a system DSN atomatically and we dont know which User/ Password has been used by this application. Now in my C# .NET application i want to connect to that DSN and access tables to get data.... more » By Neo - Nov 4 - 3 new of 3 messages

Retrieving metadata from sqlserver including column and table comments does not work

Hi, I am struggling with several database systems to get the remarks per column. Thus I tried SQL Server 2000. I'll test SQL Server 2005 later. I have added log messages for each row of the result set from SQLColumns, but I never see the remarks from - say - the Northwind sample database. (I have added a remark in Employees.EmployeeID)... more »

By Lothar Behrens - Oct 19 - 2 new of 2 messages

	Missing ODBC drivers in Win XP Pro
	For some reason I don't have any drivers listed in my odbc administrator. I was doing an install of SQL 2000 when it crashed which somehow removed all of the drivers from the listing. How do I retrieve them? Upon doing some research it states that I have MDAC 2.8.1 installed on my Windows XP professional machine.... more » By alvin - Sep 9 - 2 new of 2 messages

	Identify auto-incremented / generated columns in a table?
	Is there a way to identify columns like SQL Server identity columns? I see you can use SQLColAttribute for result set columns, but I'm looking for a way to tell from just a table. In particular, I'm trying to add this functionality to the Python pyodbc library: [link] Thanks.... more » By mkleehammer - Sep 5 - 2 new of 2 messages

	ODBC error in windows server 2008 r2
	I have a an aplication that gets connected to oracle (10.2.4) via ODBC (at my desktop I'm using windows 7 ) in my desktop everithing runs excelent also running the compiled aplication on windows 2003 server (the application gets distributed to users via TS) I'm moving the aplication to windows 2008 r2 on server ,... more » By Ignacio Carrasquedo - Sep 4 - 2 new of 2 messages

Unicode applications and Driver Manager with a non-Unicode driver

So, I have an non-Unicode enabled driver and I want to retrieve result sets from it. What I can not tell from the documentation is what happens with SQLDescribeColW as far as the length field for strings. Is the length reported here the database length in bytes or the number of bytes when converted to Unicode? Bear in mind that it could be possible the driver is returning DBCS in some cases, and I'm not even sure if there's a way to identify that, is there?... more »

By Larry Johnson - Sep 3 - 2 new of 2 messages

	Values from Access database via ODBC are getting truncated
	This issue is specific to one PC. It is running Windows XP Pro sp3 and connects to an Access (2003) dastabase via MS Access ODBC (Mdac 2.8). The problem is values from the database are being truncated, (ie. a string data type value of '1.0.1234' is being returned as '1.0.1'. I've made a test... more » By Robert B - Aug 17 - 3 new of 3 messages

	ODBC driver for DB2
	Hi, I have written a PowerShell script for to read datas in DB2 database. It works fine on my Windows XP with IBM DB2 Run-Time Client Lite, but it doesn't work on Windows Server 2003 x64. What kind of ODBC driver must I install on x64bit system? I'm searching a lite client, not a full heavy client.... more » By Minniti Sergio - Aug 11 - 2 new of 2 messages

	Remote ODBC Access
	God Bless You Everyone, Can anyone tell me if it is possible to connect to Sql server through an ODBC driver & utility? We have an MS Access application that we want to connect to a remote SQL Server. Please advise, thanks! Sincerely, Anthony Smith In God We Trust! By Anthony Smith - Aug 1 - 3 new of 3 messages