BSNL 3G data card Teracom H/W: v1.0 S/W: LW273 v1.2 with other network

I think it is easy to flash other 3G modems mainly Huawei to use network's other than the one for which the modem was provided.

But mine in 7.2Mbps teracom modem provided by BSNL. I was not able to use other network sim cards in windows. When I insert different sim card the application provided with the modem will rise error message.

What I did is tried in ubuntu. Just start your PC with your modem pluged into the USB, It will be automatically detected. Now change the settings according to the network and use.

If modem is not detected, Copy the contents of the virtual drive created in your windows while plugging the modem for the first time. You can find a folder with a name Linux, copy it and install in your ubuntu. After installing in ubuntu you may get error message, ignore it.

Now after installing the program in ubuntu, restart you PC. Now your modem will be detected.

Enjoy......This worked for me...............I Will let you know once I find a way in windows......Also let me know if there is already a way to use in windows......

Cheers....

Sample confirmIT coding

Below is the sample code to know how coding will look like in confirmIT.

if( f('Q1').get() == '1' )
{
f('Q2').set('1');
}

• In the above code f(‘Q1’) refers to the single choice question object having the question id ‘Q1’.
• f() is used to refer the objects in the confirmIT.
• f(‘Q1’).get() == ‘1’ means first choice of the single choice question is selected.
• f(‘Q2’).set(‘1’);  this statement sets the first choice of the single question object haveing the question id ‘Q2’.

DataEnvironment connection already open problem (VB6.0)

IF DataEnvironment.connection_name.state <> 0 then

DataEnvironment.connection_name.close

DataEnvironment.connection_name.open

End if

DataEnvironment.dataenvirnoment_command_under_connection_name para1,para2….paran

What is the use of CONFIRMIT

It is SOS(Software as Service) kind of web service. We can use the tool only through the internet. It is used to generate online questionnaire to take surveys. Using the CONFIRMIT we can generate the questions of various types like single choice question, multi choice question and grid question.

We have objects in CONFIRMIT which are called nodes. We can drag the required nodes depending on the type of question we need. In the next post I will provide the screen shots for different type of questions.

Confirmit

What is it? It is a market research tool which helps in creating the questionnaire. It have build in objects and can be programmed. We can modify the flow of questions being asked, by programming. Conformit is a web service.

Browser – Problem in loading

If you find that everything about your internet settings are fine but still the pages still take time to load, then just clear your cookies and restart the browser.

Stored procedure/SQL query of MS Access in VB.Net

Dim prov As String = "Microsoft.Jet.OLEDB.4.0"
Dim pass As String = "123"
Dim con As New OleDb.OleDbConnection("Provider=" + prov + ";Data Source=" + "F:\Perfect Engineering\Perfect Engineering\Perfect Engineering\bin\Debug\Perfect_Engineering.mdb;Jet OLEDB:Database Password=" + pass)
Dim cmd As New OleDb.OleDbCommand
Dim dr As OleDb.OleDbDataReader
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "delivery_pending"
dr = cmd.ExecuteReader
If dr.Read() Then
   MsgBox(dr(0))
End If

SQL Query to sum and compare a field’s value based on relationship

Let the tables be,

Table: delivery_challan primary key: dcno	Table: invoice_entry Foreign key: dcno
dcno recqty 1 5 2 5	dcno desqty 1 2 1 3 2 3

Scenario: we have to sum the ‘desqty’ of the invoice_entry on ‘dcno’ wise and should compare with the ‘recqty’ of delivery_challan on ‘dcno’ wise and should show only the records of the ‘delivery_challan’ for which ‘recqty’ is greater than the sum of corresponding dcno’s ‘recqty’.

I am dam sure, you can’t understand my English. Just try the query and find the result.

SELECT * from delivery_challan where delivery_challan.recqty > (select sum(desqty) from invoice_entry where invoice_entry.dcno=delivery_challan.dcno);

XP boot’s and starts loading and restarts

If this is a problem you got after suddenly switching of your pc, without properly shutting down. Then here is the solution. Even safe mode may be not working.

1. Insert your XP cd and boot from it.
2. After booting from the cd select Repair option to get the dos mode.
3. In the dos mode type ‘help’ to get the list of commands.
4. Try the ‘logon’ or ‘fixboot’ command, if it fails then there is a chance’s of problem being displayed there itself. For example it may display that there is a problem in logging in, Reason may be corrupted file system so use chkdsk command.
5. Here use chkdsk (Check Disk) command to repair any corrupted file system.
6. Now use fixboot command to fix any damaged boot sector.
7. Use any other command depending on your need.
8. Now again try to use ‘logon’ command, now you should be able to logon. This means your problem is solved.

VBS Extract MS word document links to separate file

Set objWord = CreateObject("Word.Application")
objWord.Visible = True
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set f = objFSO.OpenTextFile("c:\hyperlinks.txt", 2 , True) 'file name’s to which links to be written
Set objDoc = objWord.Documents.Open("c:\Exercises.doc") 'Word document from which links have to be separated
Set colHyperlinks = objDoc.Hyperlinks
For Each objHyperlink in colHyperlinks
f.WriteLine(objHyperlink.Address)
Next

Date in VB.NET verses MS Access 2007

• Use date picker control in vb.net and set the Format property of the control to the required date format.

• Now in MS Access 2007 open the tables design view and set the format property of the corresponding fields’ data type to match the data type of date picker control of vb.net application.

• Now perform SQL date operations like a normal query, with out any need for code to change the date format for Ms Access.

VB.NET and MS Access OLEDB

Dim source As String

Dim prov As String

Dim pass As String

prov = "Microsoft.Jet.OLEDB.4.0"

source = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.Location())

pass = "123"

Dim con As New OleDb.OleDbConnection("Provider=" + prov + ";Data Source=" + source + "\Perfect_Engineering.mdb;Jet OLEDB:Database Password=" + pass)

con.Open()

VB.NET and MS Access ODBC Connection

Dim con_string As String

con_string = "Driver={Microsoft Access Drive(*.mdb)};DBQ=C:\test.mdb;"

Dim con As New Odbc.OdbcConnection(con_string)

Try

      con.Open()

            MsgBox("Database is open")

      Catch ex As Exception

            MsgBox("Cannot open the database:" + ex.ToString)

End Try

Be aware of malware

Do you know that malwares ask permission to enter your system.

Yes, it’s a type of malwares, enters while you visit malicious web sites.

Some malicious web sites may give fake warning that your system is affected and it will ask you to click ok  to solve the problem. Be aware of such type of risks.

It will show you a window like windows firewall window or like any other system window.

Cannot create a new partition( error: not enough space) - Vista\Windows 7

Me to faced the same problem when I had uninstalled and deleted the XP's partition. I dual booted my pc with vista and xp.

Solution for this problem is simple,

Just download a free partition tool called "EASEUS Partition Master Home Edition" and use it to partition.You can even use the unpartitioned or Can extend the existing partitions size and many more. 

cd/dvd drive slowing down the pc

playing a video is not smooth or pc slows down when copying from the dvd drive. But the dvd drive was working normally.
It may be because of slight modification of settings. To solve this
* go to device manager.
* Under IDE ATA/ATAPI contrllers, check under the advanced settings tab of properties window for all the sub optioins.
* Set transfer mode as DMA for all of them.
* Now restart and check.
* If this doesn't work, just uninstall the dvd driver and select add hardware to reinstall the driver again, this may solve.
* If both of this fails, open your cabinet and plug the dvd drives bus in another socket.

Disabling visual studio just-in-time debugger

It may be irritating to see the just in time debugger popping up continuously