PHP код:
str serverName = "mySQLServer";
str baseName = "myDatabase";
str userId = "sa";
str userPassword = "12345";
CCADOConnection cn;
;
cn = new CCADOConnection();
cn.open(
"Provider=SQLOLEDB;"+
"Data Source=" + serverName + ";" +
"Initial Catalog=" + baseName + ";" +
"uid=" + userId + ";" +
"pwd=" + userPassword);
cn.connection().execute("CREATE VIEW MyView AS SELECT * FROM CustTable WHERE DataAreaId = 'dat'");
cn.close();
Поправлено: cn.connection().execute, а раньше было непраильно "cn.getConnection().execute()"