Too much geek

At my last post you have read how weird the technique was. The was I transfer the datas from one server to the other. After a series of tweaks yesterday I have realize that the solution that I will issue was too much complex. To the point that im trying to make things difficult or im trying to solve things in a nerdy way. And I mean too much nerd. Then after a couple of googling I have comeup a new a simplier way to solve the problem. I think it was a breeze in my part. I decided to use the sql server again instead of my own creative technique. It was simplier and better I guess.

What I did was instead of issuing the usual server name whenever you establish a connection via LAN I simply change it to IP address to establish a connection. And bam thats it. I can instantly do the usual code such as insert/update/delete statement. Here's the code:

conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dns;Data Source=192.168.0.200"
conn.CursorLocation = adUseServer
conn.Open

See how simplier it is? relax nerdy don't be to harsh to yourself. hehehe

Comments

Post a Comment

Popular posts from this blog

Apple's Edge Over Microsoft?

In the world of IT, models created by business empires will dictate the future of their products. Microsoft is using the component model as the key to win customers and Apple is using the end-to-end model. Microsoft Windows platform crushed Apple's Macintosh platform the day Microsoft release Windows 98 and pirates come out in the open and dominate every stall in our local mall and computer shops. iPod maybe the best and coolest mp3 player that I have ever seen but I still don't think that Apple will dominate the cell phone era for this place belongs to Asia particularly Nokia and Sony Ericson. I don't know why Walter Mossberg thinks US company will always dominate the world when in fact there is another company that belongs to the world and its called Open Source. I think he is dead wrong with his perception. Without a doubt nobody comes close to iPod in the field of mp3 player however, with the release of Sony Ericson latest cell phone such as W900i. An intelligent human
Read more

High Grounds Cafe - Best Internet Cafe in the Philippines

Image
I was looking for a nice place to chill last Monday to unwind my thoughts and enjoy with my family. I heard about the latest Internet Cafe just open 3 months ago and I decided to check it out. I have seen a lot of Internet Cafe but nothing comes close to this shop. Everything was simply high end from its ambiance, food and computers. It was simply the best place for people who want to collaborate and enjoy together.
Read more

John Gokongwei Speech before Ateneo 2004 Graduates

I wish I were one of you today, instead of a 77-year-old man, giving a speech you will probably forget when you wake up from your hangover tomorrow. You may be surprised I feel this way. Many of you are feeling fearful and apprehensive about your future. You are thinking that, perhaps, your Ateneo diploma will not mean a whole lot in the future in a country with too many problems. And you are probably right. You are thinking that our country is slipping-no, sliding. Again, you may be right. Twenty years ago, we were at par with countries like Thailand,Malaysia, and Singapore. Today, we are left way behind. You know the facts. Twenty years ago, the per capita income of the Filipino was 1,000 US dollars. Today, it's 1,100 dollars. That's a growth of only ten percent in twenty years.
Read more