|
uninstall Sql Management Studio from add/remove programs
|
|
|
|
|
Why did you vote me down? It's a separate application which isn't removed when you uninstall MSSQL, it has to be uninstalled separately...
|
|
|
|
|
because i have done as what u said so many many times as i can. even i go into registry delete some KEY in LOCAL_Machine, but i can't run it after i reinstall new SQL server 2005.
|
|
|
|
|
That is no reason to down vote someone. He gave you the correct answer. It is not his fault that your system is screwed.
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.”
|
|
|
|
|
ok... u and him are good .... course of my fault....
|
|
|
|
|
"Unable to access first record" this error occur while generating crystal report. i m generating crystal report using vb.
if anybody has any solution please suggest me.
thank you
|
|
|
|
|
If you really want help, you're going to have to give everyone a bit more information than that.
|
|
|
|
|
I don't know why when I use select with ExecuteQuery my result will have repeated the lastes line.
And my friend adviced me that I should use ExecuteReader now it's work
What's the different ???
here is my code !!
public void Add()
{
if (File.Exists("" + info + ".db"))
{
sql_con = new SQLiteConnection("Data Source= " + info + ".db;Version=3;New=False;Compress=True;");
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = "drop table par ;";
sql_cmd.ExecuteNonQuery();
}
else
{
sql_con = new SQLiteConnection("Data Source= " + info + ".db;Version=3;New=True;Compress=True;");
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
}
sql_cmd.CommandText = "create table par (Date nvarchar(20), Time nvarchar(10), Linein NVARCHAR(20), Lineout NVARCHAR(20), Number NVARCHAR(20), Status nvarchar(10),Duration int(20), Cost nvarchar(20), Detail nvarchar(10), Network nvarchar(10));";
sql_cmd.ExecuteNonQuery();
StreamReader reader = new StreamReader(inputfilename);
string line = reader.ReadLine();
while (line != null)
{
string NNDuration = line.Replace("'", "''");
string Date = line.Substring(12, 8);
if (line[11] == '=')
{
string Time = line.Substring(21, 5);
string Linein = line.Substring(27, 10);
string Lineout = line.Substring(38, 1);
if (string.Compare(Lineout, "0") >= 0 && string.Compare(Lineout, "9") <= 0)
{
string Number = line.Substring(40, 20);
string Status = line.Substring(61, 3);
string NDuration = NNDuration.Substring(65, 10);
string b = NDuration.Substring(2, 2);
string c = NDuration.Substring(6, 2);
int y = Convert.ToInt32(b);
int l = Convert.ToInt32(c);
int Duration = y + l;
string OCost = line.Substring(73, 5);
string Cost = OCost.Trim();
string Detail = line.Substring(79, 3);
string Network = line.Substring(82, 8);
sql_cmd.CommandText = "insert into par values('" + Date + "','" + Time + "','" + Linein + "','" + Lineout + "','" + Number + "','" + Status + "','" + Duration + "','" + Cost + "','" + Detail + "','" + Network + "');";
sql_cmd.ExecuteNonQuery();
textBox14.Text = textBox14.Text + "\r\n" + Date + " ";
}
else
{
textBox5.Text = textBox5.Text + "\r\n" + line;
}
}
else
{
textBox5.Text = textBox5.Text + "\r\n" + line;
}
line = reader.ReadLine();
}
}
private void LoadData()
{
string CommandText = "select * from par ";
sql_cmd.ExecuteReader();
DB = new SQLiteDataAdapter(CommandText, sql_con);
DS.Reset();
DB.Fill(DS);
DT = DS.Tables[0];
dataGridView1.DataSource = DT;
sql_con.Close();
}
|
|
|
|
|
Hi,
DateReader is an forward only and read only cursor type if you are accessing data through DataRead it shows the data on the web form/control but you can not perform the paging feature on that record(because it's forward only type). Reader is best fit to show the Data (where no need to work on data)
DataAdapter is not only connect with the Databse(through Command object) it provide four types of command (InsertCommand, UpdateCommand, DeleteCommand, SelectCommand), It supports to the disconnected Architecture of .NET show we can populate the records to the DataSet. where as Dataadapter is best fit to work on data.
|
|
|
|
|
Use ExecuteNonQuery to use DML statements like insert, update, delete etc. Use ExecuteReader to use select statement for fast and forward only data retirveal from the database.
Either you love IT or leave IT...
|
|
|
|
|
i don know why i cannot login to sql server 2005 after create an file Access connect to sql server? it show message when login "TITLE: Connect to Server
------------------------------
Cannot connect to SOKHENG.
------------------------------
ADDITIONAL INFORMATION:
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.) (Microsoft SQL Server, Error: 10061)
------------------------------
but if i change server name from "Sokheng" to "Sokheng\SQLEXPRESS" it can login, but i found my database name in that.
do anybody kno why ? please show me some guid line .......
|
|
|
|
|
xingselex wrote: but if i change server name from "Sokheng" to "Sokheng\SQLEXPRESS" it can login,
"Sokheng" isn't the name of the server, but the name of the computer on which the server is installed. The name of the server-instance is "SQLEXPRESS". You'll need to specify both in order to connect. You can substitute the PC-name for an IP-address, if you want;
127.0.0.1\SQLEXPRESS You can specify the name of the instance during the installation of SQL Server.
Good luck
I are troll
|
|
|
|
|
hi!
Since VOIP is prohibited within some area, broadband internet ISPs block VOIP ports or drop VOIP signal and voice packets,so i want to wrapp the VoIP trffic into a package which can not be detected by ISP.
So can any one please help what should i do for wrapping?
Which technology should I use?(may be SSL Tunneling or any other?)
Please help me.
thanx in advance
Note:May be this is not the right forum,but i dont know which technology or programing lang i should use)
|
|
|
|
|
You stated that you want to try something that is prohibited. Ergo, everyone who helps, is helping you in breaking a law
I are troll
|
|
|
|
|
hello there!
I have an access DB filled with tables and I want to copy the tables along with the data in it to a sql server db table. Is that possible? Thanks in advance, Laziale
|
|
|
|
|
|
Dear All,
I have two Server which exists in different locations with different ip address and instance name.both servers run SQL 2005
as "Server A" IP address is 72.1.1.2 and i can access SQL Server instance as 72.1.1.2 with username and password, and the other server is 192.168.2.3 which i can access sql server instance as 192.168.2.3
I have the same database with same tables in both servers. now i want to insert the same value with a single transaction in both servers.
I mean i have a table called "tblA" with three columns in both servers.
now i want to insert in this table in both server with a single transaction.
how can i insert values into the table with one transaction.
if insertion fails rollback should occur on both servers.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
|
thx for answer,
I think you didn't understand my question, i am asking i would like use an insert statement with one transaction like let say
Begin Transaction
try
Insert into "SERVER A"."DATABASEA"."TABlEA" values (...)
Insert into "SERVER B"."DATABASEA"."TABlEA" values (...)
Commit Transaction
catch
Rollback
I want like this, but I need help how to do it?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
I believe that transactions are bound to the server, but I could be mistaken.
Are you using MSSQL? If so, you could create a linked server. That way you "link" the tables into the local database, giving you the option to select from both servers;
SELECT * FROM [Server].[Database].[Schema].[Table] I haven't tried this with transactions, but I guess that it could work, since all transactions can be handled local.
Good luck
I are troll
|
|
|
|
|
how to connect Access2007 to sql server ? i want to use Access as inter face. whenever i edit record in table in Access, it will affect to sql server directly. because in Access we can see nested table if that tables have relationship. so how to do with this ?
|
|
|
|
|
This[^] article describes the steps both for importing and for linking SQL Server data into Access 2007.
I are troll
|
|
|
|
|
I need some assistance with a small application. I need to loop through an existing array and to assign a value to it in a pattern. I thought that I could do it, but I am really at a loss as to how to proceed. I tried a wide variety of approaches but it does not yield the correct results.
As a smaller scale version of the array. Let us say that the array consists of 392 elements. The first element of the array consists of date values from 12/30/2007 and it proceeds up until 1/24/2009. The second element should be number values from 1 to 13.
The pattern is that there should be 28 values with the value 1, and then 28 values with the value 2, and then 28 values with the value of 3. This procedure continues with 28 values of the value 13. After the 28th value of 13, the numbering system should start over again with 28 values with the value of 1. This should populate all of the elements of the 392 element array.
The code below that I have written, for some reason, does not include the 28th value for each of these assignments. Also, it includes a 14th value following the last 13 value assignment. Please provide me with some assistance!
Public Function ZodiacPeriod(dteInputDate)
Dim dteStart As Date
Dim dteEnd As Date
Dim intDateCount As Integer
Dim intRow As Integer
Dim intX As Integer
Dim intCounter As Integer
Dim arrArray(392, 1)
intX = 1
dteStart = #12/30/2007#
dteEnd = #1/24/2009#
intDateCount = DateDiff("d", dteStart, dteEnd)
'Loading the array with dates
For intRow = 1 To intDateCount
arrArray(intRow, intColumn) = dteStart
dteStart = dteStart + 1
Next
'The second element value is assigned here
For intRow = 0 To 392
If intCounter <= 27 Then
If intX >= 14 Then
intX = 1
End If
intCounter = intCounter + 1
Else
intCounter = 1
If intX < 14 Then
intX = intX + 1
End If
End If
arrArray(intRow, 1) = intX
Next intRow
'Now to go through the array and return the value in the array
For intRow = 0 To 392
If arrArray(intRow, 0) = dteInputDate Then
ZodiacPeriod = arrArray(intRow, 1)
Exit For
End If
Next intRow
End Function
I have encountered problems in which a value of 14 is assigned. I have encountered problems in which the requirements are not matched. Any assistance would be appreciated.
|
|
|
|
|
Three points.
1. You fill the array with dates starting at index = 1, but with numbers starting at index = 0. Is this correct?
2. You could try something like
intRow = 0
For j = 1 to 13
for i = 1 to 28
intRow = intRow + 1
arrArray(intRow,1 ) = j
next i
next j
3. Wrong forum - there is a VB one (though people tend to be VB6 hostile, and this looks like VB6 or VBA to me.)
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
Hi all,
I have written one article. About 3 days back. But my article status is still showing PENDING. What to do next ?
Please any one reply,
Ramesh Sambari
Knowledge is like honey.
Collect it, to make life sweet.
|
|
|
|