Rank: ? (2)
Member #: 29173

hi all,
please help me, how to connect vb with sql server, because coding that i am using gives errors.
also code for adding record to database table.
i am using this code for adding record:-
insert into table name values ('"+text1.text+"','"+text2.text+"');
but it is not working

Rank: ? (134)
Member #: 28863

here is one way toconnect to a server database

ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRI VER={SQL
> SERVER};DATABASE=name