Generating User Instances In SQLServer Is Disabled
Apr 18, 2007
I am a beginning programmer and am tying to add a database to my visual basic 2005 express program. I have a nice working window but now a database needs to be attached. Following the add items and selecting the sqldatabase icon (and change the name) I get the following message: "Generating user instances in SQLServer is disabled. Use sp-configure 'user instances enabled' to generate user instances". I am trying for 2 days to find out what to do.
Aparently, all the solutions on the internet are for wizards but not for apprentences. I hope to become a computer wizzard but are far from it now. I scanned my computer for the file sp-configure but it does not exist. I tried sp_configure as a DOS command, checked all VB menu options to find etc. On the internet the language is out of my league and jumps too quickly.
View 3 Replies
ADVERTISEMENT
Mar 11, 2011
I currently have a sofware with 80 customers.All share the same database structure, when data are differents.We got 5 database for each customer.Today, we have named instances, so the program is accessing to Bdd with something like :
Connect to 127.0.0.1/CUSTOMER1
select * from base1..table1
Now, we need to change, we got many instances.The idea is to have unique SQLSERVER instance, obviously i want to avoid changing the code (VB.NET).Just tried to play with schemas and users, seems to be an option, but since the schema is under the database, in can't make it works :
Connect to 127.0.0.1/GLOBAL_INSTANCE as specific user (customer1)
select * from base1..table1 -> error @ this point
When THIS works :
Connect to 127.0.0.1/GLOBAL_INSTANCE as specific user (customer1)
Use Base1
select * from base1..table1 / or select * from table1
I can easily script some user or schema creation, and change connection strings for all customers, but i can't really change All requests: huge number.
View 1 Replies
Apr 28, 2007
I'm converting a user generated list box to an array and then generating a user defined number of random strings and placing it in a textbox.The code I have works fine as it will generate the number of random strings the user wants, except sometimes a line is blank at the top of the list but is counted as a string.
View 4 Replies
Mar 22, 2010
How can i call sqlserver 2008 user define function in vb.net?
View 1 Replies
Sep 30, 2011
In my program I've got several comboboxes that all have the same comboboxitems and when the user makes a selection in one of the comboboxes the selected comboboxitem gets disabled in the other comboboxes. (i.e. If the user has selected the comboboxitem with value 'a' in combobox #1 and selected the comboboxitem with value 'b' in combobox #2 then in remaining comboboxes both the comboboxitems with values 'a' and 'b' are disabled)
View 1 Replies
Aug 23, 2011
I have a dgv with a column type = DataGridViewAutoFilterCheckBoxColumn. I want to know if there's a way to I can get that entire column to become disabled (or Enabled = False) so it won't let the user click on the checkboxes. I tried looking in the "Bound Column Properties" but there isn't an option to disable the entire column.
View 2 Replies
Aug 8, 2009
Im developing an app at the moment where standard letters need to be generated to be sent out to customers. With the customers details then filled in as you would expect... name, title, address, etc. This is an app ontop of a SQL db. The way i envisioned this working was to send the customer details to another form that had a crystal report in, and send the info via a SQL query, just as you might get a grid view to open with a query.
Thing is im struggling with it, getting the query to work especially. Ive built the report and put the relevant field place holders in there, but i cant get it to open with just the one customers info in there, it gets every customer and builds a report several thousand pages long! This is because of the "command" thats on the report that i stuck in there on a temp basis while i designed the thing.
However i want the the report to open via a button on another form, and then fill the report with the customers details (using the customer ID number on the form the button was clicked) Since im struggling with this so much, im actually wondering if im going the best way about this? Are there better ways of generating a standard letter that the end user can then view, check it, and hit print?
View 5 Replies
Mar 30, 2009
I am trying to figure out how to generate code from user input. In Visual Studio 2008, Visual Basic.My script always begins with:function Init (Quest)Then from here a user would input a quest name, type and zone in a interface using windows forms.[code]I would also like to have these available on the UI but wont generate unless a user checks a box to add them or there is a box already for them but wont step into the code unless the user enters something into the box.Is there anyone that can explain how I would go about doing this. Or maybe some kind of visual studio plugin that will help me out.
View 2 Replies
Mar 30, 2009
How to generate code from user input. In Visual Studio 2008, Visual Basic. My script always begins with:
Code:
function Init(Quest)
Then from here a user would input a quest name, type and zone in a interface using windows forms.
Ex:
Code:
RegisterQuest(Quest, "Kill Zombies", "Heritage", "Firestorm")
end
This part a user would enter in his interface what would an NPC say if accepted.
[Code] .....
What I need is a few text boxs that a user can input "Kill Zombies" or whatever they like and when they push a generate button it will create a file with a .quest extension. All of the code remains the same except for the quotes that would be the user input from the interface. Basically everything in quotes can be changed by the user in an interface. I have created my own functions for when a user accepts, deny and complete a quest. The user just needs to input what should happen then click a generate button to throw it all together as a .quest file to be saved in his or her quest folder for the server to call on later.
I also have many other functions like:
AddQuestRewardFaction --- (Quest, Faction ID, Amount)
AddQuestRewardCoin --- (Quest, Copper, Silver, Gold, Plat)
AddQuestStepObtainItem --- (Quest, Step ID, Description, Quantity, Percentage, TaskGroupText, Item ID(s))
Etc
I would also like to have these available on the UI but wont generate unless a user checks a box to add them or there is a box already for them but wont step into the code unless the user enters something into the box.
View 4 Replies
Apr 28, 2009
I have a user control, and want to be able to update its cursor while it is disabled. For example, say that I have a user control whose cursor is Default. The below code works ONLY when the user control is already enabled; if it is disabled the below code doesn't work and the cursor remains Default: Me.MY_USER_CONTROL.Cursor = System.Windows.Forms.Cursors.WaitCursor
View 3 Replies
Jul 12, 2011
Which is the best way to store application and user settings of an application running with multiple instances?My problem is that using the vb's "Application Settings" one instance would overwrite the other one.I want to identify each instance with a number passed via command line argument. I could use this number to identify the appropriate settings of the running instance, but I see in a local INI o XML file a better way to handle that.
View 1 Replies
Feb 15, 2012
I am trying to draw textboxes when the user enters the amount of textboxes to be drawn on one form and the textboxes get displayed on the another form. I have found these codes online but it works with inbuilt codes I guess. That is, the number is already hard coded in the form.
[Code]...
View 10 Replies
Mar 20, 2009
I work with VB6 SP6 under windows XP SP3.I' ve created a user control activeX. When I create some instance with the command : Form1. Controls. Add I have this error : "Error '50003' Unspecified error" if I create too many instances.
For Index = 0 To UBound(obj) Set obj(Index) = Form1.Controls.Add("MyUserCtrl.MyClass", "Label" & (Index)) obj(Index).Visible = True next index
View 2 Replies
Aug 14, 2009
I need to be able to export data from an sqlserver to an xml file (just a flat data dump) using visual basic coding - using just your basic select statement.
View 17 Replies
Aug 2, 2010
I would like to retrieve data from db whenever i click on a button. I have a table for questions and another table for options. I select questions randomly and trying to get the corresponding options but my code below only returns options one time and stays there even though the random number changes. As an example, if random number is 1 i have options a,b,c,d for question 1 and if random number is 2 i have options e,f,g,h for question 2, etc...
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = ""
Label2.Text = ""
[code]...
View 1 Replies
Mar 9, 2009
how to establish a connection in vb.net using sqlserver
View 3 Replies
May 24, 2010
What is the best way to connect a remote SQLServer via window based application?
View 8 Replies
Dec 23, 2010
I have a web site that connects to a remote SQLServer, and is running just fine.I have some pretty simple 'batch' type tasks that I want to run (as a Windows application) on a scheduler (I'm more comfortable with VB so I prefer that).
Looks like VB Express won't allow me to access the remote data. Everything seems to be pointing to having to buy VS Professional for $545 (I don't have an original one to upgrade). Is there a more economical VB option?
View 3 Replies
Mar 4, 2009
I'm working on a little program - an issue tracker - that I thought I'd put on the web. Now I'm getting really annoyed with Visual Web Developer EE because I find it hard to work with in order to do stuff that's easy in VB. So I got a new idea. Why don't I make a windows app in VB.NET that connects to my database over the net?
Problem is that I wonder how to do this in a sequre way and I have no idea... I figure that the win app would really only be a user interface to the business logic and data that runs at my server...
View 2 Replies
Mar 4, 2009
im trying to access sqlserver management studio database using forms in vb.net...m using a button and i want to get access to the database when i click on that button....the code is given below....wen i tried the same code without using forms,this is working fine but it is not working when i use forms....
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strcon As String = "Data Source=.\sqlexpress;Initial Catalog=employee;Integrated Security=True"
[code]....
m not getting any output using this code....
View 5 Replies
Jun 26, 2009
I have been developing a VB 2008 application which has been using Access as its database. The app is very far a long with about 30 forms and 45 DataSets I now must change the application to use SQLServer. Unfortunately all of the Table & Attributes names have changed in the new DB. Almost all of the data model has stay the same.
I have a few questions on the conversion.
The ConnectionString is currently pointing to the Access DB. I have entered the new ConnectionString into the Setting tab. What is the best approach to make the change?
I have done some testing to change the Table & Attributes names by using Quick Replace. It seams that sometime when I would do the rename I would lose the TableAdepter on some screens.
What is the best approach to performing the renaming task?
View 1 Replies
Jan 15, 2012
I am new in vb.net. The image has been stored in sql server as and i dont know how to convert it to display in picture box.[code]...
View 14 Replies
Feb 15, 2012
i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with that .(is it possible to check the version of installed mssql server with out connecting it with my application.)
View 2 Replies
Nov 18, 2009
I have a database in sql server 2005 named as Addressbook and table Persons with PersonID as PK.I have created 4 textbox on form for FirstName, LastName, Address, CityID and an ADD button. When I input data to text boxes and press F5 then it show some error message. I hv tried eerything but failed.My code is as following and error messae is (The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.)[code]
View 1 Replies
Feb 13, 2012
i have to insert more than 200k records in sqlserver DB.
My idea is to add the data into DATA TABLE then doing Bulk Insert, but my TL said: "insert the data into CSV file format and do the bulk insert".
View 2 Replies
Apr 9, 2011
I have made a form to connect to a SqlServer but i have hit a dead end as the PHPMyAdmin password table is encrypted so the Login only works when you enter the encrypted password in. Is they anyway to decode the password so the password can be read?
View 10 Replies
Jun 1, 2009
how can I restore sqlserver database from VB.net or C# Application?
View 2 Replies
May 28, 2009
I tried to run this on a local instance of sql-server and sadly it worked!!!now I know that the code is right and there is some kind of DBA restriction I need to find (and ask the DBA to remove)
using System;
using System.Collections.Generic;
using System.Text;
[code].....
View 2 Replies
Aug 19, 2009
Public Sub cleanTables(ByVal prOKDel As Short)
Dim sqlParams(1) As SqlParameter
Dim sqlProcName As String
[code]....
and finally datatable dt = dbConn.Execute(CommandType.StoredProcedure, sqlProcName, sqlParams)
View 4 Replies
Jul 8, 2011
What is the preferred method of adding the current date/time into an SQL Server table with INSERT Command and executenonquery? I'm expecting something like ...
cmd.Parameters.Add("@theDate", SqlDbType.VarChar, 20)
cmd.Parameters("@theDate").Value = "getdate()"
View 5 Replies
