Connect to SQL Database with Visual Basic 2008

enizag · October 22nd, 2008, 10:55 AM

Hi

I am converting a project over from Excel VBA to Visual Basic 2008, but I am completely stuck on how to connect to my SQL database, and subsequently manipulate the data, the excel VBA code is as follows:

Code:

szConnection = "ODBC;UID=ADMIN;PWD=;DSN=Colleague32"
Set wrkODBC = CreateWorkspace("ODBCSpace", "admin", "", dbUseODBC)
Set conPubs = wrkODBC.OpenConnection("", , , szConnection)
sql = "Select * from users"
Set rstTemp1 = conPubs.OpenRecordset(szSQL1, dbOpenSnapshot, dbRunSync)
    With rstTemp1
        Do While Not .EOF
            /*My code here*/
            .movenext
        loop

I can't figure out how to get the connection to my SQL database or what the commands are.
Please can any one help on this, I would be very grateful.

Thank You
John

gbianchi · October 22nd, 2008, 11:07 AM

Hi there.. are you trying to connect to SQL server?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

enizag · October 22nd, 2008, 11:11 AM

Hi Gonzalo

Yes the database is on a server. It will only be used over a LAN and will not go on to the internet.

Cheers

John

gbianchi · October 22nd, 2008, 11:18 AM

NO, I mean if the database is SQL SERVER (2000,2005)??? or mysql? or oracle?

You have propietary objects for that type of databases and a lot of info in google on how to connect to them and handle them. Even if the database is oracle, you can connect to it using proprietary objects.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

enizag · October 22nd, 2008, 11:32 AM

Sorry mis-understood.
It is SQL server 2000.

I have looked at google and can't make out exactly what is needed by Visual Basic.

Cheers

John

gbianchi · October 22nd, 2008, 12:04 PM

Well, this query "how to connect sql server 2000 vb.net" throw a lot of results in google.

Anyway, .net use a complete different way to connect to a database, also to handle "recordsets". Depends on what you need, is what you open an use to process. There are objects that you can just throw on the form to make the connection open automatic. There is no more recordset, now you have datatables (something like a table), datasets and others. Maybe you can start digging from there.

The easy answer would be, you have to create a connection object and pass the connection string to it, open it, then build a datatable for what you need.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========