ADO连接到SQL Server Compact 4.0版 [英] Ado connection to SQL Server Compact Edition 4.0
问题描述
我想从一个旧的ASP经典站点连接到SQL Server精简版4.0,但我总是得到错误:
Microsoft OLE DB提供的ODBC驱动程序错误80004005
[微软] [ODBC驱动程序管理器]数据源名称未找到和指定默认驱动程序。
我试过
SCON =数据源= C:\\ TEMP \\ sqlcompact.sdf;加密数据库= TRUE;密码= TESTTEST;坚持安全信息= FALSE;
和
更新:
错误:多步OLE DB操作产生错误。检查每个OLE DB状态值,如果可用。没有工作已完成
SCON =供应商= Microsoft.SQLSERVER.CE.OLEDB.4.0;数据源= C:\\ TEMP \\ sqlcompact.sdf;密码= TESTTEST;
没有任何成功。
时一般可以从ADO连接到SQL Server CE 4.0吗?
更新:
例如code
打开连接:
暗淡SCON昏暗的GCON:集GCON =的CreateObject(ADODB.Connection)SCON =供应商= Microsoft.SQLSERVER.CE.OLEDB.4.0;数据源= C:\\ TEMP \\ sqlcompact.sdf; PWD = TESTTEST;gCon.ConnectionString = SCON
gCon.Open
gCon.Close
是的,你可以通过ADO连接到SQL CE 4。
设置Cnxn =的CreateObject(ADODB.Connection)
设置CMD =的CreateObject(ADODB.Command)
strCnxn =供应商= Microsoft.SQLSERVER.CE.OLEDB.4.0; &安培; _
数据源= C:\\ nw40.sdf;
Cnxn.Open strCnxn
cmd.ActiveConnection = Cnxn
cmd.CommandText =SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
虽然没有pRS.EOF
WScript.Echo的pRS(0)
pRS.MoveNext
WEND
有关密码保护的文件,使用:
strCnxn =供应商= Microsoft.SQLSERVER.CE.OLEDB.4.0; &安培;
_数据源= C:\\ nw40.sdf; SSCE:数据库密码=秘密
I want to connect to SQL Server Compact Edition 4.0 from an old asp-classic site but i always get the error:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. "
I tried
sCon = "Data Source=c:\temp\sqlcompact.sdf;Encrypt Database=True;Password=testtest;Persist Security Info=False;"
and
Update: Error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
sCon = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=c:\temp\sqlcompact.sdf;Password=testtest;"
without any success.
Is it generally possible to connect to SQL Server CE 4.0 from ADO?
Update: Example Code Open Connection:
dim sCon
dim gCON : set gCON=CreateObject ("ADODB.Connection")
sCon = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=c:\temp\sqlcompact.sdf;Pwd=testtest;"
gCon.ConnectionString = sCon
gCon.Open
gCon.Close
Yes, you can connect to SQL CE 4 via ADO.
Set Cnxn = CreateObject("ADODB.Connection")
Set cmd = CreateObject("ADODB.Command")
strCnxn = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;" & _
"Data Source=C:\nw40.sdf;"
Cnxn.Open strCnxn
cmd.ActiveConnection = Cnxn
cmd.CommandText = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES"
While Not pRS.EOF
WScript.Echo pRS(0)
pRS.MoveNext
wend
For password protected files, use:
strCnxn = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;" &
_ "Data Source=C:\nw40.sdf;ssce:database password=secret"
这篇关于ADO连接到SQL Server Compact 4.0版的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!