Is it possible to use a file browser to load a connection string when the start form is loaded?
Using ofb As New OpenFileDialog
If ofb.ShowDialog = Windows.Forms.DialogResult.OK Then
Dim cConnectionString As String = ofb.FileName
[Code]....
Is there a way to display the connection properties dialog for connection string browsing(for database) in run time?
As I want the user to be able to connect to various database using the GUI.
Between ODBC and OLEDB providers, which one is more flexible at both the application level, and at the report level using crystal report?
View 1 RepliesI would like to enable my app to run from a central database, but I dont want to recompile should the DB server change. Are my only two options saving the connection string to an XML file or the registry?
If so I think the XML file will probably be the way I go at least for me. I dont really want to mess with the registry. I just wanted to check what my options are.
How To Editing The "Connection String" in the Configuration file by the Code in the Runtime. This is my Code
My.MySettings.Default.Item("ConString") = "New Connection String"
My.MySettings.Default.Save()
This code can edit the Configuration file in the run Time but if I restart the system the Configuration file will return back to the first Configuration.
I have 4k records in access database. And one of the field value contains ~100 lines each so and one other field has ~25 lines. So total database size reaches ~30MB and it takes lot of time 15-20 seconds to load the database in vb.net using odbc [URL]..and updating of any other small fields also takes time due to database being large
So as an alternative I used rtf file (txt files were not preserving all the newline characters). So these file are around 5-10kb only. But for 4k records and 2 fields I have now 8k files. And copying of these 8k rtf files is taking huge time for 5MB transfer it takes an hour or so.So is there any other alternative for storage of this data. So that it will be portable and easily loaded/accessed/updated from vb.net?
I want to ask that where to store connection string in VB.Net.AS in ASP.net we can store connection string in web.config file and access it in the foll. way [code]In VB.net where to store conn. string on form_Load or any other place???
View 1 RepliesI have a question about the App.Config file. My understanding is that the connection string is stored within this file. I have setup my application so that the App.Config file is not only written to c:users<username>appdatalocal but also to c:users<username>appdataoaming. I plan to encrypt the connection string, my question at this point is will it encrypt the connection string in ALL copies of the App.Config file? It looks like at this point that the App.Config file is stored in two places on the hard drive.
View 2 Replies1.is it possible to save the database connection string to the textfile so that user would be able to know where the database is stored?
2. Any way to let the user decide where the database is stored? Since usually we, the programmer write the database connection string ourselves..
how to load a .bak file of database backup in sql server 2005 using vb.net 2008 windows application?
View 5 RepliesI am trying to upload a SQL dataBase onto VBasic, but I keep getting a connection error Error version 655, the application useses versions of 612 and earlier.What can I do to fix this error. I am using SQL server 2008 and Visual Basic 2008...
View 5 RepliesWhen I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
[code].....
I'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
View 3 Repliesi'm making a utility in which i'm loading 100,000 records again and again, problem is that it takes much time to load records in datagridview every time.
i've used data set and data reader both but same result. if i use paging then there's will be a problem of search a record on keyup event.
and advise how I can change this connection string at run time. This is going to be on Client's computer and my application will need to change the name of computer after user enters it.
View 1 RepliesI have written a program which connects to MS sql express 2008 using the string below. This is OK on my computer but when I try to run this on a client computer I get the following message: "An attempt to attatch an auto-named database for file :(C:UsersBarry2010 vb programsadotrialadotrialResults 6.mdf) failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
[Code]...
How would I load a .html file into a web-browser control?
View 2 RepliesUsing - VB2008 Express, XP Pro,
Connecting to SQL 2005 across the internet
The walk throughs have several good explanations although I don't see any about connecting over the internet.
I used the wizard in VB 2005 to add my database. Under the "Applications Settings" area in VB my string is currently set to:
[Code]...
what is the connection string for Access for connecting Access Database with ADO.NET (For win app).
View 1 RepliesConnection String Using .net 2005 With Sql Server 2000?
View 1 RepliesI am trying to connect VB 2008 express with sql 2005 standard edition on a reomte server. Is this possible or VB 2008 express version limits this Can some one guide me with the connection string to achieve this.
View 1 RepliesWhat is the connection string for the sql-Server express?
I did this
CODE:
But this connection string is not correct:
CODE:
What will be the correct one?
how to code for database connection in vb.net 2005?
View 3 Replieshow to code for database connection in vb.net 2005?
View 1 Repliesi have visual studio 2005 installed in my pc.i have sql server 2000 as database.i have expertise in client server software written in vb6.now im trying to do the same in vb.net.i dont know how to establish a global connection in vb.net.how to do that in vb.net?in vb6 i would just write a public function in a module and it remains throughout my application.so how can i achieve the same thing in vb.net.
View 4 RepliesI've developed a software using VB.net and SQL server 2005. This is the connection string that used. Data Source=MY-PC\SQLEXPRESS;Initial Catalog=studentInformation; Integrated Security=True But now i want to use SQL server compact edition. So what should i change in this connection string?
View 11 RepliesWhen connecting to data I always like to use the Configuration methods:
2005
Dim settings As ConnectionStringSettings = _
onfigurationManager.ConnectionStrings("csCambra_2")
[code].....
How do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand()
cmd.Connection = My.Settings.Item("csStaffHoursWorked")
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "spSaveDeltekImport"
I am working on designing a SQL Server database connection class in VB.net 2005. The idea behind doing this will be so a developer can can call the class, pass it a stored procedure name along with the parameters, and get return values back (if any).
View 1 Replies