SQL-VB connection

[yosh29rs]

How do we simply build a connection between a VB project and an SQL server?

[labmonkey111]

I don't think there is anything simple about it. But start with right clicking in the table list window, and select link tables. Then in the File Type list select ODBC Databases. From there it is specific to how you have everything set up, so you may have to figure that part out on your own. Hope this at least gets you started.

Just realized this is VBA, not VB, forget I said anything.

[senlachu]

connection

Hi,
Please find the code to connect the VB(visual studio 2008) with sql server (2005)


dim con as sqlconnection
dim cmd as sqlcomment
dim ds as datareader

con= new sqlconnection(" server name ;uid;pwd;databa se")


where uid= username
pwd= password


this is who I have worked and I did not face any problem with this connections .

[lotus18]

How do we simply build a connection between a VB project and an SQL server?

Hi,

What version of SQL Server are you using?

For SQL Server 2005, click this link. Hope this helps.

Rey Sean