Populating WebMatrix SQL Server Compact -

-

are there ways populate webmatrix sql server script can test website better? need data on server. suggestions welcome.

you can use erikej's tools data existing sql server (full) database , script fill sql server compact 4 database: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html


Comments

Post a Comment

Popular posts from this blog

R List row name -

-
i have (one column) list called test in r. when view in r this: > test value 569 n 1012 y 4279 n 7588 n 3434 n 2408 y 1958 y 1251 y how reference "row name"? i.e. 569, 1012, 4279 etc. i want find example value @ "row" 1012 (which "y" here). i've tried using test[1], test[,1] etc. first column isn't column. don't know is. makes kind of sense. don't know find solution this. if test is data frame; txt <- " value 569 n 1012 y 4279 n 7588 n 3434 n 2408 y 1958 y 1251 y " test <- read.table(textconnection(txt), header = true) then, > test["1012", ] [1] y levels: n y will extract required row.
Read more

sql server - python to mssql encoding problem -

-
Image
greetings by using pymssql library, want write data mssql database encounter encoding issues. here sample code write db: # -*- coding: utf-8 -*- import _mssql .... connection info data here .... def mssql_connect(): return _mssql.connect(server=host, user=username, password=pass, database=db, charset="utf-8") con = mssql_connect() insert_ex_sql = "insert mydatabsae (id, programname, programdetail) values (1, 'test characters ÜŞiçÇÖö', 'löşüiiğĞü');" con.execute_non_query(insert_ex_sql) con.close() sadly data written db corrupted: the collacation of mssql db is: turkish_ci_as how can solved? here possible solution : the key insert_ex_sq.encode('your language encoder') . try instead: con.execute_non_query(insert_ex_sq.encode('your language encoder'))
Read more

c# - BasicHttpBinding equivalent CustomBinding using WCF Client and PHP WebService -

-
i running visual studio 2008 unit test c# webservice php using wcf , received following error: system.servicemodel.security.messagesecurityexception: http request unauthorized client authentication scheme 'anonymous'. authentication header received server 'ntlm,basic realm="(null)"'. ---> system.net.webexception: remote server returned error: (401) unauthorized.. i using windows xp sp3 machine, unit test vs 2008 , wcf connect php webservice. i have no control php webservice. cannot modify (neither configuration security). here config file client use webservice php: <system.servicemodel> <extensions> <bindingelementextensions> <add name="customtextmessageencoding" type="company.integracioneasyvista.customtextencoder.customtextmessageencodingelement,company.integracioneasyvista.customtextencoder, version=1.0.0.0, culture=neutral, publickeytoken=9744987c0853...
Read more