How To Connect With SqlServer 2000 In Pocket PC 2003 Application.
How to Connect sqlServer 2000 in Pocket PC 2003 Application.
In Packet PC 2003 Application I have to connect to sql server 2000 on
my machine. The application gives error if connected using sqlConnection. Is SQL server CE necessary to connect to sql server 2000 in .Net Compact Framework?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error: System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Here is the Environment: App Server: Windows Server 2003 Standard Edition Inside Company's Firewall/ Network Database Server: Windows Server 2000 Advanced Edition SQL Server 2000 SP4 Remote Connections to the Server is checked Enable Protocols: Named Pipes & TCP/IP TCP/IP Port: 1402 (I don't know why it isn't the default of 1433) The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition. I can ping the db server from the app server using the IP address. I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server). I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP? What do I tell the network admin to change? Any help would be appreciated. Thanks, Oran
View Replies !
View Related
Can't Connect To SQL2000 On Windows 2003 Server Through UDL Of VB6 Component Of ASP Application
I have problem connecting to a SQL 2000 server that is hosted on a Windows 2003 server. My application uses classic ASP with VB6 components. VB6 components connect to SQL server and return data to ASP application. Everything was working fine when the application and SQL server was hosted on NT machine. Recently we have shifted to Windows 2003 server. Since then we could not establish connection to SQL2000. I'm using UDL as connection string. IIS and SQL2000 hosted on the same machine with Windows 2003 OS. This seems to be a security issue. Earlier I faced this issue for a .net application which I resloved adding a domain account to both SQL server and IIS directory security. Request your input to solve this problem. Sunandajit Ray Infrasoft Technologies Limited
View Replies !
View Related
Is Sqlserver 2000 Compatible With Windows 2003 ?
Hi !when installing sqlserver 2000 on a Windows 2003 server it explicitlytells "server not compatible with Windows 2003" during install, but itcan carry on.After we applied serfice pack 3a then the db server seems to runnormally, but does it risk to behave randomly afterwards ???Is sqlserver 2000 standard edition compatible with Windows 2003 server?Or does it exist a specific sqlserver edition for Win2003 ?thanks !Patrice
View Replies !
View Related
SQLServer 2000 Connected To Access 2003 - Not Updateable
I have used the Access 2003 Upsize Wizard to create SQLServer Tables, all worked fine except I cannot Update the tables from Access. The idea being to use Access Forms as the front end to an SQLserver back end as the Access database is quite complex and filled with macros and queries, not one of mine. I can update the table in SQLServer but the connected tables at the Access end are read only. Why? Kind regards, Johnv
View Replies !
View Related
Connecting To Sql Server 2005 From Pocket Pc 2003 Emulator
Hi. I have a problem. I'm working at the moment on application witch should write and read data from sql server. The application should work on windows mobile devices. I'm linking this code to event on a button: Code Block private void menuItem1_Click(object sender, EventArgs e) { SqlConnection sqlCon; sqlCon = new SqlConnection(String.Format(@"Data Source={0};Initial Catalog={1};User ID={2};Password={3}", @"192.168.54.149sqlexpress", "MojDom", "kuba", "abuk")); sqlCon.Open(); string insertString = @"insert into {0} values ('{1}', {2})"; SqlCommand cmd; cmd = new SqlCommand(string.Format(insertString, "MojDom", "Kuba", 15), sqlCon); cmd.ExecuteNonQuery(); if (sqlCon.State == ConnectionState.Open) sqlCon.Close(); } and on line sqlCon.Open() i get exception: Code Block System.Data.SqlClient.SqlException was unhandled Message="SqlException" Class=20 LineNumber=0 Number=6 Procedure="ConnectionOpen (Connect())." Server="192.168.54.149\SQLEXPRESS" Source=".Net SqlClient Data Provider" State=0 StackTrace: at System.Data.SqlClient.SqlConnection.OnError() at System.Data.SqlClient.SqlInternalConnection.OnError() at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Connect() at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor() at System.Data.SqlClient.SqlConnection.Open() at AIHouse.FormMain.menuItemSettings_Click() at System.Windows.Forms.MenuItem.OnClick() at System.Windows.Forms.Menu.ProcessMnuProc() at System.Windows.Forms.Form.WnProc() at System.Windows.Forms.Control._InternalWnProc() at Microsoft.AGL.Forms.EVL.EnterMainLoop() at System.Windows.Forms.Application.Run() at AIHouse.Program.Main() And when im using exactly the same code in windows console application everytihng works fine when i run it on pc with sql server and emulator, or other pc connect to network. I'm working on emulator of Pocket PC 2003, I've "put" it in cardle and the emulated device has connection to my pc and internet, the firewall is off. I really dont have any idea why it's not working. sorry for my english, but its not my foreign language. thx for sugestions and reply. regards Kuba
View Replies !
View Related
Need Help To Get Visual Studio 2003 To Connect To SQL Server 2000
I need help setting up my laptop so that I can develop using Visual Studio 2003 and SQL Server 2000. I currently have both installed on my laptop but can not get them to play nicely together. Here is my connection code: //string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; //strConnection += @"Data Source=C:BegASPNET11ch12Northwind.mdb"; //Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=guest;Initial Catalog=Volkswagen;Data Source=DEREKLAPTOP;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DEREKLAPTOP;Use Encryption for Data=False;Tag with column collation when possible=False string strConnection = "Provider=SQLOLEDB.1"; strConnection += @"Data Source=C:Program FilesMicrosoft SQL ServerMSSQLDataorthwnd.mdf"; ////strConnection += @"Data Source=DEREKLAPTOP"; data_src.Text = strConnection; string strSQL = "SELECT FirstName, LastName FROM Employees"; DataSet objDataSet = new DataSet(); OleDbConnection objConnection = new OleDbConnection(strConnection); OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection); objAdapter.Fill(objDataSet, "Employees"); DataView objDataView = new DataView(objDataSet.Tables["Employees"]); dgNameList.DataSource=objDataView; dgNameList.DataBind(); Here is the error message I get in IE: No error information available: REGDB_E_CLASSNOTREG(0x80040154). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154). Source Error: Line 18: OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection); Line 19: Line 20: objAdapter.Fill(objDataSet, "Employees"); Line 21: DataView objDataView = new DataView(objDataSet.Tables["Employees"]); Line 22: dgNameList.DataSource=objDataView; Source File: C:BegASPNET11ch12datagrid.aspx Line: 20 Stack Trace: [OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).] [InvalidOperationException: The 'SQLOLEDB.1Data Source=C:Program FilesMicrosoft SQL ServerMSSQLDataorthwnd.mdf' provider is not registered on the local machine.] System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) +81 System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) +107 System.Data.OleDb.OleDbConnection.Open() +203 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36 ASP.datagrid_aspx.Page_Load() in C:BegASPNET11ch12datagrid.aspx:20 System.Web.Util.ArglessEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +10 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 I know that my problem is in the @DataSource part of the connection string. It works if I use the first two lines (the database file is in the same folder as the code). But not when I use it as above. I think I'm pointing to the wrong place, but I can't figure out the right place to point to. I have SQLServer running on my laptop (I think), so can anyone help me out or maybe give me some example connection strings that you have used? Thanks. Derek
View Replies !
View Related
Pocket PC Application Cannot Push Data
I have a Pocket PC application (VS2005, SQLCE 2005, Windows Moblile 5.0, SQL Server 2000) that can pull data with no problem but produces an error when an RDA push is attempted. The error message is: Error Code: 80072EE4 Minor Err: 28037. The information in TechNet has description of : A request to send data to the computer running IIS has failed. For more information, see HRESULT. It does produce a log in the folder for SQLCE 3.0 and has the following message: Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1. Not sure if this means anything because I can't find much information on it. Anyone have any ideas on what this could be? Do I display the HRESULT the message mentions in Visual Studio debug? We have this working on our development server so I am not sure what is different here.
View Replies !
View Related
Connect To SQL Server 2000 Through An ASP.NET Web Application
Hi!I am going to connect to "SQL Server 2000" through an "ASP.NET Web Application". My development environment is "Visual Studio .NET 2003". In my "Toolbox" -> "Data", I drag a "SqlConnection" and drop on the page. It would automatically be named "SqlConnection1". In its "Properties" -> "ConnectionString" -> "<New Connection...>", I would enter my Server Name (SAMIEI), select "Use Windows NT Integrated Security" and Select the Database on the Server (Northwind). Then such Connection String would automatically be generated: "workstation id=SAMIEI;packet size=4096;integrated security=SSPI;data source=SAMIEI;persist security info=False;initial catalog=Northwind" Now, I may see "SAMIEI.Northwind.dbo" in the "Data Connections" row of "Server Explorer" with its all "Database Diagrams", "Tables", "Views", "Stored Procedures" and "Functions".Please take a look at the following code: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try SqlConnection1.Open() Catch ex As SqlException Response.Write(ex.Message) End Try End Sub It would unexceptedly encounter such error: "Login failed for user 'NT AUTHORITYNETWORK SERVICE'" Please tell me the reason. I am much obliged to you for your attention. Regards!M.Sadegh Samiei
View Replies !
View Related
Unable To Connect To Sqlserver 2000 From Sqlserver2005
Hi, iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Unable to connect to Sqlserver 2000 which is installed remotely ....Sqlserver2000 is dev edition.i cudnot find Sqlserver2000 instance when i try to search for Network database engine name ....... I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
View Replies !
View Related
Sdf File Edited In SQL Server Managment Studio Crashes My Pocket Pc Application.
I have a sql server ce db file that I use in my pocket pc application. It seems to be working until I try to edit my .sdf file in SQL Server (2005) Managment Studio. After this I cannot open modified file in my application. I receive native exception error when I call Open method for Connection object: ExceptionCode: 0xc0000005 ExceptionAddress: 0x03f8aaac Reading: 0x00000010 When I edit .sdf file in another pc it's all working. My config is: windows vista business .net compact framework 2.0 sp2 sql server 2005 sql server 2005 compact edition sql server 2005 compact edition server tools sql server 2005 compact edition tools for visual studio 2005 Best regards
View Replies !
View Related
I Fail To Make Priviligies For The Connection In ADO To Connect To Sqlserver 2000
hi .. i make 2 users in sqlserver and make 2 programs every one of them use an account of them i try to use sharedenyread for the connection in ADO in the 2 programs that accesses the same table in the same database and every one of them has sharedenyread . but both of them accesses that table and read from it !! how can i make priviligies for each user connect to that table ex. i want some one as admin other one read and write and no delete other readonly other nothing and so on ,, how can i do that by any way thanks in advance.
View Replies !
View Related
Can Not Connect To Desktop Sql Database From Mobile Device (Pocket PC)
Hi, I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot. Imports System.IO Imports System.Data Imports System.Data.SqlClient Imports System.Math Imports System.Drawing Imports System Public Class Form1 Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks" Dim strQuery As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label1.Text = "Hello, Clicking after." ReadOrderData() End Sub Private Sub ReadOrderData() Dim queryString As String = "select * from Person.Address where AddressID < '10'" Using connection As New SqlConnection(strConnection) Dim command As New SqlCommand(queryString, connection) connection.Open() Dim reader As SqlDataReader = command.ExecuteReader() While reader.Read() MsgBox(String.Format("{0}, {1}", _ reader(0), reader(1))) End While reader.Close() End Using End Sub End Class
View Replies !
View Related
Error Inserting Image Into SQL Server2000 Table From Pocket PC Application Only When Using Stored Procedure In Table Adapter Wiz
My Pocket PC application exports signature as an image. Everything is fine when choose Use SQL statements in TableAdapter Configuration Wizard. main.ds.MailsSignature.Clear(); main.ds.MailsSignature.AcceptChanges(); string[] signFiles = Directory.GetFiles(Settings.signDirectory); foreach (string signFile in signFiles) { mailsSignatureRow = main.ds.MailsSignature.NewMailsSignatureRow(); mailsSignatureRow.Singnature = GetImageBytes(signFile); //return byte[] array of the image. main.ds.MailsSignature.Rows.Add(mailsSignatureRow); } mailsSignatureTableAdapter.Update(main.ds.MailsSignature); But now I am getting error "General Network Error. Check your network documentation" after specifying Use existing stored procedure in TableAdpater Configuration Wizard. ALTER PROCEDURE dbo.Insert_MailSignature( @Singnature image ) AS SET NOCOUNT OFF; INSERT INTO MailsSignature (Singnature) VALUES (@Singnature); SELECT Id, Singnature FROM MailsSignature WHERE (Id = SCOPE_IDENTITY()) For testing I created a desktop application and found that the same Code, same(Use existing stored procedure in TableAdpater Configuration Wizard) and same stored procedure is working fine in inserting image into the table. Is there any limitation in CF? Regards, Professor Corrie.
View Replies !
View Related
MSSQServer 2000 For Pocket Pc
Hi to all. I have a windows ce mssqlserver 2000 version. I have writted a java application and i needed a database connection. I wish a driver for execute the connection to mssql server 2000 into pocket pc. The connection string that i use is connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa"); Ok? Which are the driver that i needed? Thanx, Simona
View Replies !
View Related
Issue With 2003 Virtual Server And ASP.NET 2.0 Application
I'm using Sql server 2005 Express. my connection string is as fallows: Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ccinfo.mdf;Integrated Security=True;User Instance=True When testing this website on my local computer everything works fine. But then I uploaded it to my server... dun dun dun.... Its a godaddy virtual server running windows server 2003. When I try to connect to the database stored in my app_data folder I get this error message: 'Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. ' What does this mean?
View Replies !
View Related
TSQL + VBA Excel 2003 - Importing Data From MS Excel 2003 To SQL SERVER 2000 Using Multi - Batch Processing
Hi, I need to import an SQL string from MS Excel 2003 to SQL SERVER 2000. The string I need to import is composed by 5 different several blocks and looks like: Code Snippet CommandLine01 = "USE mydb" CommandLine02 = "SELECT Block ..." CommandLine03 = "GO ALTER TABLE Block... GO" CommandLine04 = "UPDATE Block..." CommandLine05 = "SELECT Block..." The detail of the SQL string is at: http://forums.microsoft.com/msdn/showpost.aspx?postid=2093921&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1 I am trying to implement OJ's suggestion: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2117223&SiteID=1 to use multi - batch processing to import the string to SQL SERVER, something like: Code Snippet Dim SqlCnt, cmd1, cmd2, cmd3 'set the properties and open a connection cmd1="use my_db" cmd2="create table mytb" cmd3="insert into mytb" SqlCnt.execute cmd1 SqlCnt.Execute cmd2 SqlCnt.Execute cmd3 Below is the code (just partial) I have, and I need help to complete it. Thanks in advance, Aldo. Code Snippet Function TestConnection() Dim ConnectionString As New ADODB.Connection Dim RecordSet As New ADODB.RecordSet ConnectionString = "Driver={SQL Server};Server=myServer;Database=myDBName;Uid=UserName;Pwd=Password" ConnectionString.Open CmdLine01 = " USE " & myDB CmdLine02 = " SELECT ACCOUNTS.FULLNAME FROM ACCOUNTS" ... CmdLine03 = "GO ALTER TABLE Block... GO" CmdLine04 = "UPDATE Block..." CmdLine05 = "SELECT Block..." RecordSet.Open CmdLine01, ConnectionString RecordSet.Open CmdLine02, ConnectionString ConnectionString.Execute CmdLine01 ConnectionString.Execute CmdLine02 'Retrieve Field titles For ColNr = 1 To RecordSet.Fields.Count ActiveSheet.Cells(1, ColNr).Value = RecordSet.Fields(ColNr - 1).Name Next ActiveSheet.Cells(2, 1).CopyFromRecordset RecordSet 'Close ADO objects RecordSet.Close ConnectionString.Close Set RecordSet = Nothing Set ConnectionString = Nothing End Function
View Replies !
View Related
Win 2003 X64 + SQL 2005 &< Win 2003 32 + SQL 2000?
I may not be the best forum for this post, however I believe some onecan still help me or direct me somewhere else.I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003and SQL 2000.Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array.Windows Enterprise 2003 x64 final release. SQL Server 2005 enterpriseCTP.Machine B: Opeteron 2.2 (248) w/ 2 CPUs. 4GB Memory. IDE Drives.Windows Server 2003 (32bit) and SQL Server 2005 (standard).I'm using Cognos' DecisionStream as the ETL tool (32bit). I have theidentical job on both machines. Machine A is slower to do my nightlybuild (1h 20m) vs. Machine B (50m).I've done no tweaking of the databases. I Used SQL 2005's studio tocopy the database from Machine B to Machine A.The only major difference is the O/S and SQL, the machines are samespeed, however Machine A has twice the memory and faster disk; so Iwould expect it to be faster.Can anyone think of smoking guns I might be missing?TIA
View Replies !
View Related
Problem Unicode Data 0x2300 In SQLServer 2000 SQLServer 2005 Express
Hi experts; I have a problem with unicode character 0x2300 I created this table create table testunicode (Bez nchar(128)) Insert Data insert into testunicode (Bez)values('Œ€„¢') with 2 Unicode characters Œ€ = 0x2300 „¢ = 0x2122 Selecting the data select Bez from testunicode I see "?„¢" „¢ = 0x2122 is ok but instead of 0x2300 there is 0x3f When I modify the insert statement like that ( 8960 = 0x2300 ) insert into testunicode (Bez)values(NCHAR(8960)+'„¢') and select again voila i see "Œ€„¢" Does anyone have an idea? Thanks
View Replies !
View Related
InfoPath 2003 - Insert Data In SQLServer??
Hello, I created an InfoPath 2003 form, with a datasource from SqlServer 2000. When I try to insert a new record the follow error occurs: "InfoPath cannot connect to the data source. Safety settings on this computer prohibit accessing a data source on another domain." I checked Enabled -"Access data source accross domains" from Security Settings->Miscellaneous, but the error still appears. Have anyone any idea about this error? Thanks.
View Replies !
View Related
Trying To 'load' A Copy Of A SQLServer 2000 Database To SQLServer 2005 Express
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file. I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that? The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express. Thanks!!
View Replies !
View Related
SQLServer Express And SQLServer 2000/2005 Coexist Problem
Hi SQLServer expert, I have SQLServer 2000 and SQLServer 2005 Express installed in the same PC. I tried to install SQLServer 2005 Dev Ed in the same box with a named instance. The installation is successfully. After rebooting the PC, the SQL2005 service can't startup, while both SQLServer 2000 and Express can startup successfully. The error msg is "Could not start the SQLServer (SQL2005) service on Local Computer. Error 1053 : The service did not respond to the start or control request in a timely fashion" I also noticed that the MS SQL management Studio is not in the problem folder. Current config =========== SQLServer2000 : default instance SQLServer Express : SQLEXPRESS SQLServer 2005 Dev : SQL2005 Any one can help ? AU SQLguy
View Replies !
View Related
Sqlserver.exe-Application.exe
Hi I am installing Sqlserver 2005 express edition in my computer.But In the middle of installation the system is simply restarting and showing the following error message. sqlserver.exe - Application Error The exception unknown software exception(0xc06d007e) occured in the application at location 0x7c559bc81. I don't know why this error is coming.Please any one help me. thanks in advance
View Replies !
View Related
Poor Preformance Usinng Sql 2005 With Access 2003 Application
we have run access 2003 application using SQL 2005 server and the data transfer rate is extreamly slow. we are using ODBC connection and the access apllication works very fast with SQL 2000. we have the tested the comptabilty of the application to SQL 2005 with Microsoft wizard and it had no problems. even when i run simple application on the sql 2005 server, it runs very slowly. i am using the MDAC clients ODBC component and the SQL Native Clients one. which eliminates the possibilty of network problem. what could be the problem???
View Replies !
View Related
Installing Onto Windows 2003 Server For Multi-user Application
Good Day, I have an application that is being developed on Visual Studio 2005 (VB) and SQL Express. The application is set up to use the SQL Express on the development computer, and if an Internet or CD install is built, it installs SQL Express as expected. The question is, when it is time to deploy and put the SQL Express database on the 2003 server, how should the install on the server be done and how should we set the database path to the server? Thanks, Dave
View Replies !
View Related
Replacing Sqlserver 2000 With Sqlserver 2005 Express
I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000. Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection. If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is: server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS" DB name: name of db instance port: 1433(default) user and pass. My attempts so far results in "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket." and "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."
View Replies !
View Related
Sqlserver.exe-Application Error
Hi All, I am trying to install Sql Server 2005 Express edition in my system.But In the middle of installation system is simply restarting.And giving following error. sqlserver.exe-Application Error The Exception unknown software exception(0xc06d007e) occured in the application at location 0x7c59bc81. I can't able find why this error is coming. Anyone please help me. Thanks in Advance
View Replies !
View Related
Web Application Using SqlServer And VWD'05 Express Edition
Hello, Fairly new to asp.net developers community. Can't believe I havent took interest in this before! Please let me know what I need to learn in terms of resources for creating the mentioned functionality on my asp web page. I already have a sqldatabase and tables created with data. (This database is reading from another system every 15 mins)The problem is not the database, its working fine, I even have a MS Access frontend that I use. I want to take the query functionality on the web. ( par number look up to display description, price and unit of measure I need to have a box for the user to enter a number (1-xxx)..Populate 4 columns with xxx rows.In column one enter 'partnbr"...that looks up the "partnbr' in the "partlist_table" and send back "description" "price" "unit of measure" Once the info remains on the , I can create masterpages to resemble a quote. Thank you much for your help. Dev
View Replies !
View Related
Importing CVS To SQLServer 2005 In A Web Application
Importing CVS to SQLServer 2005 in a web application: I need to import CSV file to a table. This is a .Net 2.0 web application running in the WebServer which has .Net 2.0 installed. SQL Server 2005 is a database in another machine. What are my options? Would SSIS work in WebServer if no database installed in that machine. Thanks
View Replies !
View Related
To Start Sqlserver Service Through Application
Dear friends, I am working in .net windows application with sql server 2000. My problem is like some times sql server service automatically stoped when restart my machine.Then i start the service manually.after that if i restart my machine it not affect the service.I mean only at first time restart the machine make this problem. Anybody know any solution for this problerm?. Also how can i anable TCP/IP through application. Thanks & Regards Jesseja
View Replies !
View Related
Login Failure For Access - SQLServer Application.
Hi, I am using a Access and Microsoft SQLServer as a client server application. But one of my users is getting an error message when trying to open the access database called faculty Connection Failed: SQLState: ‘28000’ SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]login failed for user ‘PTRICHARDS’. But it works fine for me as i am an Administrator. Even my user can open another database called student which asks for SQLSERVER authentication. But only cannot open this database which does not ask for SQLServer authentication. Both the databases reside in the same SQL Server. IT worked fine till yesterday. Any suggestions will help, Thanking you, Ran.
View Replies !
View Related
Can't Connect From Web Application
Hello, For my application, I need to consult a database located on a server on the local network. The application is located on my pc. I use the connection string Code: "Integrated Security = SSPI;database=dbName;data source=serverName" (I program in C# and connect with ADO.NET) When I compile my project as a windows application, this works fine. But when I compile as a web application in ASP.NET and try the same connection, it won't connect. How can this be solved? Thanks
View Replies !
View Related
Web Application Cannot Connect To SQL
My web host has moved my website from one server to another at my request. The web application is .net and works with an sqlexpress database. Everything was fine on the old machine. But following the move I can connect to the database using Server Management Studio Express. But the web application throws-up the following message: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I am a liitle out of my depth here and my host is saying that the above is caused by a scripting error wheras it appears to me the copied sqlexpress databases need something doing to them. I would be extremely grateful for a steer in the right direction. Thanks in anticpation. Chris
View Replies !
View Related
Cannot Connect To Oracle Using SSIS On Windows 2003 Server With 64 Bit
Hi There, I did everything whatever is mentioned in the below thread. I installed the ODP.Net to connect to oracle. For some reason, if I test the connection using the connection manager in the BI studio, I get connection succeded msg. But If I try to run it and see the progress of the package in SSIS dev environment, I see a 'Class not registered error' or 'Connection not open' error. Can anybody please suggest me any workaround for this? This has been killing me for a number of days.. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=159581&SiteID=1 Thanks.
View Replies !
View Related
Cannot Connect To Oracle Using SSIS On Windows 2003 Server With 64 Bit
Hi There, I did everything whatever is mentioned in the below thread. For some reason, if I test the connection using the connection manager in the BI studio, I get connection succeded msg. But If I try to run it and see the progress of the package in SSIS dev environment, I see a 'Class not registered error' or 'Connection not open' error. Can anybody please suggest me any workaround for this? This has been killing me for a number of days.. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=159581&SiteID=1 Thanks.
View Replies !
View Related
Unable To Connect - SQL Express On Server 2003 From Vista
Getting error 1326. I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express). I'm trying to connect from SQL Studio Express on Vista. TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted. I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve? Thanks, John
View Replies !
View Related
Connect To SQL Server 2005 From Visual Studio 2003
hello all, i have SQL Server 2005 installed on a network computer and want to access it through code in asp.net. I am using visual studio 2003. I have porvided this connection string to connect to that Sql Server 2005 Express instance but failed: data source=mynetworkstystemSQLEXPRESS;database=MobMatiLogs;User Id=sa;password=mobmasti786 But I get the error: SQL Server does not exist or access denied. Anyone please help me! Thanks in advance
View Replies !
View Related
Unable To Install Or Run The Application (Microsoft.SqlServer.PipelineHost)
I updated a windows application. It runs great on my development box. We then published it to a web site. When they run the application it prompts them to update. The process begins and then they get the following message. Unable to install or run the application. The application requires that assembly Microsoft.SqlServer.PipelineHost Version 9.0.242.0 be installed in the Global Assembly Cache (GAC) first. Please contact your system administrator. Any ideas?
View Replies !
View Related
Cannot Connect To SQL Express From My Application
Hey everyone, I'm having trouble connecting to my sql express instance through my vb.net application. I can connect to it from Visual Studio and the management tools, but get an error when connection with a connection string. What should my connection string look like? I'm using the a default SQLEXPRESS instance.
View Replies !
View Related
Asp.net Application Connect To SQL Through A Firewall
Hi guys. We have an external webserver(server1 on domain1) is a DMZ, and sql server7(server2 on domain2) inside the firewall. Domain1 trusts domain2 but domain2 does not trust domain1. Our firewall hosting by outside vendor and they told me they already opened up the port 1433 for server2. I put a small asp.net application on server1(this application works fine in intranet. 2000 server,iis5,virtue directory, and .net frameword were well installed and configured), and I got S'QL server does not exist or login fail error'. Any idea about that? And how to test the port was opened? Any input appreciated.....
View Replies !
View Related
Connect To SQL Server From ASP.Net Application
Hi I developped an ASP.Net application (with Web Dev Express ) wich attempt to connect to SQL Server Express (installed in the local machine) using Windows authentication.When i launch my application within Web Dev or from IE navigator i receive the following error message : Cannot open the database 'MyDB' login failed for user ServerNameASPNet.I use SQL Server Management Studio Express to give the user ServerNameAspNet permission to connet to the database but i still receive the same error message.I created a user with strong password within Management Studio with connect permission and attempt to connect from my application using SQL Server authentication i receive the error message : The user 'UserName' is not associated with a trusted connection for SQL Server.Note that when i use the Connect to Database tool in Visual web dev the connection success when i use Windows authentication but fails when i use SQL Server authentication with the same error message above.My OS is WXP Pro SP2 Thanks for any help
View Replies !
View Related
Can't Connect To Sql Server Database With Same Connection Used In Visual Studio .net 2003
I have the following code that works fine in visual studio .net 2003 but not with VWD. I have sql server 2000 developer edition installed locally and this connection works fine with visual studio. With VWD it fails with the exception "System.Data.SqlClient.SqlException: Login failed for user 'DARRELLASPNET'". It fails on the conn.Open line. any ideas on what the issue is?Dim conn As SqlConnectionDim connstr As Stringconnstr = "Data Source=DARRELL;Initial Catalog=Event;Integrated Security=SSPI;"Dim daEvents As New SqlDataAdapter("select * from events", connstr)Dim ds As New System.Data.DataSet conn = New SqlConnection(connstr)conn.Open()daEvents.Fill(ds) conn.Close()conn.Dispose()
View Replies !
View Related
|
TRACKER
