Databases
Wednesday, January 23rd, 2008
1. Create a DNS name for your Access Database(*.mdb file) which you want to connect.
Start -> Settings -> Control Panel -> Data sources
Select Access in User Data Source
Click Create
Select ...
Posted in Databases, Java, Microsoft | No Comments »
Monday, January 7th, 2008
If you've ever written a script that needs to UPDATE or INSERT Date values in a database and you live outside of North America, then I'd nearly bet that (like me) you've stayed up until midnight cursing the fact that all dates in SQL Server and MS-Access are natively converted ...
Posted in Databases | No Comments »
Thursday, September 6th, 2007
In order to do this, you will have to link the second server to your current server. You can do this by using linked servers option in enterprise manager or by using the stored procedure called sp_addlinkedserver.
Then in your query you can use tables of the remote server by qualifying ...
Posted in Databases, Ms Sql Server | No Comments »
Tuesday, September 4th, 2007
Sometimes when you try to input text into database from your C# applications, some of the characters don't show up or show up differently. For Example: apostrophe(') is very often replaced by question mark(?). The same thing happens when you try inserting chinese or japanese characters into database.
The reason of ...
Posted in Asp.Net, C#, Databases | 2 Comments »