Welcome to Babylon of Microsoft database access technologies, APIs and tools! Why Babylon? Because all these technologies are designed to provide unified standardized language and communication way between data provider (of any kind) and consumer (application, developer, user).
Read the rest of this entry »Posts tagged with 'SQL Server'
Microsoft database technologies Babylon: ODBC, OLE DB, ADO, Jet, ISAM, MDAC, LINQ
February 7th, 2009 by Libor Jelinek
Tags: SQL Server | Posted in: SQL Server | 1 Comment »
en: Access linking/importing error: 3125: is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long
January 21st, 2009 by Libor Jelinek
Solution to this annoying bug is to rename object. Make it shorter, without special chars (, -, .). Depends on your database from you are linking or importing from. Unfortunatelly, SQL Server 2000 by default produce these Access unacceptable names for table’s primary keys (e.g. PK__master.PrioritaP___6AA6A67A).
Read the rest of this entry »Tags: Access, SQL Server | Posted in: SQL Server | 2 Comments »
en: Crashing SQL Server 2005 Upgrade Advisor error
January 18th, 2009 by Libor Jelinek
Great tool for migrating from SQL Server 7 or 2000 to new 2005 version can easily crash with strangeful mystery errors if you use Microsoft Update for being up-to-date with .NET Framework. If you have .NET Framework newer than 2.0, Upgrade Advisor failed to analyze database engine component.
Read the rest of this entry »Tags: SQL Server | Posted in: SQL Server | 10 Comments »
