[microsoft:sql-server] Forum Topics

I have made a project in VB.net in which i have used sql server trial version 2000.I have made the exe but when i run the exe a error message is thrown :-An error has occured while establishing a connection to the server.when connecting to sql 2005 .this may be …

[code=coldfusion] <cfoutput> <cfform name="input" ENCTYPE="multipart/form-data"> Data Source: <cfif isDefined("database")> <cfinput type="text" name="database" size="25" value="#database#"><br> <cfelse> <cfinput type="text" name="database" size="25" value=""><br> </cfif> Query: <cfinput type="text" query="SQL" name="query" size="130" value=""><br> Output: <cfinput type="text" name="output" size="100" value=""><br> <input type="submit" value="Submit" /> </cfform> </cfoutput> <cfif isDefined("database")> <cfquery name="SQL" DataSource="#database#"> #query# </cfquery> <cfoutput>#query#</cfoutput> <cfoutput query="SQL"> …

I am working on LOGIN Module and all my code is ok. on my localserver: the code works exactly fine. it gets login and gets logs out.. On my Host using sql server 2005.. I just try to login and it does not get logged in. no case sestiveness applied …

i m using visual studio .net 2003 vc++ mfc i cannot connect to sql server SQLSetEnvAttr() is returning null value everytime i hv used retcode = SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void *) SQL_OV_ODBC3, 0); pls help !!

Hi, I am wondering if code below is right. Is there any unnecessary line? Thanks [code] <% on error resume next ad=request.form("name") Set RcSet = Server.CreateObject("ADODB.RecordSet") sql = "Insert Into veriler (name) Values ('"&name&"')" 'ADD sql = "Update veriler Set name='"&name&"' Where id=1" 'UPDATE sql = "Delete From veriler Where …

I have a large backup database file and I am having trouble opening it. I tried renaming it from database.BAK to database.MDF. I hope that this did not permanently destroy my hopes of ever recovering the database by changing the format. Does anyone out there know how I can open …

Example Database id master_id ref_id 1 p1 c1 2 p2 c1 3 c1 c3 4 c3 c1 5 p3 c4 6 p3 c5 Starting with "p1" I wish to return the recursive list of master_id:ref_id Here's the problem: p1:c1 c1:c3 c3:c1 (circular reference) c1:c3 ..... ..... etc How do I …

hi i have an existing table . i'm working with sql management studio. how can i change columns properties ? set column as idenity true. set column as indexable.

We are working on a project & finding an issue while accessing the data from SQL Server. Problem: Display of record in search console of application on number of times it has been processed. Consider we have a record which needs to be displayed 5 times a day in search …

I am new vb.net and I m working on project that will import excel file in datagrid. After import this file I need to save these file into SQL Server 2005 table. But I am receiving 'Procedure or function insertCashBook has too many arguments specified'. [code] Private Sub ButtonReconsilation_Click(ByVal sender …

I've read up on attaching a dataset to a datagrid and followed all the code snippets I can, but I am still having problems viewing data. Have a look at this code: [code="VB"] Private Sub ViewCustomers(ByVal vRegion As String) conn.Open() Dim SQLComm = New SqlCommand("SELECT * FROM ViewCustomers('" & vRegion …

Hi, Did anyone has used jTDS or any JDBC driver to connect to Microsoft SQL SERVER on IPV6 environment? if yes can anyone please provide me code or any help? i tried with microsoft one which they claim support for ipv6 but i didnt go thru even there. may be …

Hi, I have created DB applications using MS-SQL and VB. But, I am new for distributed database program development. Will you please help to design one?

I have to submit the assignment and I get stucked, so I need urgent help. Down is the Question. I have done a Query called Mtangoo_shop_query but I don't know what to do to filter out other fruits and leave only banana. Help! (Believe me MS Access is too complex!) …

Hi all, I have a very simple query but this is driving me nuts. I have installed sql server 2008 on my system. Its working fine, but the main thing is that i am not able to configure the report server. Can anyone help me how to configure the report …

Hi, Check the following description of my requirement. (This is in MS SQL 2005.) 1. Select a table in your DB. 2. Alt+F1 lists the structure and the details of the table. 3. In that, i could see a. Table Name and Owner b. Columns , data type , size …

Hi, lets say I have the following 7 records in my database ID Model -- ------ 1 400 2 400FL 3 400 FL 4 ABC 5 SGH500 6 SGH-500 7 SGH 500 How is it possible if i could select out the rows which are of possible match to some …

Hi, I have one Code in my URL: as: localhost/project1/index.cfm?catID=1&siteName=http://www.sqlserver.com I want to extract only: [url]http://www.sqlserver.com[/url] how can i do that, i try using the listfunctions but no help.

[QUOTE=ardav;788833]This sounds like a clear cut research job that YOU should be conducting for your coursework (or whatever). BTW This is a pHp forum[/QUOTE] [code] Hi I need your help in my project of "online examination”. I am developing this for my lab. backend: sql server 2000 front end: ASP …

All, I'm writing a script/function to automated putting buttons on the screen. I'm running into a problem with var substitutions in my strings, which is necessary to make it run. Here is my code: [code]Function Get_Btn(MyForm) Dim Wspace As DAO.Workspace, dbs As DAO.Database, rsDEST As DAO.Recordset Dim SQLstmt As String, …

I could not find pubs database after installing mssql 2000. I dont know wat to do.. Help me

Hello! I've beat my head crazy trying to figure out what the heck is wrong with this query. It is not my query, but one from a packaged software I need to customize. I've created a link to the sql db's in an access db (linked to all sql tables) …

Help Please! I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) I am unable to create maintenance plan. I am on sp2, and applied a critical hotfix from the microsoft website. I thought maybe it was client tools, but isn't …

I want to know how to be :)

Hi guys! I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. When I run the function in SQL Server Query Analyzer, it works, but when …

I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. Below is a code fragment for one of the functions. [code="SQL"] CREATE FUNCTION ViewCustomers(@Region varchar(6)) returns …

hi, i have create asp.net web site that do alot of requests (write, read, go to some links ) this web site using sql DB during accessing requests it redirect to the default page after short time how can i solve this problem in redirection ?? Best Regards IT_Techno

Hi there I'm a newbie to asp.net and trying to learning it doing small forum application. In the application I've a page which lists the available threads in a given topic and I used a gridview. In the gridview the thread's title is hyperlinked and when clicked it will redirect …

Hi I often get this error on some of my asp pages Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired what should be done to resolve it? is there any way to trace the error and show a custom message to the users instead of the above …

Hello, What SQL query should I use, in order to copy records from one table to another, both of the same schemas, in such way that only records that don’t already exist in the destination table will be copied? For example: Table A – Destination table ****** Col1 Col2 Col3 …

I am trying to count how many entires appear in one table which is linked to 2 others, then show the result on a web page. Table 1 - Companies CompanyID CompanyStatusID FundID Table 2 - Company_Status CompanyStatusID CompanyStatus Table 3 - Subscriptions CompanyID FundID What I need to do …

We have a Log table which logs the events of a request. When any error event occurs, I need a query to see the row with errorevent and the previous row to this row which contains the actual data which caused the error. Here is the table structure: LOGID (int), …

Hi all, I have created a simple SQL Server database by Visual Studio 2005, with one table 'Friends' that has just ID, Name, Phone, Email. Then created a datagrid to this table (just by dragging the table name from the 'Data Sources' explorer to the form. When I run the …

Hi All, I've form with two controls, one TreeView & one PropertyGrid. The treeview displays the list of equipments. when I select any node from the treeview i.e. any name from the list of equipments, then the property grid will dispaly all the attributes of that selected equipment. The property …

Require help I had 2 question 1) What is the script when I select Option 1 click command button will go to form 2 and select option 2 click button command will go to Form 2? 2) What is the script connection within vb6 to mssql?

In SQL Server Profiler you see that a transaction starts and one line below it fails but I have no clue why the transaction fails. The transaction was initiated by a C# program using a table adapter and LINQ. In Visual Studio you see that the transcation fails but not …

Help - We have a BT Router and and HP PC. We have two VOIP lines on the router and sveral Laptops using the router for Internet access and document sharing and SAGE200 POP/SOP access on the HP PC. All works well. The issue is that the connection between the …

Hello all, Are UDFs written only on SQL Analyser in within the SQL? Can we use them in programming code?How to use them in the code? What are the actual benefits of UDFs? We can write the method in the code and connect to the database and execute which yeilds …

I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I …

I have a Stored Procedure that is called through VB6 for a report. The Reports were working great until yesterday. Now all of the reports that use that sp are timing out. The default time is set to 60. I have adjusted this to 1000 and the report finally displays. …

Hi All, I've a table name Countries with two fields as ID, and CountryName. Where ID is foreign key(ie., may have duplications) and the country name can be repeated as many times as it needed. for example the scenario is ID CountryName 1 India 1 US 1 UK 1 Japan …

Hey all, I need help from all you genuises out here. I have 3 tables [CODE]CREATE TABLE IF NOT EXISTS `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tag_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`tag_id`) ) CREATE TABLE IF NOT EXISTS `video_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` …

Hi, This is my first post on this forum. Apologies in advance if this isn' the right place or there isn't enough info. I'm basically trying to retreive an ID from a quesry string... xyz/nuts.aspx?nuttype=7 What I'm having trouble with is defining the variable and referencing the querystring in the …

Urgent help Please! I have a table exist in two database on two different server. I want to get the data of table from one table and another. When I am using OPENROWSET command it through error. I don't know what it mean. Is there any way to migrate the …

Can anybody tell me where should i pass sql statement in crystal report . suppose i want to pass these codes in crystal report.this would be greately appereciated. [code] RECORDSQL = "SELECT * From MR WHERE (((MR.Req_no)=" & Text12.Text & "));" rs.Open RECORDSQL, con, adOpenDynamic, adLockOptimistic [/code]

trying to extract fulladdress to individual column such as address1 address2 City State Zip, and each of the fulladdress has a [B][U]comma[/U] [/B] so that why I am trying to create a function that count the comma and put the fulladdress ito individual column. hear is the script that I …

basically i would like to add up the total size of all the files for a particular user and display it in a label...this is what i have so far: [ICODE]SqlConnection myConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\ASPNETDB.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True"); myConnection.Open(); SqlCommand myFileCommand = new SqlCommand("SELECT SUM (fileSize) FROM aspnet_Files WHERE …

Can anybody tell me how should i generate automatic sr no which match with mr no. i have written a code but it is not working properly. [code] Dim crystal As CRAXDDRT.Application Dim Report As CRAXDDRT.Report Dim cparam As CRAXDRT.ParameterFieldDefinition Dim cparams As CRAXDDRT.ParameterFieldDefinitions Dim con As ADODB.Connection Dim rs …

Hi all, I have a SQL table that has "RecID" as it's PK and identity column in the same time. When I add a new record in the table directly, the [B]RecID[/B] increments correctly. But when I try to add new record in data grid view (VB 2005 Express) and …

Hello Everyone :S I am rather new to ASP.NET. I have an SQL Server 2005 database set up. So far its quite basic with just two tables (UsersLogin, Roles). My aim is to allow users of different ranks to login to the system ie. Admin, Staff etc. [B]UsersLogin [/B] table …