从vb6环境连接sql server 2005数据库表 [英] Connect sql server 2005 database table from the vb6 environment

问题描述

如何从vb6环境连接sql server 2005数据库表.另外，如何将sql数据库表导入到sql server2005.

预先感谢，

问候，
Arasu

how to connect sql server 2005 database table from the vb6 environment.I want step to step procedure. Also, how to import sql database table to sql server 2005.

thanks in advance,

Regards,
Arasu

推荐答案

VB ^一直很烂，并且已经过时了十年.这就是为什么您找不到帮助的原因.使用VB.NET.这是一种实际的编程语言.

VB^ has always sucked and has been obsolete for a decade. That''s why you''re having trouble finding help. Use VB.NET. It''s an actual programming language.

ConnectionStrings.com [ ^ ]，您应该可以找到正确的版本.

Using SQL Server 2005 Express from Visual Basic 6[^]

You may need to change the connection string to;
Provider=SQLNCLI.1;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;
or
Provider=SQLNCLI.1;Data Source=DataSourceName;User ID=useridname;Password=password;

But if you spend some time looking through ConnectionStrings.com[^] you should be able to find the correct version.

这篇关于从vb6环境连接sql server 2005数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！