insert into database

[exodus300]

I am familiar with using the following code in ASP (vbscript) to put stuff in a database. Now I want to do this in VB. Can somebody please help me change this stuff to work from a VB app?

Set db = Server.CreateObject("ADODB.Connection")
db.Open "MyDatabaseName"
sql = "INSERT INTO blablabla...."
db.Execute(sql)
db.Close
Set db = Nothing

Thank you. [Thanks in advance|Hope I helped you]
Exodus300

 

[zemp]

Search this site for ADO and/or connection and you will find lots of examples. The VB help files and MSDN also have good examples. Thanks and Good Luck!

zemp

 

[AncientTiger]

exodus - Works the same way... I've copied/pasted code from an ASP page into a VBA or a VB project and it runs like a charm...
------------------------------------
18 years of programming, and still learning every day!

 

[AncientTiger]

OH, Except that you don't put the "Server." in there.. just CreateObject("adodb.connection&quot

------------------------------------
18 years of programming, and still learning every day!