[microsoft:sql-server] Forum Topics

I'm getting the error [inlinecode]Incorrect syntax near '='.[/inlinecode] when I use the following case statement in a view. Obviously I'm not an expert on MS SQL, but I'm curious as to why I am allowed to use the '=' sign in a preceeding statement but not in the THEN section. …

Hi, I do have another doubt. The thing is in my project done in VB.NET and MSQL as back end...I need to print multiple pages. I can print only the page that is displayed on the VB.NET form ie the datas displayed on the VB.NET form. But it has more …

Hi, Im a NIIT student and I have just given my MS-SQL Server's examination and now I have an [COLOR=#555555]opportunity to give an examination for the same [COLOR=#555555]course conducted by Microsoft itself. Our [COLOR=#555555]faculty tells us that it has [COLOR=#555555]round about 35-40 question of 1000 marks but the problem is …

Hi, I need an urgent help. The thing is after I deployed my project and run it in another machine it shows an error when i click on the Crystal Report "Cannot find Keycode V2.dll or invalid code key" My project is done in VB.NET with MSQL2000 as the BackEnd. …

I have a web site that I've set up, and has been running for several years. The client has MS SQL Server. When it comes to the administration side of SQL Server, admittedly I don't know enough. The web application has been running fine, but we've been getting errors with …

:eek: Hi, Im having problems in adding new records in a database connected to .net. The data type of ID in access is NUMBER. When I click SAVE it shows this error message: "Column 'ID' is constrained to be unique. Value '1' is already present." Here is the code for …

Is it possible for VB6 to establish a direct remote sql connection and make a query in the remote sql database? If possible what are the reference do I need to add to make it working? Somebody please give a me a good example... from establishing a connection, query in …

Hello guys, I have a Calendar control that I am working on. I am having problems with the appointment portion of it. Everytime you click on a time slot and type, it adds an appintment. Here is the code I use to add the appointment. [code] [COLOR=#008080]Appointment[/COLOR][COLOR=#000000] m_Appointment = [/COLOR][COLOR=#0000ff]new[/COLOR][COLOR=#008080]Appointment[/COLOR][COLOR=#000000]();[/COLOR] …

i know this is not a question u'll enjoy,but i am new to asp.net but i need a connectio string to start my project ,so can anybody plz tell me how to get connection string while using sql server 2005.plzz

Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on …

Ok im getting into ASP.NET 2 and SQL and i was wondering if there are any free forum starter kits/templates out there?

Hi Guys, I'm having some problems in importing data from a file into a table. I created this file by exporting data from the same table. I've deleated all the records from the table and now I want to fill it up from the file I've created I'm importing data …

[COLOR=#191970]The data table looks like this date num1 num2 num3 num4 num5 num6 1/1/06 1 45 32 21 15 48 SQL script 1 should be able to do the following show the Top 3 number pairs another words if the pair 45 and 15 shows up 98 times and 32 …

Gentlemen: :?: Sorry to have posted twice, but I really messed up the title. Can anyone send me to the right contact for some SQL Topology assistance? I have posted on several SQL Forums and everyone seems to dance around this topic. I need to find out the proper way …

hi , how do i migrate data from mysql to mssql.....i need some free convertor tools....can any body help me

[COLOR=#191970]Can anyone possibly give me some pointers on how to speed up access to a central SQL Server from 3 remote sites. Currently 2 of the sites use 3mg DSL and the other uses Broadband Cable 3mg. All are VPN's into the server through SonicWalls. This topology is extremely slow …

Hi Guys, I was just trying to transfer data from access tables to a txt file and then back from file into a table using following code [code] Private Sub Command0_Click() DoCmd.TransferText acExportDelim, "Db Export Specification", "AUTHENTICATION", "J:\Power Equipment\Common\SK\db.TXT" End Sub Private Sub Command1_Click() strSQL = "delete * from AUTHENTICATION_TEST" …

Hi :) Im not an SQL n00b, but I'm no SQL guru... I'd like to work out the SQL code required to achieve the following goal in pseudocode: Grap a record Using info from that record, add (the width) to a running total. When the running total exceeds a certain …

I am having a wierd problem in that i can run my website from VS2005 and it hits the db for my articles list and gets them all back successfully. Although if I build my site and run it from the local host I can see the DB get hit …

Name: kediemetse NickName: saralinkie Weight: Mmmm Heish Ok, 60 Location:SA Age:33 Hobies: I like reading novels, gardening, golfing, going out with my Son to meets some friends, listen to Gospel, R& B is not the bad idea and listen to jazz. Favourate Movies: Ag Nigerian Movies, Ahaa James Bond, Jackie …

i have two questions? i made my window application in c# using standalone firebird database ,now i want to make my exsisting application database as emmbedded firebird database???? how can i,and also want to implement import feature in my application,which imports the database backup file(export is working fine).

hi all am really new to vb2005, i need to connect ma apploication to a database on ma server but cant as i nee d to b able to store data . is there a code i can use? its a SQL 2005 server

Hey, I've got a databae in which each record has seven dates associated with it, and I need to pull out each record's ID and its associated most recent date. Here's my first attempt, but Access doesn't like it at all. [code]SELECT id, MAX(initialCertDate, recertDate1, recertDate2, recertDate3, recertDate4, recertDate5, recertDate6) …

Hi all!! Is there a way to return 2 cells merged in one? For example take the followng table: | A | B | C | |abc | def| etc | and from this do a "SELECT A, B FROM table WHERE C='etc'" but instead of getting two values "abc" …

I am using Visual C# Express and I have a window that I would like to be able to enter 2 dates ( a 30 day period) and connect to the 2005 Sql Express database and return a range of data that I can eventually graph. I want to add …

Hi Guys, I have developed a desktop client application which runs on the local machines of some clients. I have another server application which is basically a filewatch application which runs every 5 secs . What this server application does is check the SQL database for any new updates, & …

hi, after I manually create maintenance plan using SQL server Maintenence Plan Wizard with SQL Server Management Studio 2005, is there any way to create a script for all these setting that I've done? So that I can just modify the database name and run it on another pc, the …

Let's say I have a column within a table that contains codes {0,1,2,3}. These codes are for what color shirt are in stock. We can say 0 is for black, 1 is for white, 2 is for red, and 3 is for blue. Then I run a SELECT query on …

Hi all, I am working with a project which includes Crystal Reports in Vb.Net and SQL Server2000 as Back end. The code in button click is [code] str5 = "D:\AttendanceReport.rpt" If Not IO.File.Exists(str5) Then Throw (New Exception("Unable to locate report file:" & vbCrLf & str5)) End If str6 = "SELECT …

Hey I am just starting to play with some SQL stuff after upsizing a old access database. What i would like to do is be-able to pull information out of the SQL database and display this on a web site. The query i want to use i have built using …

**Creating New User Issue** in VB.net with SQL 2005: I have a LogOn table and a Usr (User) table. A form that collects the new UserID,Password,FirstName,LastName, etc... I want to have two separate INSERT statements to first insert the UserID & Password. Then grabs the LogOnSys just created and create …

How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does? Any alternative?

Hello there, I need a help. I have a computer that has windows 2003 server installed and I have 9 clients in domain control that use SQL Active Directory, an aplications in Visual Basic. The problem is that whenever they try to use it is soooooooooooo slow and if I …

I have the "Critical System Error" in the task bar. I have run Hijackthis the log file will follow. Can someone please tell me what I have to do to remove this bogus alert? Logfile of HijackThis v1.99.1 Scan saved at 10:08:02 PM, on 11/17/2006 Platform: Windows XP SP2 (WinNT …

hey folks, I'm wondering if there is a function that i can give a db_name to and it will check the sql server to see if it exists without actually connecting to the db. If the name does not exist, i don't want to get an error in the log. …

When ever I restore the master database I put the server in single user mode using "sqlsrvr.exe -c -m" at the command prompt. When I successfully restore the database I go to restart MSSQLSERVER service and it will say it is starting but will stop. I am able to login …

Hi, I have an MS SQL 2000 database with a table that is used to store the header information on product returns. One of the fields in the table is a true/false field that indicates if the return has been processed (become a credit note). Can anyone tell me how …

Hi Guys, Just Wondering if it's possible to choose whether to run a macro or not depending on which user logs in. I've got a macro which updates the database everytime it starts. I want to restrict it to only limited number of users. Thanks for your time

Can a query running a selected database access a table on other database? How do I grant this kind of access? Going further, can a Foreign key be created among diferent databases? I'm running around this doubts for a while. Any help is welcome. []s

Hi, guys! Got a problem here. :) I have a form that when it loads spawns a thread which in turn fills a publicly declared dataset with a table by a dataadapter and then binds a field from the table to a combobox. [code=vb]combobox1.DisplayMember = "fieldName" combobox1.ValueMember = "fieldName" combobox1.DataSource …

Hi Guys, I'm having a bit of problem with my reports. I've got a report containing a subreport which has some headings in its report header. The subreport normally goes for 2 or 3 pages. The headings of the subreport appear on the first page but do not appear on …

Hey all, i am new to these forums and was wondering if anyone could offer some advice/help Currenlty we have MS Access databse which was created well before i started, this database has all our work instructions mixed into it. Unfortunately it isn't the easiest thing to navigate and seeing …

Hi Guys, Just wondering what's wrong with this coding UN = Form_MAIN!LOGIN_DETAILS.Value model = Form!COMBO_MODEL.Value stDocName = "MODEL_SELECTION" stCOND= "[MODEL_LN]='" & model & "'" And "[TM_NAME]='" & UN & "'" DoCmd.OpenReport stDocName, acViewPreview, , stCOND I'm getting a type mismatch error on the line where I specify value to stCOND. …

Hi, I am new to asp.net programming. I want to know how I can display the record after login. This is the scenario: I have login.aspx and employee.aspx. After login it will direct the user to employee form and display the record of the logged in employee only. The employee …

hi all im currently developing a website on my local computer and im a beginner.the front end is asp.net and back end sqlserver. But now i want to upload it to a server to so that it destributed to internet. So could any one tell me some of the hardware …

Does anyone know the exact query for IN in the following senario... I want to search for 2 columns for 1 mobile number (mobile, alternate mobile) I am using the following query [code]strSQL = "select * from tblcontest where bar_mob_no IN('" & sSQL &"') or bar_alt_mob in('" & sSQL &"')"[/code] …

I have problem in ASP.NET 1.0 report So please tell me how to code and run Project report in ASP.NET back end is SQL SErver.

Hi, when I installed MYSQL Developer Edition, a new invisible user was created called SQLDebugger. I was just wondering, can I delete this user. I just find it inconvenient that when ever I leave my computer idle for a few minutes, windows goes back to the user selection screen. If …

Hi there, I'm new to this sqlserver package. Is VB6 can able to work with this package like connectivity issues?. Can somebody advice me about this because my previous experience is purely on ms access database as backend front end vb6. thnx in advance.. newvbguy

Hi! all. I'm doing a project called "Query Optimizer".in which i have made a parser to parse the query! but now i'm not able to calculate the cost of thq SQL query( in terms of cpu time used,i/o perations,memory used,indexes defined etc.)so please can any body help me out ? …