.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Problem Linking SQL 2008 with MySQL

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
 
Hi, Iam trying to add a Linked Server in sql2008 with a MySQL database. My OS is Windows SERVER 2008 64bit. My Odbc connection works just fine using mysql odbc connector 5.1 The Problem is that i cannot  establish the new linked server connection . I receive the following message : Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "B2B1". (.Net SqlClient Data Provider) Any Ideas? Thanks in advance  


View Complete Post


More Related Resource Links

MySql.Data assembly problem

  

Hi,

I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
<configuration>
    <connectionStrings>
    </connectionStrings>
    <system.web>
        <compilation>
            <assemblies>
                <add assembly="MySql.Data, Version=6.1.4.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
            </assemblies>
    </compilation></system.web></configuration>


But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?


What the problem can be?





Crystal Report vs 2003 convert to vs 2008 parameter problem

  

Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??
 

Does someone can help me solve this problem??

Thank you


Problem in Installation of SQL Server 2008

  

Dear All,

I have Sqlserver2008 setup.

It is work in wndows Xp.

But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.

Plz some buddy can help the same.


regard,

Rakesh gupta


Problem opening dotnet 1.1 projet on 2008 web server

  

 We recently upgraded to a 2008 development web server and I installed all the stuff to get dot net 1.1 app working on the server.  I can host them and they work.  My problem is that when I try to open one in VS 2003 I get the following error.  I set up the web server the same as my previous one, and I think a long time  ago I got this error when we set up current one but do not remember how to resolve it.  So I moved my project files from the old server to the new server and then I get these errors. 

 

The web Server reported the following error when attempting to create or open the Web Project located at the following url: Http://localhost:/MobTracker. 'Http/1.1 500 server error


Problem adding .NET 3.5.1 feature on Server 2008 R2

  
Having an issue with a 2008 R2 64-bit Server becoming unresponsive/locking up when trying to activate the .NET 3.5.1 feature.  Did not have any previous version of .NET installed but ran the .NET Cleanup utility and completed successfully but still have same issue.  It installed .NET 4 via the Microsoft Updates OK but still hangs part way through the 3.5.1 install via the Server Manager/Add Features.  Any ideas?  Thanks!

Deploying problem with SQL Express 2008 R2

  
Scientific software package works fine with SQL Express 2008 R2 on developing (mother) PC and Admin login mode, but difficulties are found elsewhere during installing and deploying on the client PCs.  We have used from year 2000 BDE (Borland Database Engine), which worked fine until now, but recently customers had been installing problems with Vista, Windows 7 and the local administration rights or permissions.   Thus I thought to test NT AUTHORITY\NETWORK SERVICE authentication, as this system is hopefully working again decades with coming new Windows versions. As not need to touch databases, ADO and authentication matters during last decade, I’m newbie with those topics.  Worked now few days with this problem, installed and unistalled SQL servers according to instructions, tested different connecting strings and now cannot found correction.  Solution is maybe and hopefully simple.   Attached is log data cut from (old and many times corrected) the main mother XP platform in Admin and Client (Guest) modes.  Same tests are done also with fresh XP installation on VirtualBox.  Used connecting strings are presented inside log files:           Main mother XP at Admin login:   2010-08-20 08:24:45.82 Server      Server local connection provider is ready to accept connection on [ \\.\pip

SQL 2008 Installation problem (Could not fix registry key)

  
Hello, I want to install SQL 2008 client tools on a Win 2008 machine. The machine already contains an instance of SQL 2005 Express which I don't want to unistall. The problem is that the installation wizard complains about Consistency Validation for SQL registry keys. The log shows the following: 2010-08-26 10:14:46 Slp: Could not fix registry key HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\ConnectTo. 2010-08-26 10:14:46 Slp: System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto. 2010-08-26 10:14:46 Slp:    en Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.ContainsInheritedAce(Byte[] securityDescriptor) 2010-08-26 10:14:46 Slp:    en Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.FixRegistryKey(String keyName) 2010-08-26 10:14:46 Slp:    en Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.FixRegistryKeyAndSubKeys(RegistryKey key) I have created the "ConnecTo" key, which didn't even exist. I have also tried to set premissions to HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer to "Everyone/Full Control" but the installation fails over and over. Is there anything else I could try to get the SQL tools installed? Thanks in advance.

Problem connecting to SQL Server 2008 R2 Express from Access 2007

  
I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Connection Problem with mysql and asp.net

  
i'm using this string to connect with mysql and asp.net but still agot the connection problem. the connection is not going to open............. i got the following error....... ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified please help me come from this problem "DRIVER={MySQL ODBC 3.51 Driver};DSN=sql4;SERVER=127.0.0.1:3306;DATABASE=myppw; UID=kraft; PASSWORD=myka; OPTION=3"

Compatibility problem: an "sql server 2008 R2" db backup cannot be restored to an "sql server 2008"

  
To verify if the "2008 R2" version can be restored back to a "2008" dbserver I make an experiment:  construct a database on R2 version ( version : 10.50.xxx )  and backup it; then I try to restore the db backup to a "sql server 2008" db-server ( version : 10.0.xxx ) but get failed. Error message is as shown: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.   Originally I want to upgrade a "2008" server to "2008 r2" , but this problem withdraws me: if I do so , I am afraid all the existing clientuser's dbs cannot be backed up to themselves if they don't have "2008 r2" locally:   if a database is backed up under "2008 r2" environment whereas client user only has "2008" db server, does it mean he cannot restore it anymore?   So I wonder if there is an approach that helps me to create a "backward-compatible" database; when creating database on wizard there is an option to choose "compatibility level" but I don't think it meets my requirement..    Anyone can help me on this ??    

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

  
Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

Problem with Subreports in Tablix in 2008 SQL Reporting Services

  
Hi,  I have set up a report to get data from an SQL Table to build a matrix of possible combinations of 2 products, works fine. For each combination a subreport should be called with row and colum value as parameter - also OK. But for most of the first and second column are the same column values handed to the subreport, for all other columns it works Deleting and recreating the matrix does not help   Thanks in advance

SQL Express 2008 R2 Installation problem (getting error in silent installation)

  
Hi, I create install script that will install my application and also "Microsoft SQL Server Express 2008 R2"  (32 BIT) engine + Advanced tools (without the Management Studio). It been installed successful on Windows XP SP3 but on windows 7 i get an error. The full logs and Setup configuration are in the link files below. I will be grateful for any answer. Thanks, Shai. Log Files:  - **"MySetup.ini" file:**   http://justpaste.it/MySetupini  - **"ConfigurationFile.ini" that been generate by installation:** http://justpaste.it/ConfigurationFileinitxt  - **"Summary.txt file from "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log":**  http://justpaste.it/Summarytxt  - **"Details.txt" file that been created at "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_102314":**  http://justpaste.it/Detailstxt

SQL Express 2008 R2 Installation problem (getting error in silent installation)

  
Hello, I created install script that will install SQL Server 2008 R2 on windows XP SP3, windows vista and windows 7.  One of the command that i used in the installation is for silent installation of SQL Server 2008 R2. When i install it on windows XP everything works just fine but when i try to install it on Windows 7 i get an error. What am i doing wrong? Here is the command line that i use:  "Setup.exe /ConfigurationFile=Mysetup.ini" Mysetup.ini file: -------------------------------------End of ini file --------------------------------- ;SQL SERVER 2008 R2 Configuration File ;Version 1.0, 5 May 2010 ; [SQLSERVER2008] ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will reflect the instance ID of the SQL Server instance. INSTANCEID="MSSQLSERVER" ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, and Tools. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, Business Intelligence Development Studio, and other shared components. FEATURES=SQLENGINE ; Displays the command line parameter
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend