Tuesday, June 30, 2009

ODBC Drivers error '80040e37' [Microsoft]
[ODBC SQL Server Driver][SQL Server]Invalid object name in ASP

When I was trying the asp files in the server, I got this error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TableName'.
/web/FileName.asp, line 363

To fix this problem, just need to write query included server name in select query, as example below:
SELECT * FROM servername.dbo.tablename

It really works...

Tuesday, June 16, 2009

HOW TO EMBEDDED SONG INTO POWER POINT FILE

Here I want to share how to embedded song file into power point file. So, you don't need to send the song file when you send your power point file, because the song is already embedded in it. How to make it works:

1. Use wav file instead of mp3 file, convert song into wav file
2. In the Tools > Option > General, input "Link sound with file size greater than", with value more than your wav song file. Ex: 50000 Kb
3. Save your power point file, notice the size of your power point file
4. Insert song from Insert > Movies and Sounds > Sound from File
5. Browse the wav song
6. Save power point file, then notice again if the file size increase, then you've successfully embedded.

Try it, it really works, good luck...