Try this
dim con as new ADODB.Connection
con.open "DSN='',UID='',pwd=''" ' Create a DSN to Accessdatabase
sql=Insert into table1 values('" & text1.text & "')"
conn.execute sql
I hope this willsolveur problem
I have two dll's in MTS which has to access the database(SQl Server) which is on a different machine. This two dlls must run in the same transaction. How do i enlist the connection for this using VB, meaning i want to have the same connection for these two components.
Can u tell me how to do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.