|
SQL Server 2005 installation does not enable remote connections by default (SQL 2000 and SQL 7.0 did). You must enable remote named pipes protocol on SQL server 2005 (or TCPIP connections) before it will accept connections from a remote (not on same box) client.
|
|
|
|
|
Hi gays,
I am using sql server 2005 - SSIS packages in my application. I have on dtsx package in which i am using temporary table. but it give me error. i tried to search on net. it says about "Wrok offline", "RetainSameConnection=TRUE" and "DelayValidation=TRUE " but i failed. So do anybody have idea about these? Could you tell me whole process? I am very new to sql server 2005
Thanks in Advance
|
|
|
|
|
hello
iam a programmer.
i want to convert sybase database to sql server 2000 or sql server 2005.
What i have to do.I came to know a microsoft tool is available, will that tool convert 100% of the objects like
1. Tables.
2. Indexes
3.Constraints
4. Views.
5. Stored Procedures
6. Triggers
7. Functions
8. User defined types.
can u plz tell me will the tool convert 100%
Where i have to make changes.
is there any good websites where i can found these,
answer this question
Bye
md riyasath ali
|
|
|
|
|
I think that SSIS will convert most of that for you. However, things like Stored Procedures, triggers and functions will have to be re-worked. You'd want to do that anyway so that the stored procedures can be optimised for the new platform.
|
|
|
|
|
Hi
What is SSIS i could not get u.I came to know that there is a tool of microsoft by which we can convert Sybase database to Sql server database.
The name of the tool is SSMA(Sql server migration assistant).By this we can migrate.Will this tool convert 100%.
Will Stored procedure,Triggers,Views,User defined functions,Indexex,user defined types gets converted well.
Thank u
Bye
Md Riyasath
|
|
|
|
|
md riyasath ali wrote: What is SSIS i could not get u
u = you. Please don't use SMS speak here - you are not limited to 160 characters per message.
SSIS = SQL Server Integration Services. It is the replacement to DTS (Data Transformation Services).
|
|
|
|
|
Iam writing stub functions for the mysql_fetch_row function,
I want to write values to rows inside this function such that the row has some value when the fucntion returns.
I do the following:
say in stub.c file:
char *value[10]={NULL,"12317",NULL,NULL};<br />
int j= 0;<br />
MYSQL_ROW STDCALL mysql_fetch_row(MYSQL_RES *result)<br />
{<br />
MYSQL_ROW row = 0;<br />
row = (MYSQL_ROW) value[j];<br />
j=j+1;<br />
<br />
return ( row );<br />
<br />
}
everytime the function gets hit in another main program main.c, the value written in to the row gets incrememnted.
I do a strcmp with returned value in main program main.c to see if "12317" is what is returned. But teh code breaks in strcmp line. Can anyone help me with this?
|
|
|
|
|
I posted that in the wrong forum, let me post it here
======================================================I am using a commercial grid to display my data. I don't have any problem to display the whole table to the grid. For instance, the following code displays a whole table to the grid.
grid1.SetDataBinding(table1BindingSource);
Now, I only want to display the FirstName and the LastName
I have the following in my form
table1BindingSource and db1DataSet
From db1DataSet, I can see the following by intellicense; my table names Tabl1
from intellicense I can see
Table1.FirstNameColumn and Table1.LastNameColumn;
My question, how can I use table1BindingSource and db1DataSet to display only the firstname and the lastname rather than the whole table?
|
|
|
|
|
Try this link.
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Hello to all,
I'm having kind of an issue with populating my entities.
I have a Data Access for appointments. One time I will call a stored procedure returning me only the id, time and length of the appointment. Another time I will also receive the customer and the threatments of the appointment. (Sort of an agenda/customers overview for a Pet Barber..)
I use a RunStoredProcedure method, to wich a pass the sp and the parameters.
This method uses an SqlDataReader and returns a collection of appointments (in this case).
In the method, to populate the entity, I use a PopulateEntity method, and that's where things go wrong. Since I'm not always populating the same number of properties, I sometimes call columns in the datareader that aren't there.
Now, I could solve this, checking for a null value in the PopulateEntity method, but I'd rather have a more dynamic solution in wich I can pass the Properties to fill, and their respective column.
Any nice way to do this? Can I pass object-properties by using attributes? Or am I on a wrong track here?
Any help is welcome, tnx
|
|
|
|
|
Hi Friends,
i want to move the record pointer of DataGridView using code in C#.
i m trying BindingMangerBase but the problem is this only passion of bmb changing but the record pointer of dgv is not moving.
the same is working fine with VB.NET. this is a code of VB.NET
Public Class frmTest
Dim bmb As BindingManagerBase
Dim bs As New BindingSource
Private Sub frmTest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
connDB()
End Sub
Private Sub connDB()
Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source = D:\TEMP\TestADO\DB\db1.mdb;")
Dim da As New OleDbDataAdapter("Select * From tblAdd;", cn)
Dim dt As New DataTable
Dim ds As New DataSet
da.Fill(dt)
bs.DataSource = dt
dgv.DataSource = bs
bmb = BindingContext(bs)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
bmb.Position = 0
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
bmb.Position = bmb.Position + 1
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
bmb.Position = bmb.Position - 1
End Sub
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
bmb.Position = bmb.Count - 1
End Sub
End Class
here is the code of C# which is not working fine
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace testBindings
{
public partial class Form1 : Form
{
private SqlConnection conn ;
private SqlDataAdapter da;
private DataSet ds;
public BindingSource bs;
public BindingManagerBase bmb;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
conn = new SqlConnection ("Data Source=myhome\\sqlexpress;Initial Catalog=ChickenPeoxX;Integrated Security=True");
da= new SqlDataAdapter ("select * from tblGroup;",conn );
ds= new DataSet ();
da.Fill(ds,"GROUP");
dgv.DataSource = ds.Tables[0];
bs = new BindingSource( );
bmb = BindingContext[bs];
bs.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
bmb.Position = bmb.Position+ 1;
textBox1.Text = bmb.Position.ToString() ;
}
private void button2_Click(object sender, EventArgs e)
{
bmb.Position = bmb.Position-1;
textBox1.Text = bmb.Position.ToString();
}
}
}
please help me with this ...
thnX in Advance
Regards
Sonal
.::HuNTeR::.
|
|
|
|
|
|
Muammar© wrote: saving changes using the automatically generated save button on the navigation tool strip
I think it requires adding code to update the data table adapter.
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
Thanx but i already have this:
<br />
this.Validate();<br />
this.pROFILEBindingSource.EndEdit();<br />
this.pROFILETableAdapter.Update(this.dataSet1.PROFILE);<br />
it's just not working
All generalizations are wrong, including this one!
|
|
|
|
|
and i want to share it in the forum for those who may run into the same stupid problem!!
invalid host/bind name was because i used the keyword "DESC" as a field name in the table im referencing in the database, it was stupid cuz oracle accepted it very well!! so i thought it's fine to name a field with a keyword but not the table, and what's more, it binds normally to the control when loading "which means the field name is only fine for reading!" but when trying to launch the adapter.update(dataset) you get this wonderful error that has nothing to do with the real problem!! i'v always hated oracle's error messages cuz they never lead me to the cause of the error!
cheers
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Glad you found the solution, and thanks for sharing
|
|
|
|
|
hi
can any body tell me connection string for c#.net for accessing access data base located on remote system on my lan,, i cannot create the connection strin
thanks in advance
hello
|
|
|
|
|
ghumman63 wrote: can any body tell me connection string for c#.net for accessing access data base located on remote system on my lan,, i cannot create the connection strin
That depends on your network. However, you can see examples of connection strings here[^] that should help you create the correct connection string.
|
|
|
|
|
Colin Angus Mackay wrote: you can see examples of connection strings here[^]
Dude! You beat me to it :->
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
in sql server2005 is it possible to add a new column in view,other than than select column names from table name
|
|
|
|
|
Rmesh wrote: in sql server2005 is it possible to add a new column in view,other than than select column names from table name
I don't understand what you mean. Do you want to add a column to the view that does not exist already in a table? If yes, then you can only add computed columns. The view contains no data whatsoever, it can only link to existing data therefore any column on the view must be exsting data or derived from existing data.
|
|
|
|
|
hi everyone, it's my first time here in this part of the forum and i'll be greatly thankful if i can get some help from ado experts,
im trying to connect to oracle db from c# when i get this error
(ORA-00911 Invalid Character)
ConnectMe = new OracleConnection("Data Source=orcl;Persist Security Info=True;User ID=DLDSP;Password=LIVE8;Unicode=True");
ConnectMe.Open();
OracleCommand cmdProfile = new OracleCommand("SELECT DName FROM Profile;", ConnectMe);
DAdap = new OracleDataAdapter(cmdProfile);
DSet = new DataSet();
DAdap.Fill(DSet); // **** I'm getting the error on this step **** //
please help!
All globalizations are wrong, including this one!
|
|
|
|
|
Hi Friends ,
I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody .
Can you please guide me.
Thanking you ,
Param.
param
|
|
|
|
|
param thaker wrote: I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody .
This is not possible in SQL Server 2000. It may be possible in SQL Server 2005, but I doubt it. Certainly you could use CLR stored procedures to encrypt and decrypt data, however doing so on key or indexed columns is not advisable because it will dramatically hurt the performance of your database.
|
|
|
|
|
Hi,
I installed sql server management studio 2005 in my windows 2003 OS system,at yesterday(08-Dec-2006).But today(09-Dec-2006),it is not worked.what is the reason for not working sql server management studio 2005 in my system?
Please Help me.
Thanks in Advance,
T.Rameshkumar
|
|
|
|