Hi
I have installed a SQL compact server 4 and cannot get a connection string to work with it.
I looked here but could not get any to work (I probably am doing something wrong)
The code below gives this error in the iis log : |5|80004005|- 80
I hope somebody can help ?
<%
Set Cnxn = CreateObject("ADODB.Connection")
Set cmd = CreateObject("ADODB.Command")
strCnxn = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=E:\Migrate to Task Manager\TriActis\TaskManager.sdf;ssce:database password=Secret"
Cnxn.Open strCnxn
cmd.ActiveConnection = Cnxn
cmd.CommandText = "SELECT * FROM tblCompany"
While Not pRS.EOF
WScript.Echo pRS(0)
pRS.MoveNext
wend
%>
I have installed a SQL compact server 4 and cannot get a connection string to work with it.
I looked here but could not get any to work (I probably am doing something wrong)
The code below gives this error in the iis log : |5|80004005|- 80
I hope somebody can help ?
<%
Set Cnxn = CreateObject("ADODB.Connection")
Set cmd = CreateObject("ADODB.Command")
strCnxn = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=E:\Migrate to Task Manager\TriActis\TaskManager.sdf;ssce:database password=Secret"
Cnxn.Open strCnxn
cmd.ActiveConnection = Cnxn
cmd.CommandText = "SELECT * FROM tblCompany"
While Not pRS.EOF
WScript.Echo pRS(0)
pRS.MoveNext
wend
%>