|
Yes, It worked, I use Alcohol 120% for the ISO files, Thanks very much.
But Now I have a problem installed SQL Server 2008 64x on Windows 7, the installer show me some mistakes like can't install the Database Motor.
Again Thanks very much.
|
|
|
|
|
Edison1885 wrote: Now I have a problem installed SQL Server 2008 64x on Windows 7, the installer show me some mistakes like can't install the Database Motor.
I'm not sure about that one. I'm using SQL Server 2008 on
Windows 7 and I don't recall any install issues. I did
install it before Visual Studio so I wouldn't get 2005,
however. Is there another version installed?
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Ok, I go to install SQL Server 2008 32 bits on Windows 7.
Greatings and Thank you very much.
|
|
|
|
|
Edison1885 wrote: I go to install SQL Server 2008 32 bits on Windows 7.
I didn't say that. I meant I use SQL Server 2008 x64 on
Windows 7 x64 with no issues. If you're on Windows 7 x86
then you'll need to use the 32-bit SQL server.
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
No, I have Windows 7 64 bits and I can't install perfectly SQL server 2008 64 bits.
|
|
|
|
|
Make sure you have .NET framework 3.5 SP1 installed.
If you have any previous versions/instances of SQL server
installed that you aren't using, you can remove those first
as well.
But if you want to use 32-bit SQL server go right ahead
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
So...Perhaps is it, I tried install SQL Server 2005 64 bits, but I had too problems, I don't if is the DVD installer or another problem.
I go to remove some SQL Server 2005 component installed.
Thanks.
|
|
|
|
|
Maybe some info in the SQL Server 2008 SP1 release notes[^]
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Thank you, I go to see the release notes and the SQL Servers installers options this weekend.
Greatings.
|
|
|
|
|
I solved the problem, an msi file from installer was with other name.
Thanks very much.
|
|
|
|
|
I get the following error msg while compiling the code.
1. Cannot implicitly convert type 'System.Data.SqlClient.SqlDataReader' to 'System.Data.SqlClient.SqlDataAdapter'
2. 'System.Data.SqlClient.SqlDataAdapter' does not contain a definition for 'Read'
public static List<class1> GetEmp()
{
List<class1> GetEmp = new List<class1>();
SqlConnection conn = new SqlConnection(@"server=XXXX; Initial Catalog=xxxxxx");
SqlCommand cmd = new SqlCommand("Select EmpId, Name, Address from tblTemp", conn);
using (conn)
{
conn.Open();
SqlDataAdapter dr = cmd.ExecuteReader();
while (dr.Read())
{
GetEmp.Add(new Class1(dr["EmpId"].ToInt, dr["Name"].ToString(), dr["Address"].ToString()));
}
}
return GetEmp;
}
|
|
|
|
|
thecodeprojectPankaj wrote: SqlDataAdapter dr = cmd.ExecuteReader();
There's your problem. You should use this as a SqlDataReader instead.
SqlDataReader dr = cmd.ExecuteReader(); BTW - you have quite a few resource issues here - you have resources which need disposing which you haven't, you haven't closed your connection anywhere.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
|
Using .NET 3.5, SQL Server 2005 and C# 2008 Express.
Server creates instances of the server-side code.
Worked fine under XP. Upgraded to Windows 7 and the remote calls hang.
If I add code to my client which accesses the database directly (inserted before it does the remote call, it works. But not remotely through the server.
Is there something I should know about SQL Server/.NET/Windows 7?
|
|
|
|
|
The information you provided is not enough. What is your app doing and where does it hang ? And what does remote call mean, WCF, Web Service or a remoting component ?
|
|
|
|
|
Not clued up on terminology, so will give examples.
The first step that the app does is collect the username and logon, and then check if they are in the database.
I am using interfaces to the server-side code, and the server creates instances of the code like this
UserList insUserList = UserList.Instance;
ObjRef refUserList = RemotingServices.Marshal(insUserList, "UserList");
The client does a call like this
private IUserList rmUserList;
rmUserList = (IUserList)Activator.GetObject
(typeof(IUserList),
System.Configuration.ConfigurationManager.AppSettings["UserListUrl"]);
logonReturnValue = rmAllUserList.Logon(PasswordString);
UserListUrl is tcp://localhost:50050/UserList
On the server side it does (through calls to a pool of common routines, also on the server.
cnStr = "Data Source='NIGEL-PC\\SQLEXPRESS';" +
"Trusted_Connection=true;" +
"Database=timesheet";
cn = new SqlConnection(cnStr);
cmd = new SqlCommand("", cn);
da = new SqlDataAdapter();
cmd.CommandText = "SELECT Password " +
"FROM UserList " +
"WHERE UserID = 12 ";
da.SelectCommand = cmd;
tmpDS = new DataSet();
da.Fill(tmpDS, "Data");
If I run the above code snippet in ClientLogon it works. If I allow it to do the remote call, it hangs.
|
|
|
|
|
More info:
On the server side, I created a routine that only returns a string "OK", with no data access. Still hangs, so it is definitely the remoting bit, not the data access.
|
|
|
|
|
If anyone is interested, the problem was with Comodo Internet Security, even when diasabled.
|
|
|
|
|
gud morning friends
when i run my aaplication in vs 2005
i get the message
" unable to connect to vs local host web server "
i searched i foun d that thers a file callede webdev.webserver.exe
and i deleted it and copied from another system
it worked fine but only 1 time
now the same problem is occuring again
plz. do help
|
|
|
|
|
Probably you'll need to redelete and recopy every programming session.
|
|
|
|
|
Can't find it using search.
I can generate the .snk file using sn.exe -k. But I have forgotten how to generate the .pfx file. I upgraded to Windows 7 so of course I have lost it, and now when I compile I have to supply the password for every file in my solution!!
|
|
|
|
|
Hi,
I had the same problem and as far as I remember, I created a new pfx with the same name + known password and replaced it.
|
|
|
|
|
That is exactly my problem - how do I create the pfx file?
|
|
|
|
|
Create a new project (a dummy one) in the project properties go to the signing tab, click sign this assembly, under the choose name key label, select new from the combo box and create it. There is a manual way to make it from command line but right now, I can only trace back this one.
|
|
|
|
|
I am starting to remember now. And then you say "Password protect it". Ta.
|
|
|
|