Windows 2000 Support

Win 2k support and VB6 samples for SQL Server Everywhere Edition (SSEv)

Steve Lasker's Web Log — Wed, 09 Aug 2006 20:36:42 GMT

The purpose of releasing the CTP of SQL Server Everywhere Edition (SSEv)&nbsp; was to get feedback.&nbsp;...

SQL Server Everywhere supporté sur Windows 2000

Christian Robert [Skweeky] — Wed, 09 Aug 2006 21:07:56 GMT

Dans la série des nouvelles sur SQL Server l'édition Everywhere qui succède aux éditions Modile de SQL...

re: Windows 2000 Support

chrislennon — Fri, 11 Aug 2006 08:05:39 GMT

Hi there

Are you able to clarify the issue of sharing a data file over a network. At the moment it seems possible to have two workstations connect to a single file and both make changes to the database. Presumably this will change in the released version?

Will you allow two people to at least read data from a single data file? Or will it simply deny access to the file for the second user

I hear what you are saying about 'backing users into a corner' - but surely you could structure something that allowed at least some flexibility in this area

Your comments most appreciated

Chris Lennon

re: Windows 2000 Support

lysy95 — Thu, 17 Aug 2006 20:49:59 GMT

Hello Sitaram!

You give ADO example here, but can you tell if ADO will be supported officially by SSEv.
Right now i'm having issues with parametrized commands dealing with strings. Below is the example in JScript:
--------------------
var sConnStr = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\\Mine\\test";
var oConn = new ActiveXObject("ADODB.Connection");
oConn.Open(sConnStr);
var oCmd = new ActiveXObject("ADODB.Command");
oCmd.ActiveConnection = oConn;
var sText = "test text";
oConn.Execute("drop table tblTest");
oConn.Execute("create table tblTest(sText nvarchar(128))");
oCmd.CommandText = "insert into tblTest(sText) values(?)";
oCmd.Parameters.Append(oCmd.CreateParameter("sText", 202, 1, 128));
oCmd.Parameters("sText") = sText;
oCmd.Execute();
--------------------
When executing the above script SSEv gives the following error message:
c:\mine\test.js(12, 1) Microsoft SQL Server 2005 Everywhere Edition OLE DB Provider: The given type name was unrecognized. [,,,,,]

I was told by some of SSEv guys that this is because of SSEv OLEDB driver specific implementation issues that ADO text types are not supported.

Now from this post i suppose that you are going to support VB6. Am i right to think that you'll fix the above issue or should i give up trying to use ADO with SSEv?

Many thanks,
Sergey.