|
Hi, I am confused now, I am not allow to use any server, I only have the option of using a network drive, currently the ACCESS DB is located there and everyone goes there to make their queries. I just want to create a better GUI using VS_C#.
My question would be now.
Is it necesary to have a server in order to use SQL Server Express?
Could it work only as a collection of data on a network-drive, so that, the DB operations would be performed on the C# application? Transactions?
|
|
|
|
|
I develop against SqlExpress 2005 and 2008, both of which run on my dev box. My data however is in all sorts of places, including network drives.
So in my scenario, each computer that will access the data needs the appropriate version of SqlExpress running on it and what you then have to do is ensure that the connectionstrings used in your applications are written in such a way as to guarantee to locate the correct database, regardless of which machine is being used.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
So what you are saying is that SQL Server Express does not need a centralized computer (server) to run.
Can I develop a distributed database?
So that, actually the DB is all over on the networked computers?
|
|
|
|
|
kikeman wrote: Can I develop a distributed database?
So that, actually the DB is all over on the networked computers?
I am sorry to say that the answer to that is beyond my knowledge. I think probably not, but cannot be sure.
If I were you I would post that as a new thread, something like "Can I do a Distributed Database with SQLExpress", or something like that.
Sorry not to be able to help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
Advantages of SQL SERVER EXPRESS EDITION
http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx[^]
Q1)Limitations of SQL SERVER EXPRESS EDITION
<a href="http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx">http:
Q2) I am planning to have around 30 persons using this DB, is this possible?
There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve acceptable response times from a SQL Server Express database.
(Obtained from SQL Server 2005 Express Edition Overview)
You may also be interested in SQL Server 2005 Features Comparison
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx[^]
Hope it helps
Niladri Biswas
|
|
|
|
|
I have a database (mssql 2005) with a table which has a datetime column. I'm trying to insert data into tha table from c# but i'm getting this exception: "Conversion failed when converting datetime from character string". Here is the code (stripped of connection declaration).
SqlParameter currentDate = new SqlParameter();
currentDate.Value = System.DateTime.Now;
currentDate.ParameterName = "@dataTrimitereService";
string insert = "INSERT INTO table(col 1, col 2, date) VALUES ('value 1', 'value 2', '@dataTrimitereService');
sqlCommand.ExecuteNonQuert(insert);
I've also tried changing regional settings and date format but no success. Thanks.
|
|
|
|
|
What is value in @dataTrimitereService?
Niladri Biswas
modified on Sunday, June 28, 2009 3:59 AM
|
|
|
|
|
it's System.DateTime.Now which returns 28.06.2009 10:30:30 (example).
|
|
|
|
|
Hi, I have created a similar kind of thing like yours.
A table with 3 fileds (COL1,COL2,Date) as
(VARCHAR(50),VARCHAR(50),DATETIME respectively)
In C# class, I have written this statement
public class DBConnectionSQL
{
string connectionPath = "Data Source=Niladri135\\SQLEXPRESS;Initial Catalog=test;Integrated Security=True";
string command = "";
public void InsertRecords()
{
SqlConnection connection = new SqlConnection(@connectionPath);
DateTime currentValue = System.DateTime.Now;
command = "Insert Into test_Datetime (COL1, COL2,DATE) values('value 1', 'value 2'," + "'" + currentValue + "'" + ")";
try
{
connection.Open();
SqlCommand cmd = new SqlCommand(command, connection);
cmd.ExecuteNonQuery();
}
catch (SqlException sqlExcep)
{
string msg = sqlExcep.Message;
}
finally
{
connection.Close();
}
}
}
And I got the correct result.
N.B.~ Check the value in the insert string in your case. Is the datetime value within single quote e.g.'6/28/2009 1:20:55 PM' ?
Hope this helps
Niladri Biswas
|
|
|
|
|
Passing the date to the select statement directly (not parameter) raises this exception: "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.\r\nThe statement has been terminated."
|
|
|
|
|
I've ran the query directly in sql and tried different date formats. It finnaly accepted "mm/dd/yyyy hh:mm:ss". How can I make c# convert into the right format without changing regional settings. My current date format (from regional settings) is dd.mm.yyyy
|
|
|
|
|
Hi,
Last day there was some problem in the afternoon in posting the message. So I was unable to reply you though I tried many times. However, I emailed you the solution.
Try with the solution which I gave . That's a running application.
N.B.~ The default DateTime format in my system is "mm/dd/yyyy hh:mm:ss"
By the way if you need to convert the date format e.g. dd.mm.yyyy to
mm/dd/yyyy hh:mm:ss, use the
DateTime.ParseExact() Method .
e.g. I want to convert from 28.06.2009 i.e. dd.mm.yyyy to
mm/dd/yyyy hh:mm:ss
string OldDateFromat = "28.06.2009";
DateTime dt = DateTime.ParseExact(OldDateFromat, "dd'.'MM'.'yyyy",
CultureInfo.InvariantCulture);
Hope this helps you.
Let me know in case of any concern
Niladri Biswas
modified on Sunday, June 28, 2009 11:25 PM
|
|
|
|
|
Niladri_Biswas wrote: The default date format in c sharps Datetime.Now is "mm/dd/yyyy hh:mm:ss".
I disagree: the default DateTime format is the one specified in your Regional Settings Control Panel, it is up to the user to choose the format he likes to use.
FYI: For data interchange, there is an IEC 8601 standard, as explained here[^].
FWIW: where ever possible, a real date or datetime field is better than a string.
Luc Pattyn [Forum Guidelines] [My Articles]
DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
|
|
|
|
|
Correct . I am sorry for my mistake . I edited that line.
Niladri Biswas
|
|
|
|
|
Thanks for your help. I've done it with DateTime.Parse() already.
|
|
|
|
|
I have been trying to solve this for quite sometime, I have google it as well. My connection string is as follows: "Data Source=xxx.xxx.8.20,1433;Network Library=DBMSSOCN;Initial Catalog=myDatabase;Trusted_Connection=Yes;"
Though my remote server is SQL 2000 Server. On my developer platform I have SQL 2005 and 2000, but whenever I debug the application, it is giving the error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
I can ping the remote server. I can also connect to the server from the studio, please what can I do to solve this problem.
Thank you in advance.
Thayhor
|
|
|
|
|
Enable the TCP/IP port.
It should have been done at the time of installation of SQL SERVER only.
However, follow these steps
1) Start Menu - > Microsoft Sql Server 2005 -> Configuration tools -> Sql Server Configuration Manager
2)Once in that window, expand the SQL Native Client Configuration node which you will find on your left side.
3) From there, choose the Client Protocols. All the client protocols, that are available in your system will be listed in the right pane.
4) Enable the TCP/IP port.
5) Re-Start the SQL SERVER Agent from the services.
Hope this helps.
Niladri Biswas
|
|
|
|
|
Thanks for your reply. I have done and enable TCP/IP several time and restart the SQL Agent before. What else can I do. I forget to mention that in my earlier post.
Thank you.
|
|
|
|
|
I cannot telnet to my remote server on port 1433. put I can ping the server. What can I do?
Thank you.
modified on Sunday, June 28, 2009 4:34 AM
|
|
|
|
|
For some reason I could not post this earlier this day.
Check to see if telnet is enabled. On the Vista OS (and WinSrv'08 I believe) telnet is disabled by default unlike XP and WinSrv'03 sp1.
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
|
Hello Thayhor,
I am also having the same issue. I am trying to build a Window application where i want to connect to a remote sql server 2000 database. Fortunately i have figured out some settings in "Surface Area Manager" of 2005, but no help regarding remote connection in sql server 2000.
Please let me know in case you have figured out the solution. Any help is highly awaited.
Regards
Sujay
|
|
|
|
|
Hi Sujay,
The default port on which SQL SERVER 2005 is running is I guess 1433.
If that is supposed to be the case, then on the same port SQL SERVER 2k cannot run.
Change the port, give Server name as [INSTANCE NAME,PORT NUMBER] and try
again.
Also check the bandwidth of the connection, since data storage and
retrieval might take a lot of time
At the same time check if the firewall is open or not!
Niladri Biswas
|
|
|
|
|
Hello Niladri,
Thanks for the quick response. Well actually i am new in developing and not having that much sense. I was wondering if you could please provide me with some detailed step by step configuration of sql server. As far as ports are concerned i think we can put it in between 1433-1444 and i have given it 1438. but still i am stuck with two errors:
A dialog box (Not from VS 2005 that's for sure) appears with the following error - Invalid Parameter and then asking to enable JIT in my machine.config file to debug the issue
Similarly another dialog box occurs this time with the error msg as Object reference not set to the instance of object. and i am sure this is also not comming from vs 2005 because i have put my code in try.... catch and have a different messagebox to display the exception.
....
Using System.Data.SqlClient;
....
....
SqlConnection oSQLConn = new SqlConnection();
.....
oSQLConn.ConnectionString = "Network Library=DBMSSOCN; Data Source=xxx.xxx.xxx.xxx,1438;Initial Catalog=databaseName;User ID=myUsername;Password=myPassword"
Please guide me further in the issue
Regards
Sujay
|
|
|
|
|
Does anyone see a problem with the following? I am getting a a mesage saying "Syntax Error" when I try to run the query to create the table.
sql = "CREATE TABLE tblPrograms ([index] Counter," & _
"[lngPlatformFK] TEXT(255) NOT NULL," & _
"[strCompany] TEXT(255)," & _
"[strProgramName] TEXT(255) NOT NULL," & _
"[strVersion] TEXT(255)," & _
"[strInfo] MEMO NOT NULL," & _
"[strURL] MEMO," & _
"[strLetter] TEXT(1) NOT NULL," & _
"[strNew] NUMBER(1)," & _
"[strMU] TEXT(1) NOT NULL," & _
"[strUpdate] TEXT(255)," & _
"[strType] TEXT(10)," & _
"[strKey] MEMO NOT NULL)"
bah10z
|
|
|
|