Cannot load data source sybase , cannot open file c:\sybase\OLEDB\ .ids

HI Folks,

Error : Cannot load data source sybase , cannot open file c:\sybase\OLEDB\ .ids

Weird error, I got really confused by seeing this error. Finally, I got a solution for this J

 Solution

Please have a look on to the Connection string in the web.config file, if you have given the provider name differently you will have to change to  Sybase.ASEOLEDBProvider.2

<add key="ConnStringSYB" value="Provider=Sybase.ASEOLEDBProvider.2;Server Name=servername,portno if any; Initial Catalog=dbname;User Id=id;Password=password"/>

This is most important, please check the provider name it will work

Provider=Sybase.ASEOLEDBProvider.2

Unable to start debugging on the web server. the project is not configured to be debugged

I lost my mind by searching a solution for this since I need to work on VS 2003/2005/2010 web solution, End up with above error many times and it has wasted my precious time. I do not want the same happening to anyone.

Please give the priority that is marked with High

Solution 1 [High] : Go to Inet Manager select the web site that’s created for the application, in the property select the tab ASP.NET and choose the ASP.NET version then click Ok and the most importantly you will have to do the same exercise for Default Web Site (Select the Default web site -> Property -> Select ASP.NET tab -> Choose ASP.NET version), Both should have same version.

I guess the above solution will work for many

Solution 2 [Medium]: IIS should be configured to use in Integrated Windows Authentication ( Inet manager -> Select the web site created for the application -> Properties -> Select the Directory Security Tab -> Under the Anonymous access and Authentication Control click EDIT -> make sure that check box is ticked for Integrated Windows Authentication.

There are other solutions for the above error I will post it depends on your feedback 

Error : Year, Month, and Day parameters describe an un-representable DateTime

Error : Year, Month, and Day parameters describe an un-representable DateTime

Well, I had stuck with above error and hardly wasted my half day time.

Solution 1 : You have to check the system date format ( Go to Command prompt type "Date") and SQL server date format (Type select getdate() in the Query window) format, if the system date format differs please change it according to the SQL server format.


Solution 2 : Use the below code format

string dt= DateTime.Now.ToString("MM/dd/yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo);

And then save the "dt" to the database.

The code is shown below.

       string dt= DateTime.Now.ToString("MM/dd/yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo);
       Response.Write(dt);
       SqlConnection conn = new SqlConnection("server=.;database=Test;uid=sa;pwd=issac");
       conn.Open();
       SqlCommand cmd = new SqlCommand("insert into test(dtime) values(@dt)", conn);
       cmd.Parameters.Add("@dt", SqlDbType.DateTime);
       cmd.Parameters[0].Value = dt;
       cmd.ExecuteNonQuery();
       conn.Close();

Recommendation (Not in all case, depends) : It would be a good practice to have date selection from the SQL server itself 

there was a problem getting an app domain to run the transformation from the host. the process cannot continue

there was a problem getting an app domain to run the transformation from the host. the process cannot continue

Solution for this problem 

1. 1) Try removing <NetFx40_LegacySecurityPolicy enabled="true" /> line from the devenv.exe.config file which is located "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE"
2. Try restarting the VS 
3. 3) Install the SP1 for VS 2010 

Third point worked for me but for my colleagues its 1st and 2nd. Try any one of the solution sure it works for you as well 

Good day