|
i have created a database in sql server7.0 and now i have generated the script from sqlserver 7.0 and i have installed sql serve 8.0
if i connect the database to vb.net i got the answer lik this not associated with trusted trusted sql server connection how do mim clear the error
|
|
|
|
|
The SQL Server does not regocnise the windows account you are using. You need to setup the appropriate windows login on the SQL Server, and then associate it to the appropriate user in the individual databases.
|
|
|
|
|
we have formatted our system and we have installed sql server 2000 version 8.0
previously we have developed using version 7.0 and i have done above still i got the error like that
|
|
|
|
|
Rmesh wrote: we have formatted our system and we have installed sql server 2000 version 8.0
previously we have developed using version 7.0 and i have done above still i got the error like that
Have you tried what I asked? What have you done to "setup the appropriate windows login on the SQL Server, and then associate it to the appropriate user in the individual databases."?
|
|
|
|
|
where i a have to setup the appropriate windows login on sql server
|
|
|
|
|
In SQL Server. I'm sure you'll find it in the SQL Management Studio - In the Security or Logins section (I don't have SQL Server 2005 on this machine so I can't tell you exactly right now)
|
|
|
|
|
i found that if i change that one also but i got the same error .if i change my database from sql version 7.0 to sql version 8.0 if it work or else we have to change the coding in vb.net side
|
|
|
|
|
Sorry - Got confused. (People don't normally talk about version 8.0 and for some reason I thought you were talking about SQL Server 2005)
To set up the logins and users go into the Enterprise Manager and open your server in the tree on the left, open the Security folder and select Logins. From here you can set up the logins.
In the individual database, find the Users area and connect the login to the database user.
|
|
|
|
|
I am working on a project using ASP.NEt 2.0 and Sql server 2005.
My project is working fine but when i make release and install it. It doesnot work infact it doesnot open the connection with the database.
Do good and have good.
|
|
|
|
|
Modest Bird wrote: My project is working fine but when i make release and install it. It doesnot work infact it doesnot open the connection with the database.
Details! We need details!
What is the connection string while the site was under development, what is it when installed? What Security permissions are different between the development machine and the installed machine? What error messages do you get when it is installed?
|
|
|
|
|
My developmemnt machine and deployment machine is same.
It gives this 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" when database is hit by installed application.
Do good and have good.
|
|
|
|
|
What is your connection string?
|
|
|
|
|
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
|
|
|
|