SQL Server Destination error “0x80040E14 “
Limitation of the SQL Server Destination Object "If you attempt to use the SQL Server destination to bulk load data into a remote SQL Server database, you may see an error message similar to the … Read more
Category : Databases
Mysl, MSSQL, Oracle, SQLITE, POSTGRES
local system vs network service vs domain user
This article from microsoft summarized everything: http://msdn.microsoft.com/en-us/library/ms191543.aspx http://msdn.microsoft.com/en-us/library/ms345380.aspx http://msdn.microsoft.com/en-us/library/bb500434.aspx
Foxpro Tutorials and Resources
I inherited a foxpro database from a couple of legacy applications and while i was working on them, i thought that it could be useful that i create a quick list of the most useful websites on the subject. … Read more
Connect to Mysql from a Windows Application using ODBC
1. Download the mysql connector located here : http://dev.mysql.com/downloads/connector/net/6.0.html 2. Add a reference to the mysql.data.dll (for some reason mysql.data is missing from the .net reference tab). If that is the case for you downlaod the … Read more
Difference Between varchar and nvarchar
Varchar uses ASCII meaning that only one byte is used to store the information. Nvarchar uses UNICODE two Bytes are used to stored the information. (Twice as more data) Normal use should require varchar otherwise … Read more