For Standard SecurityoConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
For a Trusted ConnectionoConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"Integrated Security=SSPI"
To connect to a "Named Instance"oConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName\myInstanceName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
Note: In order to connect to a SQL Server 2000 "named instance", you must have MDAC 2.6 (or greater) installed.To connect to SQL Server running on a remote computer (via an IP address)oConn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
For a Trusted ConnectionoConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"Integrated Security=SSPI"
To connect to a "Named Instance"oConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName\myInstanceName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
Note: In order to connect to a SQL Server 2000 "named instance", you must have MDAC 2.6 (or greater) installed.To connect to SQL Server running on a remote computer (via an IP address)oConn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
1,connstr="driver={sql server};server=10.1.50.170;uid=id;pwd=pass;database=db"2,cnn.ConnectionString = _
"provider=sqloledb;" & _
"Initial Catalog=db;" & _
"Data Source=10.1.50.170;" & _
"User ID=id;" & _
"Password=pass"
出错的地方换了:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
/ehxajh/check.asp, 第 101 行100 sql="SELECT ip FROM iplocktemp WHERE DateDiff('n',lockdate,#" & sj & "#)>=" & iplocktime
101 rs.open sql,conn,1,1而且好像我另一个页面的insert into 语句还是不能执行,也是出错~~~~难道access转sql server 还有别的诀窍不成?
odbc 应该怎么设置??
打开connectring应该怎能?
呵呵~~需要你的经验……或者教训~:)
================================================================CSDN 论坛助手 Ver 1.0 B0402提供下载。 改进了很多,功能完备!★ 浏览帖子速度极快![建议系统使用ie5.5以上]。 ★ 多种帖子实现界面。
★ 保存帖子到本地[html格式]★ 监视您关注帖子的回复更新。
★ 可以直接发贴、回复帖子★ 采用XML接口,可以一次性显示4页帖子,同时支持自定义每次显示帖子数量。可以浏览历史记录!
★ 支持在线检测程序升级情况,可及时获得程序更新的信息。★★ 签名 ●
可以在您的每个帖子的后面自动加上一个自己设计的签名哟。Http://www.ChinaOK.net/csdn/csdn.zip
Http://www.ChinaOK.net/csdn/csdn.rar
Http://www.ChinaOK.net/csdn/csdn.exe [自解压]
然后注意下面的问题:把access2000的数据库用sql的数据导出功能把数据表导入到sql server时,它俩在表的设计方面不能倒的完全一样,主要有如下可能:
1、你原来的ACCESS数据库中是否有“自动编号”字段,这个字段在倒到sql server后,会失去这个“自动编号”功能,需要在企业管理器把这个字段的属性定义为“标识”,“种子”为一。
2、你原来的ACCESS数据库中是否有字段定义了一些默认值,这些字段在倒到sql server后,也会失去默认值的定义,这就会导致在生成一条新纪录时遇到有些字段没有被赋值的情况,导致ASP页面程序出错! 以上的情况是我的猜测,请看看!
然后看有什么错误提示!
偶想可能是在转换的时候一些数据类型变了!