SQLCe Errors When Doing Developing A SQL Mobile Application With Visual Studio 2005 And SQL Server 2005 Tutorial
I'm attempting to use RDA to synchronize a pocket pc emulator with SQL Server 2005 database by following tutorial http://msdn2.microsoft.com/en-us/library/aa454892.aspx, which uses AdvWorksMobile database that comes with SQL Server 2005.
When get to testing of "To test application features " ( step 4 of the merge replication setup lab ), I am receiving SQLCe Exception errors.
ORIGINALLY, I was able to deploy an application and view the local database on the emulator, but once I clicked "InitSinc" button, I received an error.
"Failure to connect to SQL Server with provided connection information. SQL Server does not" exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
Found this error listed in Server Agent Errors log http://technet.microsoft.com/en-us/library/ms172357.aspx, but it wasn't very helpful since it doesn't provide any suggestions on fixing the problems.
I am brand new to SQL CE Server , mobile programming and .NET framework in general so please bare with me
All the connections / security settings, etc that were set up were taken from a tutorial so I am not sure what SQLCeServer is complaining about. Reading up on the error on the web didn't help, it all pointed to making sure that the snapshot folder had correct permissions set up. I verified that MACHINENAMEUISR_MACHINENAME guest user had Read rights to the database so I don't think that piece is the problem. Otherwise ,Merge publication has been setup in Microsoft SQL Server Management Studio by following the tutorial.
I am trying to run this sync on my home pc so there should be no issues with any user permissions
I have IIS installed
I did NOT have SQL Server Agent running in management studio at this time
I am trying to run this tutorial on an XP machine, which is my regular home PC so I dont think there are any special networking settings to consider
I am able to hit http://localhost/AdvWorksMobile/sqlcesa30.dll from my pc OK, but when I try to hit it from a cradled emulator ( after replacing "localhost" with "MACHINE_NAME" ), Internet Explorer on the emulator gives me a "Cannot Connect With Current Settings" error message. This part wasn't part of tutorial but decided so not sure if I am supposed to be able to hit it from my emulator..so I am not sure if the fact that I can't hit it is related to the problem.
AFTER STARTING SQL SERVER AGENTin Microsoft SQL Server Management Studio, I killed the application, and after relaunching it, it hits "The Specified table does not exist [Vendor]" error. This time it doesn't even launch first - that is I dont even get to pressing "InitSinc" button. Debugger is showing that this error is hit on the following line in AdvWorksMobile.AddWorksDataSetTableAdapters
int returnValue = this.Adapter.Fill(dataTable);
I am not sure why the errors changed on me after starting SQL Server Agent.
What can I do to fix this connection problem?
Thank you so much for your help!
Irina
View Complete Forum Thread with Replies
Related Forum Messages:
How To Use SqlCE 3.5 With In Visual Studio 2005?
Dear All, I have downloaded Microsoft Synchronization Services for ADO.NET CTP from: http://www.microsoft.com/downloads/details.aspx?FamilyId=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en This download package contains the SQL Server Compact Edition 3.5 and I have installed the same. Before that I was having SqlCE 3.1 and able to work with that fine from C# application on Desktop. After installing the new one I could see V3.1 and V3.5 folders at: C:Program FilesMicrosoft SQL Server Compact Edition. But when I tried to create a new data connection from Visual Studio 2005, it directly making use of V3.1. Does anybody know how to make use of this newer version in my C# application with in Visual Studio 2005 and also enabling the same in SQL Server Management Studio? It€™s an urgent requirement for me; please do spend couple of minutes in providing the solution for this. Thanks in advance
View Replies !
Problem Mapping SQL Server Mobile And Visual Studio 2005 Dataset
I have a problem.I created a dataset in visual studio 2005 which use tables of SQLServer Mobile.When I create insert query in the relative TableAdapter, the datasetdesigner maps the type numeric of SQL Server Mobile as "Object" andnot "Decimal".The result of this is that when the debug starts there's an exceptionbecause the mapping "Object" and "Numeric" is wrong.To solve this problem I must change manually, in the dataset designercode, the mapping and change ".Object" type in ".Decimal".I must do it every time I change something in dataset because visualstudio regenerate the code of the dataset designer!!!Is there a way to correct this bug in visual studio and make themapping correct?Thanks to everyone would to answer!
View Replies !
Creating ASP.NET Web Application In Visual Studio Professional 2005
Hi All, I have installed Visual Studio 2005 (Professional Edition) on my computer. When I select create new project there is no template for ASP.NET Web Application. From File->New->Web Site I can create new web application, but when I build it, there is no compiled assembly and bin folder for the application. So, I need to deploy it with code behind file. Can any one help me to overcome this problem? Best regards, Sumit Ranjan sumit.ranjan@daaskonzern.com
View Replies !
Advice On Developing A Mobile App That Uses SQL 2005 CE
Hi, I am new to SQL 2005 CE but fairly experienced with SQL 2000 and know my way around SQL 2005. I am creating a PDA app that must support the following scenario: My company has a SQL 2000 server with a "computer assets" database. This asset database must be able to be transferred to an .sdf file (SQL 2005 mobile) on the PDA when the user docks their PDA to the desktop PC (not the same machine as the SQL 2000 server). This transfer can be via an option in the mobile app that is initiated by the user, or automatic. The mobile application basically supports stock-taking of the assets, so users go out on site and record information about the assets. This information is stored in a separate .sdf database on the PDA. When the user gets back to the office they dock with their desktop and then must transfer the data from the second .sdf database onto the SQL 200 server. Lets call this the "asset metadata". thats basically it! but im having issues finding the right process to attack the data transfer tasks. My issues: - Firstly, how do i populate the .sdf on the PDA for development purposes? Microsoft tutorials seem to be geared at SQL server 2005 management studio only. I only have SQL server 2005 Management Studio Express on my development machine as well as all the necessary SQL 2005 CE SDKs and VS2005. We do not use SQL Server 2005 at my organisation as yet and it will be some time before we migrate across. In effect im looking for something that behaves like a DTS package to transfer data across. - How to populate the "asset database" .sdf file from the SQL 2000 server when the user has docked to their desktop PC? (This needs to be refreshed ) - How to transfer the "asset metadata" from the .sdf on the PDA to the SQL server? ive looked at merge replication a little but am not sure whether this is what i need and again most online information seem to be tailored to SQL Server 2005. Can anyone kindly point me in the right direction?
View Replies !
Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application
Hello, I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database. The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration. The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK. So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h". Did I miss something to install ? Do you know how I can resolve the problem ? By advance, thank you for any answer. -- Gregoire
View Replies !
Debugging SQL Server 2005 Stored Proc With Visual Studio 2005
Hello, we have a SQL server 2005 with Visual studio Prof. 2005 in the employment. The debuggers function only in Visual studio correctly, as long as no code on the SQL server must be implemented. If a BREAK POINT in a Stored Procedure is set, this is not activated, since this cannot be bound. Does someone know, what it lies and can like one it eliminate? Thank you for your assistance in advance. Yours sincerely Big_Ben_31 This entry was translated automatically with the translation service babel.altavista.com from the German into English.
View Replies !
Installing MS Visual Studio 2005 (PE). On Vista X64 (BE) Running MS SQL Server 2005 (DE) X64
Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2. Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed? Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it. Thanks in advance to anyone who can help, Abel
View Replies !
Native Oracle SQL -&&> SQL Server 2005 CE .sdf File -&&> Using Visual Studio 2005?
I've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as: select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table There's also a CASE statement in there with some other data transformations. Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Server Compact Edition database - within an application that I'm creating in Visual Studio 2005. For whatever reason, I can't seem to do anything like that in 'bulk' and there aren't any data migration tools that work with anything other than "full" SQL Server versions. My client doesn't support SQL Server, but I can deploy my app with SQL CE. I need a 'local' copy of the database (for several reasons) and just can't seem to figure out how to make this work. I'm really going nuts. I feel like I'm soooo close when I see the data I want in the table adapter - but I can't seem to actually *move* the data over!! Can anyone help? thanks, Jon
View Replies !
Visual Studio 2005 Unable To Connect To SQL Server Express 2005
Hi, I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message, " Required Component Missing (Dialog box heading) Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251 " I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped. I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed. Thanks, CLN P.S. I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.
View Replies !
How To Slipstream Sql Server 2005 Express SP1 Into Visual Studio 2005 Setup?
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1? I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it... There's another file under that folder named sqlexpr32.exe I am wondering what it's for? Thanks in advance.
View Replies !
How To Slipstream Sql Server 2005 Express SP1 Into Visual Studio 2005 Setup?
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1? I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it... There's another file under that folder named sqlexpr32.exe I am wondering what it's for? Thanks in advance.
View Replies !
Creating A New Connection With Microsoft SQL Server 2005 Compact Edition From Visual Studio 2005 IDE
Hello, How are you? I have a problem when I try to create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE. When I€™m going to choose the data source, the SQL Server 2005 Compact Edition provider doesn€™t appear in the list. I installed the SQL Server 2005 Compact Edition from this page http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en. In the additional information says by installing SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). So, I don€™t understand why couldn€™t I create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE? I appreciate your help€¦
View Replies !
Unable To Debug SQL Server 2005 Stored Procedures From Another Workstation Running Visual Studio 2005
I'm having some problems debugging SQL Server stored procedures on a SQL Server 2005 server. I have installed Visual Studio 2005 on a workstation running Windows XP, now I'm trying to debug a ASP.Net web application that has some code that executes the stored procedures on a Windows 2003 Server running SQL Server 2005. I opened VS2005 ... created a connection to the SQL Server 2005 instance ... open the Stored procedure ... right click the stored procedure name and selected Step into Stored Procedure and the following message is displayed: Unable to start T-SQL debugging.Could not attach to SQL Server process on 'ServerName'. Any ideas. Thanks,
View Replies !
SQL Server 2005 Service Pack 2 Has Not Upgraded Visual Studio 2005 Business Intelligence Tools
Hi, I understand from previous threads that installing SQL Server 2005 Service Pack 2 on the desktop client can speed up the response rate of the Visual Studio 2005 Business Intelligence Tools. However after logging on as an administrator and installing Service Pack 2, Service Pack 2 returned no errors. However after launching Visual Studio and clicking on the about dialog box the version reported was still €œRTM.050727-4200€? where I was expecting to see €œSP.050727-7600€?. I understood that I applied the same service pack to my copy of SQL Server on my laptop and the upgrade worked successfully. Can anyone help? Thanks in advance, Kieran.
View Replies !
SQL Server 2005 Express Connectivity With Visual Studio.NET 2005
Hello I'm having a problem with the server connection and my C# code. The code executes alright but no data is entered into the database behind it. I'm pasting the connection code over here as well. The sql commands are used in the code. I think I used the sql server mobile edition which is installed along with visual studio.net 2005. Anyone know what's wrong, and can help me out? Thanks in advance.public static void storeInDb(string trackName, string artist, string albumTitle, string year, string path, uint[] fp) { string connStr="Data Source=.\SQLEXPRESS;AttachDbFilename='"+path+"\Data\ACI.mdf';Integrated Security=True;User Instance=True";SqlConnection conn = new SqlConnection(connStr); conn.Open();string sql = "INSERT INTO Clip(Song, Artist, Album, Year) VALUES('" + trackName;sql = sql + "','" + artist + "','" + albumTitle + "','" + year + "')"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); sql="SELECT max(ClipID) FROM Clip"; cmd = new SqlCommand(sql, conn);int id = Int32.Parse(cmd.ExecuteScalar().ToString());for (int i = 0; i < fp.Length; i++) { sql="INSERT INTO Hash VALUES ("+id+","+(i+1)+","+(int)fp[i]+")";cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); } conn.Close(); }
View Replies !
SQL Server 2005 Connection String In Visual Studio 2005
Hey I need to know what shall i specify in this connection string in visual studio web.confug file inorder to connect to ma registered server (locally) not directly to my dedicated server ....cuz i am facing network connection problems .... b4 i used to use this connection string : <add key="conn" value="data source=IP addresseel,1433;initial catalog=xxx;user id=username on the dedicated server;Password=password on the dedicated server;timeout=60"></add> So how can i change it ???? to be able to connect locally ???? Please Help ???! Thanks in advance Hiba
View Replies !
SQL Server 2005 Express And Visual Studio 2005 Standard
Hi everyone,I am trying to connect to SQL Server 2005 Express with Advanced Services from Visual Studio 2005 Standard Edition. I have SQL Server 2005 Standard Edition but it took up so much space and resources on my computer that I didn't want to put it back on there. So I put the SQL Express on there and while the Management Studio application connects just fine, VS 2005 will not. Oddly enough, VS 2005 connected just fine to SQL 2005 Standard. I have enabled shared memory, named pipes and TCP/IP. I have set up SQL Express to accept remote connections on named pipes and TCP/IP. And I have tried running SQL Express as the Local System Account, as a Local Service and as a Network Service. Nothing. I have tried feeding the Server Name is the Data Connections dialog in Visual Studio my SQL Express instance as (local)/SQLEXPRESS, localhost/SQLEXPRESS, and {computername}/SQLEXPRESS where {computername} is the name of my local computer which SQL Express is (allegedly) running on. And I cannot get the list of databases on that server.There is probably something very simple that I have left out. Can anyone see what it is?Thanks!
View Replies !
Connecting SQL Server 2005 Dev Edition To Visual Studio 2005
ok so i have set up SQL server 2005 on a Windows server 2003 machine. I am trying to connect to it via ODBC and/or Visual Studio 2005 on a computer running off the same switch. I have set SQL server to accept remote connections and named pipes as well as had the port unblocked. when i try and connect to it via Vista ODBC wizard or visual studio wizard it says that the server is not there or access is denied. The server is set up for SQL authentication and i am 100% pos that the username/password i am using is correct. i am at a total loss as to what to do to get my vista machine to talk to that SQL server.
View Replies !
I Need To Add A Row To A SQL CE Database If It Does Not Exists.I Am In Visual Studio 2005 Using Visual Basic 2005.
I need to add a row to a SQL CE database if it does not exists using Visual Basic 2005 in Visual Studio 2005. I can't seem to find the duplicate record using a tableadapter query. It adds the same record again. I am trying to use tableadapters, but do not have to. Any suggestions? Here is the add row code I am using... checkCustRow = PcDatabase1.MainToolData.NewMainToolDataRow() checkCustRow("Name") = "" checkCustRow("Size1") = cmbSize1 checkCustRow("Size2") = "" checkCustRow("Size3") = "" checkCustRow("Size4") = "" checkCustRow("Pressure1") = cmbPressure checkCustRow("Pressure2") = "" checkCustRow("Pressure3") = "" checkCustRow("Pressure4") = "" checkCustRow("Category") = "BOPs" checkCustRow("VSSName") = "BOPs.vss" checkCustRow("Type") = cmbType checkCustRow("Manufacturer") = "WFT" checkCustRow("Height") = cmbHeight checkCustRow("Width") = cmbWidth checkCustRow("Weight") = cmbWeight checkCustRow("VolumeOpen") = cmbOpen checkCustRow("VolumeClosed") = cmbClosed checkCustRow("EndConnection") = "" checkCustRow("Userdefined") = "T" PcDatabase1.Tables("MainToolData").Rows.Add(checkCustRow) Dim ta As New PCDatabaseTableAdapters.MainToolDataTableAdapter ta.Update(PcDatabase1.MainToolData) Any suggestions? Jeff
View Replies !
MS Visual Studio 2005 Vs SQL Server Business Intelligence Development Studio
I recently installed the Evaluation Edition of SQL Server 2005 x64 and it appears that MS Visual Studio 2005 is installed in stead of SQL Server Business Intelligence Development Studio. When I choose new project the only template available is "Blank Solution". How do I get all the templates (i.e. Analysis Server Project, Integration Services Project, Report Model Project, Report Server Wizard project, etc.)? Or would it be better to uninstall MS Visual Studio 2005 and attempt to reinstall BIDS?
View Replies !
Visual Studio 2005 Standard And SQL Server Management Studio?
I am new to visual studio and I am still not sure of all its components and features. I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio? I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional? I want to add pictures of products to my shopping site using an SQL database and I’ve been told that SQL Server Management studio is required as it is a graphical tool. How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase. Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include ‘dynamically generated’ product images if that is the correct terminology. My goodness, it seems I still have so much to learn. Thanks
View Replies !
Visual Studio 2005 And SQL Server 2005
Hi all, I have the Visual studio 2005 and the SQL server 2005 witch come with the installation CD. Is the SQL server is only for development or it can be used for production. I want to develope an ASP.NET website working with the SQL server database. Best regards...
View Replies !
How To Apply SQL Server 2005 Express SP1 To The Version Of SQL Server 2005 Express Which Installs With Visual Studio 2005?
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media. How can apply SQL Server 2005 Express SP1 to update this existing instance? Currently, if I run this query: SELECT @@version I get the following: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) After applying SP1, I should get 9.00.2047.00. Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1: http://msdn.microsoft.com/vstudio/express/sql/download/ Thank you, Bashman
View Replies !
SQL Server Mobile With Visual Studio 2003
I've recently noticed the availability of SQL Server Mobile, and would like to take advantage of some of the new features, however, I'm currently using Visual Studio 2003. The requirements state that Visual Studio 2005 is required, but I was wondering if anyone has had any success getting it to work with VS 2003? I hope that I can do this with VS 2003, but if VS 2005 will be required, I'd like to clear up a few issues before asking my workplace to fork out more money for the upgrade: What have your experiences been like in getting clients to upgrade from SQL Server CE to SQL Server Mobile? I've seen some postings regarding problems with specific devices which seem a bit worrying, but I was wondering how easy it was in general. Does SQL Server Mobile really do a good job of reclaiming wasted space? Using SqlCeEngine's Compact method has caused problems due to the required storage space to perform the operation. The documentation states that using SQL Server 2000 with SP3A is supported, but I was wondering if anyone has any experience with this? Thanks in advance, Adrien.
View Replies !
&&"Visual Studio 2005 Command Prompt&&" Missing From SQL Server 2005 Express Toolkit Install
The program shortcut "Visual Studio 2005 Command Prompt" seems to be mising from the "Visual Studio 2005 Command Prompt" Start menu added by the current Microsoft SQL Server 2005 Express Edition Toolkit. Where is it? How to workaround? I am trying to do Download details SQL Server 2005 Samples and Sample Databases (April 2006) -> GettingStartedWithSQLSamples.htm which says "a. Open a Microsoft Visual Studio 2005 command prompt. Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to Visual Studio Tools, and then click Visual Studio 2005 Command Prompt." but I can find no such command prompt within "Visual Studio Tools", only "Visual Studio 2005 Remote Debugger{, Configuration Wizard}". What's wrong? How to fix or workaround? I'd install .NET SDK 2.0 to get it's Command Prompt but that's about 570MB merely for a command prompt! Thanks for your help, -Mike Parker
View Replies !
Visual Studio 2005 Connect To SQL Server 7
Hi all, Tried this for the first time this morning using a SQLDataSource and received the message: "Database schema could not be retreived for this connection. Please make sure the connection settings are correct and that the database is online. This server version is not supported. You must have Microsoft SQL Server 2000 and later" If possible, how can I connect to the SQL Server 7 as I have a small project to complee and all the data and tables exist on our SQL Server 7 installation. Thanks for any pointers Michael
View Replies !
Sql Server 2000 And Visual Studio 2005
I can't connection with sql 2000 using visual studio 2005. Error definition : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) thank alot your interest
View Replies !
Visual Studio 2005 AND SQL Server 2000
Just installed vs 2005 and my backend is sql 2000. When I tried to deploy program in vs 2005 to connect to sql 2000, there's error "ERROR [IM002][Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified." However, if I tried to connect to through VS 2005> Tools> Connect to Database, it is successful. I've tried to copy the connection string vs 2005 shows and still cannot. The string vs 2005 shows :"Data Source=(Local);Initial Catalog=CaCStockTracker;Persist Security Info=True;User ID=sa" I've TCP/IP shared memory enabled which I read from another post. Nothing helps. Was thinking if there's anything wrong.....below is my code for sql connection: Public Shared strDBCon As String = "Provider=SQLOLEDB;Persist Security Info=True;UserID=sa;Password=sa;Initial Catalog=CaCStockTracker;Data Source=(Local)" Public Shared con_DB As New OdbcConnection Public Shared Function DBOpenDB() As Boolean Try If con_DB.State <> ConnectionState.Open Then con_DB.ConnectionString = strDBCon con_DB.Open() End If Catch ex As Exception Throw ex End Try DBOpenDB = True End Function
View Replies !
Visual Studio 2005 AND SQL Server 2000
Just installed vs 2005 and my backend is sql 2000. When I tried to deploy program in vs 2005 to connect to sql 2000, there's error "ERROR [IM002][Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified." However, if I tried to connect to through VS 2005> Tools> Connect to Database, it is successful. I've tried to copy the connection string vs 2005 shows and still cannot. The string vs 2005 shows :"Data Source=(Local);Initial Catalog=CaCStockTracker;Persist Security Info=True;User ID=sa" I've TCP/IP shared memory enabled which I read from another post. Nothing helps. Was thinking if there's anything wrong.....below is my code for sql connection: Public Shared strDBCon As String = "Provider=SQLOLEDB;Persist Security Info=True;UserID=sa;Password=sa;Initial Catalog=CaCStockTracker;Data Source=(Local)" Public Shared con_DB As New OdbcConnection Public Shared Function DBOpenDB() As Boolean Try If con_DB.State <> ConnectionState.Open Then con_DB.ConnectionString = strDBCon con_DB.Open() End If Catch ex As Exception Throw ex End Try DBOpenDB = True End Function
View Replies !
Visual Studio 2005 - Reporting Services 2005 Access Import Error
I am trying to import Access reports using Visual Studio 2005 and Access 2007. SQL Server 2005 with Reporting Services is also installed. I select Reports in the Solution Explorer and then Import Reports... Microsoft Access and browse to my Access database. After I select the database I see it open briefly as if it is trying to import the reports but then Access quickly closes and a error pops up: "You already have the database open." I have checked and double checked and the database is not open. I have even tried several different databases and the same errror occurs. Any help would be greatly appreciated.
View Replies !
SQL Server 2000 Connecting To ASP.NET(visual Studio 2005)
hello guys .. can some1 could help me the connection bw the Visual Studio 2005 and the SQL Express Edition which is there provided by the Setup only.... i am a bignner and i am doing it by my one with a reference of book called APRESS- Beginning ASP.NET 2 in c#. i hav reached to the data access part of the book , almost half completed but i got stuck here... the pubs database was not inbuilt i have made it by right-click on the "DataConnection" in the "Server Explorer" and making the new database......named "pubs" the code i hav wrote in the "Default.aspx.cs" isstring connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=pubs;";SqlConnection myConnection = new SqlConnection(connectionString); try { myConnection.Open();Label1.Text = "server version" + myConnection.ServerVersion;Label2.Text = "connection is :" + myConnection.State.ToString(); }catch (Exception err) {Label1.Text = "err reading the DataBase "; Label1.Text += err.Message; } finally { myConnection.Close();Label1.Text += "now the connection is :"; Label1.Text += myConnection.State.ToString(); } on debuging the above code the error i m geting is : err reading the DataBase (print statement) Login failed for user ''. The user is not associated with a trusted SQL Server connection (error) .now the connection is :Closed (print statement)
View Replies !
Help Me For Connecting SQL Server 2000 With ASP.NET Using Visual Studio 2005
hi I m rishabh Can some1 hel me with the connection of SQl server 2000 and visual studio 2005 for the ASP.NET web application. the Express edition was instaled on my computer with the visual studio installation but later i hav uninstalled the express edition and have now installed the 2000 sql server, but could not able to connect .. can some1 please hel me out with this... thanking you rishabh
View Replies !
SQL Server 2005 And Visual Studio @005 Connection Problem.
I installed the SQL Server 2005 Trial and am now having trouble connecting. When I bring up the ASP.NET Configuration tool and Go to "Provider configuration" "Select a single provider for all site management data" AspNetSqlProvider Test I get the following message. "Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. " I have already run the aspnet_regsql command-line utility. Can anybody give me some information on how to set this up. I am currently working with the club web site starter kit.
View Replies !
DB Connection From Visual Studio 2003 To Sql Server 2005
I have one computer running Visual Studio 2003, and another running SQL Server 2005. I am trying (unsuccessfully) to add a connection to a sqlDataAdapter from an application in the Visual Studio 2003 computer to the db on the SQL 2005 machine. If I go to the machine running sql 2005, where I am running visual Studio 2005, I can create this connection with no problems. Is there a way fromvisual Studio 2003 to create a sqlDataAdapter with a connection to SQL 2005?
View Replies !
How To Connect From Visual Studio To A Ms Sql 2005 Database On A Server
Hello, I have visual studio 2005 installed on my PC. I want to create a new website and I want the site to be connected to a MS SQL 2005 database that resides on my hosting account. I am thinking this can be done but I have watched videos, spent time looking for a site to help and I have hit a brick wall. I have no idea how to do this. Can anyone please help me with some instructions or a webpage that shows you how to do this. Thank You Joe
View Replies !
Can I Use MS SQL Server Express 2005 In Visual Studio 2003?
I have been experiencing troubles since I was decided to install SQL Server Expr 2005 in my PC, first I needed to remove the .NET framework 1.1 in my computer because it is suggested before installing sql server expr 2k5 that cause my vs.net 2003 to stop loading because sql express runs in .NET framework 2.0 and vs.net 2003 is in .Net Framework 1.1 then what I did is to install .Net Framework 1.1 in my PC together with .Net Framework 2.0 and my vs.net started runnning again. My problem now is when I try to connect to a database using Data Link Properties in the Server Explorer it says "[DBNETLIB][ConnectionOpen](Connect()).]Sql server does not exist or access denied." how could this happen if I can see the sql server in the Server Explorer in my VS.net environment? Please somebody help me I am just learning to this language and I think I cannot proceed to the next few chapters remaining because of this. Thank you very much!
View Replies !
|
TRACKER
