Databases :: Project Using Vb.net With Sql And Sql.Data.dll As A Link To The Database Not Working After Upload?
Feb 13, 2010
I have a project using vb.net with mySql and mySql.Data.dll as a link to the database. Now when I test my website from local computer and with live server connection string all works fine. The thing is, when I upload my files to the server, it gives me an error Object reference not set to an instance of an object.I have copied the mySql.data.dll file to the bin folder of my domain and the query that gives the error is a basic insert statement that works from the local machine to the live database.
View 1 Replies
Similar Messages:
Jul 31, 2010
I want to upload images in to a folder in my project and save the URL in the database.
When you add a record into my database you provide title, date added and some other details and there it a file upload control which you browser to a image and it saves the image to a folder in my project, it all works, the record is added and the image is uploaded into the folder, but the problem I have is that there is no link from the record to the image, there is no URL path saved in the record. How do I save the image in the folder and save the URL of the image to the record?
I'm using details view to insert the records and using grid view to view the records.
View 10 Replies
Mar 31, 2010
I'm currently working on an C#/ASP.NET project that will host several differents e-commerce websites, all running in the same application.I use LinqToSql (moving to PLINQO soon) to access my database. The database contains both informations on the website structure (pages, ...) and the products/orders/users data.
My question is, should I use only one database for all the websites, or sould I create a new database (same model) for every new website?I'm now using a single database (with SiteIDs in some tables) but I have a big security concern, I can't just backup/restore the database for ONE website if something goes wrong (e.g. somebody erase all the products on ONE website) and it's an important requirment of the application.
So I was wondering what are the good practices in that case? Is there big cons if splitting dbs?(I would have to make changes to several database instead of one in case of structural changes, but i guess i can make a db version/update system).How the existing CRMs are dealing with that?Is it a performance problem if a database server host a lot of different DataBases? A complex backup/restore tool would be better?
Subquestion:To make a website replication easy, I can also split the pure CMS data (Pages, Texts, ...) in one DB and the e-commerce data (products/categories/orders in another). It can be achieved by some select/insert functions but it would be easier by just copying a database of course.
View 1 Replies
May 14, 2010
I tried many times to upload a file (using ASP.NET) to a database (which is implemented using MySQL)
View 1 Replies
Feb 22, 2010
We have an Oracle 11g database with two nodes. On occasion, one of the nodes goes down and for some reason one of my applications starts throwing this exception:
Error Message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because
all pooled connections were in use and max pool size was reached.
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
Out IT group says that this is a program bug because the failover isn't working, but I am thinking that this is a function of the database.What is the cause, and if it is an application bug, what can be done code-wise to fix this problem? The connection string doesn't specify a particular node.
View 1 Replies
May 23, 2010
When I turn on Code Coverage in my test settings, on a project that references the Unity DI container I get the following error:
Cannot initialize the ASP.NET project'{Project Name}'.
The event log specifies the following reason:
Could not load file or assembly 'Microsoft.Practices.Unity, Version=2.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name signature could not be verified.
View 2 Replies
Jan 12, 2011
i like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..
View 5 Replies
Jan 30, 2010
How do I upload a file on the web server and save the link of the file in a database?
View 3 Replies
Nov 28, 2010
how can i insert a file upload template column and link it to each row because each row has a unique idi have item code column and i am listing the grid upon the item code columnso for every item code row i need to use file upload to upload it s excel sheet
View 1 Replies
Feb 17, 2010
i am working on a project and i have the data in a .csv file.
i want to know how can i retrive data from the .csv file? which control should i use that would have that function?
View 1 Replies
Jan 6, 2010
I have a parent repeater that lists the sections of the website. this repeater binds to display a table that contain another repeater of the website pages .. or may display a table that contains another two repeaters of the projects categories and sub-categories.Until now everything is going fine.
The problem comes when I try to include a query of the section ID to the link of the project categories (DataView of the projects repeaters does not contain SectionID)my question is : is there any way to call the SectionID of the first repeater in my projects categories and sub-categories repeaters?Here is my code:
[Code]....
the code behind is as follow:
[Code]....
View 8 Replies
Sep 28, 2010
<asp:TemplateField ShowHeader="false" ItemStyle-Width="50px">
<ItemTemplate>
<asp:HyperLink runat="server" NavigateUrl='<% string.Format("~/Tiff.aspx?Id={0}, Eval("ID")) %>' Target="_blank" Text="View" />
</ItemTemplate>
</asp:TemplateField>
When I m trying to click on it...It is not working or not firing any event,
May I know the reasong or any code behing is require
View 6 Replies
Mar 18, 2011
I trying to figure out why some of my link buttons that were working fine have now stoped working this also includes those in the gridview for paging.
I tried putting a new grid view in with the same results.
View 5 Replies
Jan 3, 2011
tried to use linq to oracle 10g express but it throws an error as I can make no errors because I throw
View 1 Replies
Feb 17, 2010
I have a query which return rows with specific fields
View 1 Replies
Sep 23, 2010
i am looking for a source code which will do following operation
1 it will ask user to select txt/csv file only when user click on browse
2 after this when user click on upload it should load all records into existing database table.
View 3 Replies
Dec 13, 2010
There is one oracle 11g server, I want to create connection from my .Net project. tell me the steps which I need to follow for create connection.
View 2 Replies
Jan 10, 2010
Until the Dec 29th my website was working fine. Then My fileupload problems started happening. My fileupload page would simply quit and say the page can not be found. I maximized all my timeout settings and that did not work. I called my hosting company and apparently they have no problem using my page to upload files from their geographical area. So then I concluded it might be a network problem. I ran a trace route and could not really figure out where the problem was. So, I have no idea what is going on. Is it possible that my site is being blocked by some black list out there somewhere?
View 3 Replies
Sep 23, 2010
Using C# to develop an application.I need to upload data ( which is in excel) to a sql table.
[Code]....
View 1 Replies
Jan 6, 2011
Iam using a file upload control for uploading files in my asp.net application. iam using the following code to impersonate the users who do not have permission for the files to upload. The code works fine for all the files, but it is not working for the files which are in desktop.
Code in .cs file:
System.Security.Principal.WindowsImpersonationContext impersonationContext;
impersonationContext =
((System.Security.Principal.WindowsIdentity)User.Identity).Impersonate();
//Insert your code that runs under the security context of the authenticating user here.
impersonationContext.Undo();
In web.config iam using the following:
<identity impersonate="true" />
View 1 Replies
Oct 21, 2010
I have formview , there is save linkbutton & upload control, same for insert template & edititem template. both save butons have name 'LnkSave'. without update panel it is working. but with panel not. i used trigger for control but it gives error like ' already definition for LnkSave button' . i changed name of save button in edit item template, yet it's not working.
View 3 Replies
Feb 14, 2011
website using text file to store data and display it using html codings. The requested website must be able to do the following functions:
1) Browse for template using txt file and select the txt file as template. (Font-styles, headers, tables....etc)
2) Browse for txt file that stores the data and display them in a so called table format categorized properly.
3) Able to do a search function and store the search results in a new txt file. (Which means a new txt file is created everytime someone performs a search and the search results is stored in the new created txt file)
Is there any website with informations/tutorials on these?
View 5 Replies
Feb 4, 2011
am in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:
PROCEDURE p_GetData (
ivar_id IN id_n%TYPE,
oclb_owners OUT CLOB,
onum_sqlcode OUT NUMBER,
[code]...
View 8 Replies
Mar 13, 2010
i am developing an appilication using asp.net 3.5 with c#.net and SqlServer 2005 as backend databse.
in my application i have to import the data from excel file to database. the fields in excel file and fields in databse table are same. i just want to import all data to that database table.
View 1 Replies
Nov 9, 2010
I didn know where to post this query so m posting it here
I am tryin to export the data from d database to an excel sheet m using d following stored procedure for this
[Code]....
BlogAssignment being my database name and Data_Table my table.
Trial.xls is the excel sheet where i am trying to insert the data.
I am getting the follwoing error
[Code]....
View 2 Replies
