Private Sub conSer_Click()Dim cn As ADODB.Connection
Dim rst As Recordset
Dim longitude As Double
Dim latitude As Double
Dim speed As Double
Dim slongitude As String
Dim slatitude As String
Dim sspeed As String
Set cn = New ADODB.Connection
cn.ConnectionString = "DSN=GIS;UID=sa;PWD="
cn.OpenSet rst = New ADODB.Recordset
Set rst = cn.Execute("SELECT * FROM GPSInfo")
slongitude = rst.GetString("longitude")
slatitude = rst.GetString("latitude")
sspeed = rst.GetString("speed")longitude = CDbl(Val(slongitude))
latitude = CDbl(Val(slatitude))
speed = CDbl(Val(speed))
End Sub
老是报错,说slongitude = rst.GetString("longitude")不匹配.不解.
要是把cn.ConnectionString = "DSN=GIS;UID=sa;PWD="这一句换成
cn.ConnectionString = "Driver={SQLServer};" & "Server=login.serName;" & "UID=login.userName;" & "PWD=login.userPwd;" & "Database=longin.dbName"的话,就报错:未发现数据源名称并且未指定默认驱动程序!各位老大给点建议吧!
Dim rst As Recordset
Dim longitude As Double
Dim latitude As Double
Dim speed As Double
Dim slongitude As String
Dim slatitude As String
Dim sspeed As String
Set cn = New ADODB.Connection
cn.ConnectionString = "DSN=GIS;UID=sa;PWD="
cn.OpenSet rst = New ADODB.Recordset
Set rst = cn.Execute("SELECT * FROM GPSInfo")
slongitude = rst.GetString("longitude")
slatitude = rst.GetString("latitude")
sspeed = rst.GetString("speed")longitude = CDbl(Val(slongitude))
latitude = CDbl(Val(slatitude))
speed = CDbl(Val(speed))
End Sub
老是报错,说slongitude = rst.GetString("longitude")不匹配.不解.
要是把cn.ConnectionString = "DSN=GIS;UID=sa;PWD="这一句换成
cn.ConnectionString = "Driver={SQLServer};" & "Server=login.serName;" & "UID=login.userName;" & "PWD=login.userPwd;" & "Database=longin.dbName"的话,就报错:未发现数据源名称并且未指定默认驱动程序!各位老大给点建议吧!
解决方案 »
- 大虾们 问题来啦 Listview的
- 如何获得网页的地址转向?
- class does not support Automation or does not support expected interface
- winsock的怪问题,为何就是第一个连接的客户端接收不到数据!
- 不能打开数据库 ''。应用程序可能无法识别该数据库,或文件可能损坏。
- 哪位大侠能给一个管理方面的系统 万分感谢!
- 急需高手!vb中有没有API函数可以判断本地连接,和无线网卡连接 是连的还是断开的?
- 基于vb 的solidworks 二次开发
- Vb+Sql server OLAP Server 的问题,win98如何支持更新立方体?
- 10分钟之内,快来拿分!!!
- 怎样从数据库中删除listBox中已经选中的数据?
- VB里如何弹出DOS窗口???
Dim Cn As New ADODB.Connection
Dim Rst As New Recordset
Dim longitude As Double
Dim latitude As Double
Dim speed As Double
Cn.Open "DSN=GIS;UID=sa;PWD="
'这里的字符连接串参考http://www.connectionstrings.com/获得.
Rst.Open "SELECT * FROM GPSInfo", Cn, adOpenKeyset, adLockReadOnly, adCmdText
If Rst.EOF And Rst.BOF Then
Else
longitude = Val(Rst("longitude"))
latitude = Val(Rst("latitude"))
speed = Val(Rst("speed"))
End If
Rst.Close
Set Rst = Nothing
Cn.Close
Set Cn = Nothing
End Sub^_^
1、连接串不正确,你用adodc连接一下就能得到正确的连接串
2、是否有GPSInfo这个表?是否有那三个字段?检查清楚。^_^