Browse by Tags

Home ›

All Tags » SQLExpress (RSS)

Moving .mdf from development to server for forms authentication

Hi all, I'm finishing up my first ASP.NET application (in C#). I've used Visual Web Developer 2008 Express Edition to build it. One page requires logging in - I was able to configure a LoginForm that worked properly on my local machine. Authentication was configured in the web configuration interface...

Posted to Security (Forum) by cgaraffa on 06-11-2009, 12:00 AM
Filed under: authentication, SQLExpress, web.confg, error 26, production server
Cannot use VWD 2008 with SQL Server 2005 Express on Vista

Hi, I had VWD 2008 Express SP1 with SQL Server 2008 Express. I uninstalled SQL 2008 and installed SQL 2005 express, but now I cannot create/database from VWD 2008. It always says SQL 2005 should work properly. My OS is Vista Enterprise. What is possibly wrong here? I have uninstalled/installed 4-5 times...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by sauravraaj on 05-02-2009, 12:00 AM
Filed under: SQLEXPRESS, sqLserver2005, Visual Web developer 2008 Express Edition, VWD 2008, "SQL Server", .net 3.5, 2005, 3.5, asp .NET 2005, asp .net sql 2005 express standard, asp.net 3.5, asp.net 3.5sp1, "ASP.NET and SQL Server"
Re: An attempt to attach an auto-named database for file C:..... failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

[quote user="Jian Kang - MSFT"] Are you trying to run the application and connect to the database while the database is been using in VWD? If so, please right-click on the data connection in Server Explorer , and chose "Close Connection", then rerun the application. [/quote] Yes ...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ingenforum on 03-05-2009, 12:00 AM
Filed under: Sql Server 2008 Express, SQLEXPRESS, Visual Web developer 2008 Express Edition
how to make SQLExpress behave like Sql2k5

I developed a web app, published on the webspace which has sql2k5 only to find out that some of the datatypes are not suported like Date. is there anyway i can make sure that what i develop on sqlexpress would work on Sql2k5? any config file changes? Or are there any way for me to test locally for 2k5

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ruchitgarg on 12-21-2008, 12:00 AM
Filed under: sql2k5, SQLEXPRESS
How to get the value of primary key to the row just added?

I am adding a row to a table A and then want to add primary key value of this row to another table. How to achieve that? I have tried SELECT SCOPY_IDENTITY(), but what i always get is number '1', which i think is number of row affected. moreover, i believe in the sql query builder of VWD, i am...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ruchitgarg on 12-21-2008, 12:00 AM
Filed under: query, SQLEXPRESS, vwd
Help needed writing query for autocomplete feature

I am trying to write a autocompelete service and looking for appriopriate query which works on SQLExpress and SQL2k5. SELECT book FROM library WHERE book LIKE @var+'%' is not accepted by Query builder in VWD+SQLExpress. I tried several other combination but nothing works out. Help Appreciated...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ruchitgarg on 12-21-2008, 12:00 AM
Filed under: query, sql2005, SQLEXPRESS, autocomplete
Re: SQL Server comparison tool

Couple of years ago I faced problem of comparing 2 sql server databases and as a result I wrote a program to do just that, SQL Server Comparison Tool (SCT) www.sql-server-tool.com Probably I am biased but I think that SCT is worth trying. SCT can compare schema and data even in dbs from different servers...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by darek on 11-05-2008, 12:00 AM
Filed under: Sql 2000, SQL 2005 SQL, sql server, sql 2000, sql 2005, SQL datatable synchronize, SQL Express 2005, SQL SERVER 2000 2005, sql server 2000 to sql server 2005, SQL Server 2005, sql server 2005 compact edition, sql server 7, sql server server, sql server2000, SQLEXPRESS, SQL Server 2005 Express, SQL Server 2005 Schema, SQL Server 2005
remote connections, sql server express and storing photos etc

i have a problem with uploading pictures to a sql express database at the line, connection.open(); i get an error that basicly says "under default settings sql server does not allow remote connections" , i have set the server to allow remote connections using the sql server surface are configuration...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Stumagoo on 10-30-2008, 12:00 AM
Filed under: sql express, SQL Express Connection Limit, SqlConnection control, sqlserver 2005, SqlServerManagementStudioExpress, connection, remore access, Remote Connection Enabled Sql 2005, sql 2005 express connect error, SQLEXPRESS, "ASP.NET and SQL Server"
Is XP_CMDSHELL available in SQL Server 2005 Express???

Hello to all, I recently posted a forum the other day asking about how to load multiple flat files to one table. http://forums.asp.net/t/1334599.aspx My question was answered, however now I have run into another issue with xp_cmdshell. Currently I am using the free version of SQL Server 2005 Express...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by xyz789 on 10-21-2008, 12:00 AM
Filed under: MySQL "MS SQL Server 2005" data import, sql express, SQL Server 2005, sql stored procedure, SQL Express 2005, sql Insert, sql insert Command, sql insertCommand, SQL Management Express, sql queries, sqLserver2005, "T-SQL", 2005, Microsoft SQL Server 2005, MS SQL Server, SQL 2005, sql 2000 "sql server express 2005", "SQL Server", SQL Server 2005, SQLEXPRESS
WHERE clause & AND Operator

I have two conditions in which both need to be met in order to be displayed on my datagrid, however, my SQL query is not returning my desired results. I have a bit column named Sailed in my tblTransit table and a StatusID in my tblWaybill table. They are joined together by a transitid. What I am trying...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bcoffey on 10-06-2008, 12:00 AM
Filed under: SQL TSQL duplicate, sql Update, sql wildcard parameter, SQL XML Stored Procedure, sql:executescalar, SQL+Hosting, sql2000, SqlBulkCopy, SqlBulkCopy SqlTransaction, SqlCacheDepenency, SqlCeDatabase, sqlclr, SqlCommand, SqlCommand Error Exception Method not found, sqlcommand parameters, sqlconnection, SqlDataReader, sqldatasourc, sqldataSource, SQLDatasource GUID, SqlDataSource Inheritance, SqlDataSource Parameter, sqldatasource parameter multiple, sqldataSource parameter Type session, sqldatasource query insert, SqlDataSource query select, SqlDataSource Repeater, SQLDataSource TimeStamp sql_variant is incompatible with timestamp, SQLDataSource Update .NET 2.0 negative return, SqlDataSource WHERE-IN, sqldatasource wizard views, sqldatasource.filterexpression, SqlDataSource.SelectCommand, sqLdatasourcecommandeventargs, SqlDataSourcource, sqldatsource selecting, sqlexception database offline, SqlExceptions, sqlhelper, sqLl, SQLL Excel ADO JET SSIS, SQLL SERVER RAM, SQLL setup, SqlNetFramework, sqlParameter class, SQLServer, sqlserver 2000, sqlserver 2005, SQLServer 2005SP2, sqLserver2005, sqlserverver, Sqlserverver 2000, sqlserverver 2000 transaction DTC ws-at atomic transaction Port 135 port135 connectivity sqltransaction system.transaction LWT 134 135 RPC API .NET2, statement, store procedure, Store procedure variable FROM clause, stored procedure case sorting direction, stored procedure for archiving the records in another table, SQL Views, SqlCommand CommandBuilder, sqldataadapter, sqldatasource datalist in datalist, SqlDataSource GridView Count, SQLDataSource parameter Type Table, sqlddatasource, SQLServere2005, SqlStoreDataSource, stored procedure, Sql Where Clause, sqLdataparametercollection, sqldatasource filter, SQLEXPRESS, SqlExpress 2005 Advanced Modifiy Database, sqlscript, standalone application, stored procedure 3

Page 1 of 3 (25 items) 1 2 3 Next >

Browse by Tags

Related Posts