h1's Q&A profile
SQL Server Error when trying to connect SQL DataBase
I am using Visual Studio 2005 express and SQL Server express Find here the code : Dim MaChaineConnection As String = "Persist Security Info=False;Integrated Security=SSPI; database=BaseDonnes; server=.\SQLEXPRESS" Dim MaConnection As New SqlConnection(MaChaineConnection) Dim Instruction As String = "insert into TableNom (Nom, Prenom) values ('Name', 'FirstName')" Dim MaCommande As New SqlCommand(Instruction) MaCommande.Connection = MaConnection MaConnection.Open() MaCommande.ExecuteNonQuery() MaConnection.Close() Find here the error message : Cannot open database "BaseDonnes" requested by the login. The login failed. Login failed for user 'ASSOCLEROY\STDM'. It first s ...Show All
Visual Studio Express Editions datagridview header change
I am trying to add my own header names and have been very unsuccessful at doing this can someone point the way Thanks. Imports System.Data Imports System.Data.OleDb Public Class DatabaseClass Private theConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mail.mdb;User Id=admin;Password=;" Private theDataSet As New DataSet() Private theDataAdapter As New OleDbDataAdapter() Private theConnection As New OleDbConnection(theConnectionString) 'create our connection object Private Sub DoGetData() Dim theCommand As New OleDbCommand( "SELECT * FROM importdata" ) Dim theDataSet As New DataSet() theCommand.Connection = ...Show All
SQL Server Error in Derived Column component
I am getting this error, [Derived Column [192]] Error: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column. But I don really understand y there is a attempt to type cast at all Please advise .... thanks in advance Mark Durley wrote: You might try to putting a data conversion transform in your flow and doing an explicit convert from DT_STR to DT_WSTR for that column and see if you get a more helpful error message. I thought of this earlier and when I tried with a Data Conversion Component, I was not able to locate an option as DT_WSTR. Am I missing something here thanks for th ...Show All
Visual C++ how can i develop multi client, single server chat appilcation.
I have tried to create chat application in VC++ 6.0. i have placed a thread for listening client request in server program. After a single sending process. the server cannot receive the client data. i used CSocket class to create a socket. And i want to know which method, is better one. 1) Using Threads or 2) By capturing events. pa.chidhambaram wrote: I have tried to create chat application in VC++ 6.0. i have placed a thread for listening client request in server program. After a single sending process. the server cannot receive the client data. i used CSocket class to create a socket. And i want to know which method, is better one. 1) Using Threads or 2) By capturing events. M ...Show All
SQL Server Built-in data types in SQL Express: best practices?
Greetings, I think these should be rather simple questions, yet I spent a number of hours last night digging through the forums here and msdn and couldn't find any satisfactory answers. Basically, there tend to be types of information that are commonly saved in most databases, like names, addresses, phone numbers, email addresses, etc...and there are a variety of built in data types in SQL Server. What are the best built in datatypes for some of the common entries in a sql database. Also, there are a number of character based types and I am curious why one would be more useful in certain situations than another. Why is there char( ), nchar( ), varchar( ), nvarchar( ) and text datatypes Why so many Also, what is the "text" ...Show All
Visual Basic Determine running program
How can I determine if there's another instance of my program is running im unsure but these are sub processes created by 1 process which of course will not be caught since the process owner knows/handles these sub processes within your application and is not a real process (seperate application) ...Show All
Visual C++ Default argument and Virtual Function..........
why while run time polymorphism the default value of the base is taken not of derived.. class base { public: virtual function(int i, int j = 78) { cout<<i<<" "<<j; } }; class derived:public base { public: function(int i, int j = 55) { cout<<i<<" "<<j; } }; int main() { derived d; base *b = &d; b->function(12); } AND THE OUTPUT IS 12 78 and i think it shuld print 12 55 Because you did not declare the function as virtual in the derived class. Therefore the derived class is not overriding the base class's implementation of it. So when you call it with a "base" level reference you get the ba ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Dream Build Play Contest Question - Using languages other than C#
I've managed to use Chrome ( www.remobjects.com ) to create some small XNA demos that use the content from SpaceWars. The rules do not mention whether non C# langauges are allowed to enter the contest. Since there are several .NET 2.0 compatible compilers out there shouldn't this contest allow these entries as well as they can use both the Windows and XBox 360 XNA assemblies. Just to clarify, I have Visual C# Express and Game Studio Express installed on my machine, but am using Chrome via Visual Studion 2005 to write and compile my XNA demos and the plan is to use that combination to write future XNA games and contest entries. Could someone from the XNA contest team please clarify your position on the use of non C# languages for the Dream ...Show All
Visual C# How to raise an event
I have two forms form1 and form2, when i click a button in form2 I want form1 to do something only if a button in form2 is clicked....How do i set up basics for an event to take place in this manner any help... No event is needed in what you are trying to achieve. Create some public property or function on the form which has to work. On the other form's constructor, pass the reference of first form so it can call that function or property. Handle the Click event of the button on this form and call the othe form's function like this: mainForm.DoWork(); Cheers ;-) ...Show All
Internet Explorer Development Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I have read many articles about this and cannot seem to get this working. Server Setup: WEBSERVER: Production Web Server (W2003 Server, IIS6) DBSERVER: Production Database Server (SQL2000) DOMAINACCOUNT: Domain account Once again, I am getting the following error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I have done the following: I have added DOMAINACCOUNT into SQL Server Security and assigned ddladmin, datareader, datawriter access to the appropriate database. Give DOMAINACCOUNT access to the following directories (table 1): http://msdn2.microsoft.com/en-gb/library/aa302396.aspx In IIS enabled anonymous access an ...Show All
SQL Server Task Priority
Hi, In my Sequence container task, I have 3 data flow task ( one data flow task is based on the constraint option Expression). 3 are running simultaneously, is there a way to assign a priorty which one should finish first before the other starts. If I make all of them in one sequence then the conditional task come in between which may stop the execution of the 3rd task depending upon condition. Please Guide. HI Jamie, Please see the link below. Generate Excel File (Sequence Container) has 3 different taks, I want to control which one should be executed first. 2nd Task is conditional. http://sqljunkies.com/WebLog/photos/shafiqm/picture22272.aspx Thanks ...Show All
Windows Forms How To add data in TextBox,ComboBox To Display in DataGridView And MS-Access database
i'm a beginner , please help me about topic i use VB2005 and i try to add some data in TextBox ,ComboBox to display in DataGridView and i try to Insert that data to save in Microsoft Access but i can't do it ...Show All
Windows Forms Help in datagridview
HI.. please provide me the program to add, delete, edit and update records in datagridview.. please help check this out: http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx to add us the methods: datagridview.rows.add() or datagridview.rows.insert() to delete, you can use: datagridview.rows.remove() or datagridview.rows.removeAt() update is a pretty vague term, but you probably mean to update a cell value: datagridView.rows[rownumber].Cells.[colNumber or "colName"].value=12345 ...Show All
Visual C++ /MTd and /clr options are incompatible. Why?
Ok, here is the long story. I have a nice C++ component which statically links to about 10 libraries as well as links to ATL, C run-time library and MFC. Component is multi-threaded and it actually runs couple of threads inside but everything is nicely wrapped into one DLL which can be called from any .NET program. It was all fine until I tried to migrate this project from VS 2002 to VS 2005. After migration at first I got this message: Building MFC application with /MD (CRT dll version) requires MFC shared dll version. Please #define _AFXDLL or do not use /MD I checked settings and saw that migration changed runtime library option to Multi-threaded DLL instead of just Multi threaded. Well, I have no intention of having 10+ DLLs instead o ...Show All
Visual Basic zip files
I need my app to deal with compressed files (any format will work, zip, gzip, rar, ect) I need to -Take several files, add them to a compressed file, with a non-standard extension, instead of making it something like .zip make it something like .app so the file can be associated with my app. OR Take several files, add them to a compressed file with encryption & user specified password, with a non-standard extension, instead of making it something like .zip make it something like .app so the file can be associated with my app. -Attempt to extract the files to a temp directory for use as if they weren't encrypted, if it works then its done, if not my app will need to know then it can prompt the user for the pass ...Show All
