在vb中用odbc 连接sqlserver 代码怎么写？

Question

dim conn as adodb.connection
conn.open "DSN","userid","password"

Answer 1

Adodc.ConnectionString="DSN"其中DSN是你的ODBC名字

Answer 2

Set typers = New ADODB.Recordset
conn.ConnectionString = "dsn=interbank;uid=qq;pwd=qiqi;"
conn.Opentypers.ActiveConnection = conn

Answer 3

Set typers = New ADODB.Recordset
conn.ConnectionString = "dsn=interbank;uid=qq;pwd=qiqi;"
conn.Open
typers.ActiveConnection = conn

Answer 4

dim conn as new adodb.connectionconn.connectionstring="driver={sql server};server=servername;uid=your uid;pwd=your password;database=your databasename"conn.open

Answer 5

public M_SQL_Connect as string 
M_SQL_Connect = "dsn=yourdsn;uid=sa;pwd=yourpwd"
conn.open M_SQL_Connect
'conn就是你定义的数据库connection
'然后在odbc数据源建一个sqlserver的dsn