How can i use the acrobat driver to covert web page to pdf , i have a icon on my browser. How can i use that in ASP.NET to convert the web page to pdf pro grammatically.
View 2 RepliesI am using custom richer text editor control. Its accepting .rtf & text string format as input. I need html string as input. so that converting html to rtf format. how to covert html to rtf?
View 1 Repliesi have a column in table data type of column is varchar2(30). we store datetime in that column like that (18-MAY-10 08.01.53.000000 AM) and i want to fetch only date like this format(18/05/2010).
View 2 RepliesHow to determine whether the Adobe Acrobat Reader has been installed or not on the client PC?
View 7 RepliesI am having an issue with displaying a PDF in an iframe in asp.net. When the pdf shows up it is showing up without the Acrobat toolbar that allows the user to zoom and print. This is causing a major hassle for our customers because they cannot read the PDF in the size that it is. If you try and set Acrobat to not show the PDF in the browser and browse to that page you get a message saying that it is trying to open it in Full Screen mode. how I can make it not do this from the code? Below is the code I use to stream the PDF to the browser:
Public Shared Sub StreamPdfToBrowser(ByVal doc As Document)
Dim Ctx As HttpContext = HttpContext.Current
'// Clear any part of this page that might have already been buffered for output.
Ctx.Response.Clear()
Ctx.Response.ClearHeaders()
'// Tell the browser this is a PDF document so it will use an appropriate viewer.
Ctx.Response.ContentType = doc.DisplayFileType
Ctx.Response.ContentType = "application/pdf"
Ctx.Response.AddHeader("content-type", "application/pdf")
'// IE & Acrobat seam to require "content-disposition" header being in the response. If you don't add it, the doc still works most of the time, but not always.
'// this makes a new window appear:
Response.AddHeader("content-disposition","attachment[inline]; filename=MyPDF.PDF");
Ctx.Response.AddHeader("Content-Length", doc.DisplayFile.Length)
Ctx.Response.AddHeader("Content-Disposition", "inline; filename=E-Sign Specification Report.pdf")
'// TODO: Added by KN to possibly fix UA issue
Ctx.Response.ContentType = "application/pdf"
Ctx.Response.AddHeader("content-type", "application/pdf")
'// Write the PDF stream out
Ctx.Response.BinaryWrite(doc.DisplayFile)
'// Send all buffered content to the client
Ctx.Response.End()
End Sub
I read the thread on this topic and tried using "Process.start(mypdf.pdf)" to open the PDF file. I was able to get "Process.Start()" to work perfectly within VS2008 on the built-in server but not IIS; when I am in the development environment it works great, but when I deploy the application and run it it does not work. What happens when I run outside of the development environment, I can export the PDF file to the directory on the IIS server, and the client can also delete the file from the IIS server, BUT, inbetween the export and the delete commands, I have the Process.start command so that the user can open the file and do whatever they need to do; print it, print partially or save it locally ect.
After it exports the file to the server when the exectue "Process.start" occurs, the screen just blinks and there is no error message? I tried many options using Process.StartInfo but no luck. I also tried to to use Process.Start() with a text file (.txt) and had the same result, so it doesn't look like an adobe acrobat problem. I do have acrobat running on the clients as well as the server. I don't think it is a security issue being the exporting and deleting work. Is this the wrong command to use? The web server is IIS7, I am using VS2008 VB.NET and it is a Web application. I need to demo this to the client in 4 days and I need to have this working.
we are displaying a reporting services report as a pdf document in acrobat reader. when the user clicks on the print in the acrobat reader, I will like to print the report and close the report. The user should be able to print the report only once.
View 2 RepliesI have been presented with a problem which requires me to print PDF files from a server as part of an ASP.NET web service.
The problem is further complicated by the fact that the PDF files I have to print can ONLY be printed using Adobe Reader (they were created using Adobe LiveCycle and have some strange protection in them).
This piece of code seems to do the trick in the Visual Studio development web server, but doesn't do anything when the site's running in IIS. I'm assuming this is probably some sort of permissions issue!?
Dim starter As ProcessStartInfo
Dim Prc As Process
' Pass File Path And Arguments
starter = New ProcessStartInfo("c:program files...AcroRd32.exe", "/t ""test.pdf"" ""Printer""")
starter.CreateNoWindow = True
starter.RedirectStandardOutput = True
starter.UseShellExecute = False
' Start Adobe Process
Prc = New Process()
Prc.StartInfo = starter
Prc.Start()
how can i map a network driver programmatically from my asp.net (vb) and download files from the maped driver? is there any code sample anybody can provide me
View 11 RepliesThe Error
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The Story
I've written a page outside of Visual Web Developer 2010 that uses a SqlDataSource object along with a FormView object that works perfect. Building upon those awesome skills I obtained I started to build a project within Visual Web Developer, this time creating an Empty Web Application and went along my happy way building my new site. I used the same techniques and almost the same code as before - just pointing to a different table but I was met with the aforementioned error message.
The Confusing part
Here's the puzzling part - if I take my page I wrote outside of Visual Web Developer, again - it works perfect - no complaints, and add it as a page to the project I've built it now presents the same error message and I have no idea why.
The Tests Completed
I've backed off of targeting .NET 4.0 framework and went to 2.0 as I am not using any specific 4.0 controls or methods at this time. I've taken my page that originally gave me issue and recreated it outside of a Visual Web Developer project and instead as a stand alone page and the exact same code - copy, cut, paste - works perfect!
I'm trying to connect to my local MySQL database for a web based app (running locally). The instructions say that when I open Server Explorer and add a new connection, I should see MySQL in the list and I don't. All I see are 4 x Microsoft drivers and one Oracle.
I've installed MySQL Connector 6.83 and also tried adding the MySQL drivers through Manage NuGet Packages for solution (MySQL.Data) but nothing.
System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)
[Code]...
i have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"
i need to change that to -
"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"
when i just change the text it gives this error -
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
does anybody have a link to download ODBC DLL connection to a Sybase database?
View 1 RepliesI get this error message when I connect to the data source on localhostERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedthe connection string is
connectionString="Data Source=DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;PORT=3306; DATABASE=database;UID=xxx;PWD=xxx;OPTION=3;pooling=false;"
providerName="System.Data.SqlClient"
it must be some kind of problem in the environment since the connection string works on a remote server. I downloaded the driver and added it with the Data source (ODBC) application in the control panel.
I have a ASP.NET webapplication where I use ODBCConnection to connect a MySQL server, it will take the connectionstring from the web.config file and this works grate.
But when I put the same code in a WPF application and hardcode the same connection string I get the followin exception when runnint ODBCConnection.Open() :
Data source name not found and no default driver specified
I have checked the ODBCConnection orbject and its instansiated with the exact same connectionstring as in the webapplication.
The connection string looks like this :
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=X.X.X.X;DATABASE=X;USER=X;PASSWORD=X;OPTION=3"
The X is set to propert values
I am running both from the same computer so the MYSQL ODBC connection is installed correct.
how can I do it?
View 1 RepliesProblem in my sql syntax I get the error:ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.5.9]Not unique table/alias: 'WallPosting'
string theUserId = Session["UserID"].ToString();
using (OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite2; User=x; Password=x;"))
cn.Open();
using (OdbcCommand cmd = new OdbcCommand("SELECT WallPosting.Wallpostings FROM WallPosting LEFT JOIN WallPosting ON User.UserID = WallPosting.UserID WHERE
[code]...
Iam using the DBconnection object through out my applicationI use the same as a singleton objectWhen more operations are performed on the single objectit throws an error ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.But it occurs only some timesHow to solve this?Can any property can be set to avoid this type of error.Or can i overload and write any method to avoid thisTo Identify the same i wrote some Poc and tried alsoLike opening the connection object and looping through 1000 times and creating a command object for the connection and running a query.Some times iam getting the exception and some times its running
View 7 RepliesI get an error unsure how to fix it:ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.5.9]Column 'UserID' in field list is ambiguous
pblic partial class Search : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
private void PopulateWallPosts(string search)
using (OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite2; User=root; Password=commando;"))
[code]...
I am trying to retreive data from the Access Database from my ASP.Net application.
It works when I access one table for an ExecuteScalar.
but in the following code I get this error;
Data source name not found and no default driver specified
[code]....
My code is to update a record if it already exists in database else insert as a new record. My code is as follows:
protected void Button3_Click(object sender, EventArgs e)
{
OdbcConnection MyConnection = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testcase;User=root;Password=root;Option=3;");
MyConnection.Open();
String MyString = "select fil_no,orderdate from temp_save where fil_no=? and orderdate=?";
OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
MyCmd.Parameters.AddWithValue("", HiddenField4.Value);
MyCmd.Parameters.AddWithValue("", TextBox3.Text);
using (OdbcDataReader MyReader4 = MyCmd.ExecuteReader())
{
//**
if (MyReader4.Read())
{
String MyString1 = "UPDATE temp_save SET order=? where fil_no=? AND orderdate=?";
OdbcCommand MyCmd1 = new OdbcCommand(MyString1, MyConnection);
MyCmd1.Parameters.AddWithValue("", Editor1.Content.ToString());
MyCmd1.Parameters.AddWithValue("", HiddenField1.Value);
MyCmd1.Parameters.AddWithValue("", TextBox3.Text);
MyCmd1.ExecuteNonQuery();
}
else
{
// set the SQL string
String strSQL = "INSERT INTO temp_save (fil_no,order,orderdate) " +
"VALUES (?,?,?)";
// Create the Command and set its properties
OdbcCommand objCmd = new OdbcCommand(strSQL, MyConnection);
objCmd.Parameters.AddWithValue("", HiddenField4.Value);
objCmd.Parameters.AddWithValue("", Editor1.Content.ToString());
objCmd.Parameters.AddWithValue("", TextBox3.Text);
// execute the command
objCmd.ExecuteNonQuery();
}
}
}
I am getting the error as: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,orderdate) VALUES ('04050040272009',' &' at line 1
The datatype for fields in table temp_save are:
fil_no-->INT(15)( to store a 15 digit number)
order-->LONGTEXT(to store contents from HTMLEditor(ajax control))
orderdate-->DATE(to store date)
My master page looks like:
<head runat="server">
<title>
<asp:ContentPlaceHolder ID="PageTitlePlaceHolder" runat="server" />
</title>
Content pages look like:
<asp:Content ID="TitleContent1"
ContentPlaceHolderID="PageTitlePlaceHolder" runat="Server">
My Page
</asp:Content>
This works by placing the content page specific title on the page ("My Page" in this example). Now I want to add a global prefix to the title in my master page for the site name. So I want:
<head runat="server">
<title>
Example.com:
<asp:ContentPlaceHolder ID="PageTitlePlaceHolder" runat="server" />
</title>
However, when I do this content pages are still rendered without "Example.com" in the tile, it's like it's ignored.
Why is this happening and how can I achieve this?
I want to share a common page load and page init events sequence between Master page and child page and User Control as described below:
Let us have the following components:-
1. TestMaster.master -> It is the master page
2. TestChild.aspx -> It is the Child page
3. TestUserContrl.ascx -> It is the UserControl present within the TestMaster.master page.
[code]...
I am using Master page and Content page combination.But how can i access <body> tag and it's event (onload, onunload) of Master page in .aspx page that is not a content page.
View 12 Replies