Is your web server out of your domain/firewall zone? Maybe you don't have access to talk on the port (default 1433). Try and open the port from a using telnet from a command prompt on the web server (XXX is the IP number of the SQL Server):
telnet XXX.XXX.XXX.XXX 1433
If you go to a blank screen then you are connected (you will have to [X] out of the app at that point). Otherwise a connect error will be displayed.
i need help look i disigned a aplication in csharp and i use crystal report
but when i instal the aplicacion run correct when i print some thins they sendme this error
ee the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
CrystalDecisions.CrystalReports.Engine.InternalException: Cannot find KeycodeV2.dll, or invalid keycode.
, EngineExceptionErrorID )
at .G(String , Int32 )
at Elias.porfavor..ctor() in C:\Documents and Settings\lobo\Mis documentos\Visual Studio Projects\Elias\porfavor.cs:line 21
at Elias.Form9.button2_Click(Object sender, EventArgs e) in c:\documents and settings\lobo\mis documentos\visual studio projects\elias\form9.cs:line 255
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I've also been facing this problem , but i found the
solution which worked for me . I donn't whether it's a perfect solution or not someone may present a better to
you. But for now you can try it .
Just uninstall dotNet Framework from the PC on which you are deploying/testing you application , Restart the PC
then again install dotNet framewok perhaps from other source , Your Pervious may not work as i think some of the libraries are missing .
Best of luck
I use the following code to move to the next record. I need to get the key field data of that record. Can someone please help, I have been reading and searching but I cannot find anything. I do not know how to use the DataRowView code, I think it gets me to the current row. But how do I get the data in a field?
I am writing an application where I am using strongly typed DataSets to define the DataTables and relations used in various parts of the application. I have code that takes these DataSets and converts the rows in the DataTables to objects which I then use in my application. The reason for using strongly typed DataSets is so if I change the database schema I only need to validate the DataSets to identify any mismatches at compilation time.
I obviously need to fill the DataSets which is currently done by creating SqlAdapters which call stored procedures to populate the DataTables within the DataSet. This means I have to keep the stored procedures in sync with the DataSets when the schema is changed. I am trying to minimise any potential bugs and so I am looking at ways to ensure the database schema, DataSets and stored procedures are kept in sync.
My current method is to use my own validation tool which performs tests on the DataSets to ensure the stored procedures correctly fill the DataSets.
Given the information contained within the DataSet I was thinking that it should be possible to "auto-generate" the SQL from the DataTables and DataRelations definitions. For a simple situation like Customers and Orders this is not difficult but I was wondering if there are any libraries or tools out there which generate SQL code from a DataSet definition given the complexity that may be involved with many tables and their relationships.
If you are talking about MS SQL Server:
Open SQL Query Analyzer, right click on your stored procedure, click on Debug. It will prompt you to input values for for the parameters, then you click Execute. It will let you single step through the stored proc, and has a window for current variable values.
If debugging is not enabled for your instance of SQL Server, you may have to install the option from cd. Also, it needs the SQL Server Agent service to be running.
To debug triggers, just write a stored proc which will cause a trigger to execute, then you can step into the trigger when debugging the stored proc.
I am need of a query to retrieve a column by trimming in a particular format.
For example I have a field called UserName. The data is as follows
Here I want a query to retrieve username data as
I have to trim the content from '(' to ')'
If you are working in .NET C# for example you will need to add the reference to the SQLXML BulkLoad 3.0 Type Library.
(from the below refeences article)
... COM and the .NET Framework are two fundamentally different approaches to application development. COM type libraries must be converted to .NET assembly metadata to achieve COM interop in .NET. By using the Visual Studio .NET IDE, this can be done automatically by following the simple steps that follow. It is assumed that MSXML is already installed.
- Begin by going to the Visual Studio .NET menu bar and selecting Project, then Add Reference.
- From the Add Reference dialog box, select Microsoft SQLXML BulkLoad 3.0 Type Library from the list, click the Select button, and click OK to complete your selection.
- The necessary metadata is automatically generated. The COM object appears as a reference in the solution explorer.
- Use the Object Browser to see what’s available in the component. Go to the menu bar and select View, Other Windows, Object Browser.
- The Object Browser shows you the interfaces and members available.
The rest of the code would be as such ...
// A SQLXMLBulkLoad3 object must be instantiated. In C# use the following code:<br />
SQLXMLBULKLOADLib.SQLXMLBulkLoad3 bulkLoadObj = new SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class();<br />
// Notice that the Object Browser reveals a ConnectionString property and an Execute method. The <br />// ConnectionString property is a valid OLE DB connection string. In this example, a connection <br />// is made to a SQL Server. Instead, the connection could have been to an <br />// Oracle server. <br />
bulkLoadObj.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost;" +<br />
"Integrated Security=SSPI;Initial Catalog=northwind";<br />
// The Execute method requires two parameters: a mapping schema file and the XML file to be bulk loaded. <br />
Can anybody show me the connection string required or point me to a link regarding this matter.
I need the public to connect to a Data Acces Page on a Web Site where the database is stored on a seperate folder.
I believe this is 3 tier connection and probibly RDS?
The ISP has provided a DSN name for DSN connection as well.