Recent update: 2008-3-21
I am a SQL newbie. I have two connected databases that I work with in Visual Web Developer Express or Visual Basic Express. One is an ODBC master database that contains much table data and the other is my new destination sql express database. Where I was once very comfortable using the query ...
I want to delete a parent record.Is there a simple call I could make that would tell me if there are dependent child records, without me having to hard code in all the child tables and manually calling each child table one at a time.A .net framework call that that returned a Yes/No to a "Are ...
ODBC is not supported as a data source in SQL Analysis Services 2005. ODBC is not supported as a data source in SQL Reporting Services 2005 Model Designer. Any thoughts? Joe
Hi all,I want to insert information like SQL Server Version, current sql server user etc into a form, How will I achieve this? I have followed this question at http://www.vbforums.com/showthread.php?t=357605 ,but I havent had an answer to my question yet. Please help, I am stuck and can't go ...
Hi all,I have two servers running windows 2003 and both having sql server 2000.I want to establish a linked server between all of them.i created them . but now when accessing the data from those server the following error is being displayedServer: Msg 18452, Level 14, State 1, Line 1 Login ...
Hi,I have setup a linked server that intermittently crashes.It connects to an Oracle Database on an alternate server. My tnsnames.ora file is correct and the Linked server does periodically work....I am not sure what triggers it but it crashes and gives the following error:Error 7399: OLE DB ...
I am facing a problem with SQL Server 2005 64-bit CTP June 2005 on Windows 2003 64 Bit.When i try to connect to the SQL Server Instance using any of Windows/SQL Server Authentication from My Application using SQLOLEDB interfaces (From Win32 Code) it is not able to connect and throws following ...
330 byte By
chart at 2008-2-26
I am new to sqlserver (came from Oracle). When I copy database in sqlserver from production to test I end up with orphin users. How can I create sql to rebuild users in test from production? I quess I need a script to drop and then receate the users in the database that I just restored from ...
1782 byte By
angka at 2008-2-25
Hi, Can anyone help me? I am using MSDE 2000 with VS.NET. I can SELECT from the database but i cant insert and delete and update. Below are my code public static int Add(string tmpSql, string connectionString) { oleConn = new OleDbConnection(connectionString); oleConn.Open(); oleTran = ...
58 byte By
nonno at 2008-2-24
How to get the list of table names in a SQL2005 database?
Hi,i'm VB beginner. Lately i try out using the ADO to retrieve data frm SQL server, but connection problem encouter when i run it. SQL server 7 is locally installed type (local) as server name, & use Window NT Integreted security as log on to the server. (no username/passward needs)My VB ...
Hi folks,We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc). Last week, one of developer sent me an email with error msg, : Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. I ran Component Checker against ...
I think I'm having a problem with the OBDC connection to the SQL Server. I get an error message in the application log: SQL Server ODBC driver support error. Any ideas? I have tried unloading and reloading the client software and also with the .NET 1.2 and tried 2.0 and nothing.... HELP
342 byte By
Chico at 2008-2-21
I have recently upsized a medical departments database to SQL server. However, the Owner of the database wishes to add more fields using Microsoft Access. When he attempts to modify the linked table in Access, he get's the message that the table properties cannot be modified.How can one use ...
I have an application that opens and closes the database during a loop about 20-40 times depending on the criteria. However I noticed that the router and if I do a netstat -n keeps a ton (200 or more) sessions open with a TIME_WAIT status. It does not clear even though I closed my connections. ...
I have looked all over the MS site and can find very little information regarding SQL Server's support for the VMWare environment. Based on other information that I have obtained on other forums and web-site it looks like it is not supported by Microsoft, but I would like the company line if ...
I installed the Oracle client on my computer, and I can connect to oracle databases using SqlPlus, however when I try setting up the linked server I get the following error after I try executing a query.OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider returned message: ORA-12560: ...
983 byte By
tapir at 2008-2-19
i've inserted a data with the statement belowinsert into tbl (att_name,m_id) values (N'deneme???ü?s.doc','54')but while i'm trying to print att_name out with clasical asp code (below) <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><%dim Query000dim REC000Dim ...
1041 byte By
jslx7 at 2008-2-18
Hi,Please help me with this before I get crazy....I have VS 2005 and SQL server 2005 installed on XP ( with SP2 ) I create a new web project. Make a SQL connection to my database and configure the advanced options. Drag gridview component to my form and configure it to use the connection with ...
Is there some way to use only a single connection pool for more than 10 diferent databases?
I am trying to follow an exercise for debugging a stored procedure in the .net IDE. I have had success in adding a connection to the application, until I get the point of where I should set a BreakPoint in the stored procedure "Ten Most Expensive Products" which belongs to the Northwind ...
I have a table (for example PERSONS) with several fields (NIF NAME AGE).I have a cursors than read the differents fiels tat have this table inside a trigger fron another table that contain all the fields of the tables.This cursor save the name of the fiels inside the variable @FIELD.I need to ...
I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer ...
I can not connect from a remote computer on my LAN to the SQLExpress database using Visual Studio 2005 Beta 2, SQL Express 2005 June CTP.I have:1. Enabled TCP/IP on the SQLExpress Surface and started the SQLBrowser.2. Changed the connection method using Vikram's step by step procedure in the ...
When running SQL Server Express on a Windows XP Pro OS, is there a limit to the number of concurrent users or connections to the database?I know that Windows XP Pro has a limit of 10 user connections. Does this limit the connections to the database as well?I have also not seen any documentation ...
I'd like to design my dataset's in VS2005 in such a way that I develop at design-time using SQL2005, however I'll have the option of replacing the connection, sqladapter and command objects in the generated source code with another database's (like mysql, etc.)Since the schemas are ...
Does the x64 version of SQL Server 2005 June CTP contain 64-bit versions of the SQL Server ODBC Driver and the OLE DB Provider? I am not interested in the .NET Managed Provider here, just the legacy ODBC and OLE DB drivers, and only 64-bit versions of those. Thanks, Chuck
250 byte By
kyosky at 2008-2-14
Hi all expert, I encounter a problem when using the VS.Net 2003 Cyrstal Report's (ODBC)RDO connect to SQL Server 2005 June CTP, it promopt the "Login Failed." even I am using a "sa" account. Thank you very much for your suggestion. Kyosky
Hi:I am trying to convert my VS2003 project to VS2005 beta 2. The actual conversion has gone fine, but some code that was working fine under to old IDE is now giving me an exception when run under the VS2005 generated code.The code is: using (SqlConnection conn = new SqlConnection("Integrated ...
Hi all,I'm new to VB and VB.net and forms and everything, so please bare with me :)I am constructing an application which is connected to sql server 2000. What I want to do is have the Login form open upon startup then have an option group where the user states if he wants to use NT or SQL ...
hi, i want to extract the name of the SQL server and the system name from my code in VC++ plzz help
324 byte By
sam at 2008-2-12
Hi,I have an excel sheet with data dispersed in different columns. It isn't in a structured format which would otherwise have made it easy to use a SQLBulkCopy or use some method to import the data.Is there a way to import this data in the excel sheet to be imported into a table in sql 2005 usin...
1081 byte By
CUIWEI at 2008-2-11
I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normallybut when I connect to Microsoft SQL Server 2005 CTP, I failed! when I open SQL Configuration Manager,I find the SQL Server had been running, after I opened "Attribute" window, I find "This account" box had ...
982 byte By
Rafer at 2008-2-10
Hi I have been learning on how to use the new features of the .NET 2.0, and Well I using VS2005 and everything is pretty straight foward. I did a Membership webform where you log in and create users and roles etc. I installed the SQL Server 2005 express as my Data provider and thats where my ...
449 byte By
iulmer at 2008-2-10
Hi,I installed Visual Studio 2005 Beta 2 and could connect with it to my SQL 2000 Server. Now I installed on the same laptop SQL Server 2005, but the installation failed on some error. Now I uninstalled SQL Server 2005, but now I can't connect anymore to any datasource. The "Add new Data ...
i used this code to retrieve customer_ID from a database given a userid and password how to retrieve the customer_ID my code: public static int CheckPassword(string userid,string pass) { SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["connString"]); String ...
424 byte By
memac at 2008-2-8
Have created an SQL Server 2000 table which includes two columns each data type varchar(8000) in order to accomodate a semi-large amount of text (want to avoid using text data type). I enter the max in the first column but I keep getting an error of "Cannot create a row of size 12066 which is ...
Hi. I am currently working on an ASP.NET application which has to log on to SQL using a specific windows user account. As far as I am aware the only way to do this is by adding the Integrated Security=true; property to the connection string. If you specify a user id and password then it will ...
I was looking in the MSDN forums for a site for access questions. I need to modify some sql server code to work for access. I get a "missing operator" exception when I try to execute this sql server code in my new application. I get very confused about what in a access sql command required ...
251 byte By
guest at 2008-2-7
I want to select fields according to the date range. I try this cording (DFrom BETWEEN '1/1/2008'AND '8/2/2008') AND (DTo BETWEEN '1/1/2008' AND '8/2/2008') sometimes it work. my query join with several tables.
Help! Does anyone know why (and how to work around) this situation?I have a stored procedure in MSSQL 2000 SP3 defined as follows:CREATE PROCEDURE sp_mycheckASBEGINdeclare @ret intEXEC master.dbo.xp_fileexist 'C:\temp\bogus.txt', @ret OUTPUT RAISERROR ('A fatal error occurred',16,1) ...
HiI'm a complete sql/asp.net newbie and want to try this tutorial: http://beta.asp.net/GuidedTour/First I installed:Visual Web Developer 2005 Express Edition Beta 2systemsettings\software shows the "sql server 2005 express edition ctp (sqlexpress)" installedmmc\service shows me the SQL Server ...
Hi all,I'm new to MSDE and need some help. I have a stored proc that used to sit in Interbase and when executed it would populate some tables. I now have to have these tables external to the interbase database and have chosen (for the initial phase at least) to use MSDE. I have created a table ...
176 byte By
Marcas at 2008-2-6
<font size="2">Does anyone know how to suprime the error message [<b>SQLSTATE</b> <b>01000</b>} that comes at the end of a <b>Print</b> line? Thank you. M.-</font>
When there is a conections on a database,then we can't drop the database.But SQL Server 2005 can do it,because SQL Server can close existing conections before drop the database. I wonder how can i do it too using class SQLCommand and SQLConnection?
Hi, I have developed a small application using VB6 on Windows XP. Following is the code snapshot. I have added Microsoft ActiveX Data Objects 2.1 Library through Project Reference for ADODB Connection. Public con As New ADODB.Connection Public Sub Main() Set con = Nothing With con ...
If I try to use mobile web applications created with Visual Studio .NET 7.1 in conjunction with SQL Server 2005 Express Edition on my locale computer I get a lot of errors.Examples:System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Instance failure.Are there known ...
Hello there. I want to ask when I should make webservices with visual studio.net and when with Sql Server. How should I take that decision? any scenario examples? Thanks
I have a server with only SS2K5 installed on.I'm trying to connect via my program / isqlw (which I copied from a different SS2K server installation) and I get the following error:"Client unable to establish connection"I'm running on the same server, I enable the named pipe, tcp-ip protocols ...
I've tried posting this question to the C++ forum - but no solutions there...The following code fragment works when compiled in VS2003 on both Windows XP Pro (32-bit) and WindowsXP Pro x64.However, when compiled under VS2005, the call to 'pMyRecordsetPtr->RecordCount' fails on both 32bit ...