-
- Visual Basic 6.0
by madskunk
- 6 Replies
- Last post
by ErikEJ
- Greetings,
Firstly, apologies if this topic is out of the scope of this board, but I am stumped.
Basically, we have an old Visual Basic 6.0 application which currently accesses an Access database, but which we would like to upgrade to an SQL compact edition database. I have created the database, but have so far turned up next to no details reagarding how to connect to the damn thing in VB6.
-
- Parameter missing value after deployment
by Naveen J V, Bangalore
- 3 Replies
- Last post
by Adam Tappis - IMGroup
- Hi Friends,
I'm using MSRS 2005. I have created a drillthrough report using parameter. If I try to execute locally it works fine. I am able to call sub report from the master report by passing parameter. But, If I rey to access the report after deploying on to reporting server, I am getting error patameter xxxx is missing a value . What could be wrong Please help
Thanks & Rega
-
- Can't find the server management studio
by TjAnNe
- 4 Replies
- Last post
by TjAnNe
- hey, i did the installation, everything went well. when i want to start the server management studio it isn't in the program files listed. is there something i can do about it. i did the installation three times now and it didn't change a thing. all comments are welcome greetz TjAnNe
-
- Connect to SQL Server Express
by janols
- 2 Replies
- Last post
by janols
- Hi,
I have a problem when i try to connect to a remote database. I have tried with both these connectionstrings:
connstring = @"Data Source=DELLOPTIPLEX\SQLEXPRESS;Connect Timeout=30;User Instance=False;initial catalog=Test;Integrated Security=SSPI;Persist Security Info=False" ;
and
connstring = @"Data Source=DELLOPTIPLEX\SQLEXPRESS;Database=TEST;Trusted_Connection
-
- Execute a stored procedure of another server
by ved_30
- 13 Replies
- Last post
by Konstantin Kosinsky
- Hi,
I have to execute a stored procedure of another server. Can someone suggest me the best way to do that.
Thanks,
Ved
-
- Load CVS file content using DTS
by Visios
- 0 Replies
- Last post
by Visios
- I am getting a CSV file from an application.
I want to load couple of columns in CSV file to SQL Server DB.
How can i do .
My CSV got 35 cloumns. From that only 5 columns i want to load to SQL Server DB.
Can i define in DTS package, which column to pick .
Do i need to create a SQL DB before or DTS package will create SQL DB .
I never done a DTS before.
-
- Back button does not regenerate original report
by Roberto B
- 1 Replies
- Last post
by Xinwei Hong - MSFT
- When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report.
I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set o
-
- SQL Join
by Rashi
- 4 Replies
- Last post
by Rashi
- Hello all,
I have couple of questions:
1) It might not be a very good question but I was just wondering if I can join more than two tables using an SQL Join statement. I am sure there should a way to join more than two tables
2) I am trying to combine two tables- salestable and sourcecodesetup that have a "source id" field in common. When I combine bo
-
- Get XML root name in Sql Server
by Jeff.HE
- 2 Replies
- Last post
by Jeff.HE
- declare @x xml set @x = '<Chicago> <Area>A1</Area> <Group>5</Group> <Question>Q1</Question> </Chicago>'
How to get the XML root name 'Chicago' in Sql Server 2005
-
- How to add IDENTITY constraint
by SN Ngaihte
- 7 Replies
- Last post
by WilliamBrander
- Dear All,
I wanted to add a IDENTITY constraint in a column using the ALTER command, How do I go about doing that
Please help.
-
- SQL 2005 Std Cluster
by JD McCrea
- 2 Replies
- Last post
by Michael Hotek
- Anyone know before I invest in the hardware if it is possible to have Two Clusters on the same hardware both in Active/Passive Clustering where Cluster1 and Cluster2 both use the Default SQL Server 2005 Instance (No Named Instances)
This would be a Virtual Cluster with Two separate 2 node Clusters on the Same Hardware sharing the same OS and SQL.
Thanks in Advance,
-
- How to add IDENTITY constraint
by SN Ngaihte
- 7 Replies
- Last post
by WilliamBrander
- Dear All,
I wanted to add a IDENTITY constraint in a column using the ALTER command, How do I go about doing that
Please help.
-
- SQL Group By?
by SQL Servant
- 7 Replies
- Last post
by SQL Servant
- I have a table with the following sample rows.
Cust|Prod|Price|Date A123|XYZ|8.10|01/01/07 A123|XYZ|7.50|01/01/06 B456|XYZ|8.50|01/01/07 B456|XYZ|7.50|01/01/06
I need to extract the latest price for customer A123. If I use the following SQL:
SELECT Cust, Prod, Price, MAX(Date) FROM myTable WHERE Cust = 'A123' AND Prod = 'XYZ' GROUP BY Cust, Prod, Price
I get this:
-
- Reminder - please indicate if a reply has answered your question.
by Clifford Dibble - MSFT
- 8 Replies
- Last post
by Hans.wu
- How do I indicate a post answered my question While reading a reply to your question you will notice a button with this Icon: Clicking on it will mark the post as the answer to your question Thanks! Clifford Dibble
-
- Execute SQL Task : Input and Output parameters in tsql stataments with ADO.NET connection type
by PK2000
- 9 Replies
- Last post
by PK2000
- Hi Everyone,
I haven't been able to successfully use the ADO.NET connection type to use both input and output parameters in an execute sql task containing just tsql statements (no stored procedure calls). I have successfully used input parameters on their own but when i combine it with output parameters it fails on the simplest of tasks.
I would really find it ben
-
- I executed sp_depends from QA and I check the dependencies from Enterprise Manager.
by VKing
- 1 Replies
- Last post
by Madhu K Nair
- I executed sp_depends from QA and I check the dependencies from Enterprise Manager.
Both have different results
why
-
- DTS to VB
by Lawrence 007
- 14 Replies
- Last post
by Lawrence 007
- Can someone help me please.
I am having issues with the following code. This is the first time I am doing this, so it is Brand new to me. Sorry if I look and sound like an idiot.
I am having issues with 'DTS.OleDBProperties' cannot be indexed because it has no default property at the following line :oConnection.ConnectionProperties
I used DTS wizard to create my vb code and I am following
-
- using Contains to find Inflectional variations of multi words with AND logic
by GarrettM
- 3 Replies
- Last post
by GarrettM
- what if you want to search with AND logic using the FORMSOF(inflectional,...) methodology.
if my search phrase is "sport award" I can easily do an OR search using the following in my where clause: CONTAINS(Colname,'formsof(INFLECTIONAL,sport,award). but the and is far more tricky....
does anyone know how to do this without having multiple Contains statements (which greatly increase
-
- Extend existing report items
by beefeater
- 3 Replies
- Last post
by adolf garlic
- Hi, I'm totally new to SSRS2005 and I was wondering if I could extend the existing report items. For instance, I'd like to add a few extra properties to the textbox report item. I tried wrting a custom Textbox control that inherits from System.Windows.Forms.Textbox. When I imported the dll in VS, the new textbox showed up in the toolbox, but it was grayed out. Any idea what I'm missing here Than
-
- SQLExpress2008
by ewentms
- 5 Replies
- Last post
by Andrea Montanari
- Hi,
I am getting ready to install SqQLEpress 2008.
When you srart the install it says you must remove the old one.
I am concerned about how to safegard my current databases so that I can continue to use them.
Van some one tell me haw to do this/
I have found the MSSQL\Data where my data existm but when i go to copy them it tells me that someone is using them, not true. What Can I do
-
- OPENXML and OLE Automation support in SQL Server 2005 Standard Edition
by MS_Bob
- 3 Replies
- Last post
by Martin Honnen
- I have a SQL Server 2005 Standard Edition installation and a SQL Server 2005 Developer edition installation on two separate machines.
Is OLE Automation and OPENXML supported in the Standard Edition I don't see OLE Automation when I run sp_configure on the Standard Edition and OPENXML does not work. I do see OLE Automation running sp_configure on the Developer Edition and OPENXML works fin
-
- Can multiple instance in a cluster share disk resources?
by rrowe007
- 1 Replies
- Last post
by Milos Cimfl - MSFT
- Is there a way for multiple SQL 2005 instances in a cluster to share drives for user databases.
Once we install our instances in the cluster using seperate disk resources. Can we then have multiple instances share the same physical disk for user databases only. This is for a test environment.
Thanks
-
- SQL Server on Vista
by Idanz
- 4 Replies
- Last post
by Idanz
- Hello,
I am trying to install SQL Server Enterprise 2005 on Windows Vista Enterprise.
The installation has finished "successfully", but when I am trying to open the MS SQL manager, I see that the manager has not installed.
How can I fix it
Thanks, Idan.
-
- How can I do a dtsconfig file for connections?
by enric vives
- 3 Replies
- Last post
by enric vives
- Hi,
Up to now, we're using SSIS variables for storing values such as server name, database or several paths.
All these variables are required when our developers give to us their DTSX packages for to be updated in production scenarios.
And now, we'd like to use xml files but I don't know how to. We've already got xml files for Data Flow, Sql Task and so on..
Thanks indeed for your
-
- Integration service Express/2005
by Pete Lux
- 6 Replies
- Last post
by Mike Wachal - MSFT
- I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it