I need a connection string for connecting database. I have already used the connection string following.
connStr= "Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\mydb.mdb;Data Source=SampleDSN";
But, I got error as "Data source not found and no default driver specified".
[URL]
I have a problem connecting with mysql server 5.1. I tried several methods and been a lot of googling too but can't find the solutions yet. Here's the installed component btw[code]...
View 2 RepliesI recently upgraded to developing on a 64bit windows 7 system from 32 bit xp. I am using VS2010, same install from the old system.My apps have always targeted a x86 systems If I change this to target x64 on my new system the app can no longer connect to my database (Progress).
View 8 Repliesi have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes" i need to change that to - "data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30" when i just change the text it gives this error - "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
View 2 Repliesi have a code which has the connection string as driver.dim s as string = "Drr={SQL Server};Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"i need to change that to"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"hen i just change the text it gives this error -"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
View 13 Repliesodbc driver not found unable to connectmysql 5.1 odbc already installed and i have the following code to connect mysql
Imports System.Data.Odbc
Conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;" + "DATABASE=apdata;UID=root;PASSWORD=acelle;Port=3306;"
[code].....
I have an Entity Data Model with two entities in it "Roles" and "Users". There is a navigation property from I have a EntityDataSource and a GridView. The EntityDataSource points to the Users entity and has an Include="Roles" parameter.I've added a BoundField in the GridView that points to RoleName, a property of the entity Roles. However, when I execute the code I get the above error.I have used very similar code successfully in another application. Any ideas why this isn't working?
Here is my EntityDataSource:
<asp:EntityDataSource ID="EntityDataSource1" runat="server"
ConnectionString="name=pbu_checklistEntities"
DefaultContainerName="pbu_checklistEntities" EnableDelete="True"
EnableFlattening="False" EnableUpdate="True" EntitySetName="Users" Include="Role">
</asp:EntityDataSource>
And here is the BoundField:
<asp:BoundField DataField="RoleName" HeaderText="Role" SortExpression="RoleName" />
I have got this error No default member found for type 'VB$AnonymousDelegate_0(Of SqlDataReader,String,Object)'.
My Code is below
dsBranch.Tables.Add(GetDataTableFromSQLReader(dr, "")) - Calling
Private Function GetDataTableFromSQLDataReader(ByVal dr As SqlDataReader, ByVal TableName As String)
[code]....
I'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
I have a label printer with the driver loaded with the settings in the driver set I can print the exact label that I want, I have the problem that I need to set the default settings in the driver when the software starts. there are 6 of these printers and the only problem we have found is that different operators like to change the settings.
What I need to do is to set the following commands in the driver so each time the system is started (daily) it loads the settings and works properly.
I need to set
Custom Commands Text, Start, Parsed Text
In the Advanced Setup, turn on use printer settings
Other settings would be usfull but as I cannot set these I do not think I will be able to set others.
I can currently set some of the commands eg,
DefaultPageSettings.PrinterSettings.Copies=2
I am developing a software that will monitor/poll serveral Modbus/TCP devices on a network.
I have managed to connect to one device using VB.Does anyone know of a driver or perhaps a 3rd party software I could use that will enable me to connect to more than one Modbus/TCP device?
I am looking for the standard source code for a keyboard. Is there any where that I can download this source code so that I can modify it for my own use?
View 2 RepliesWhen trying to add a new data source (connect to database with .mdf extension stored on my computer)verything goes well until I get to he step giving me the option to save the connection string, then I get the following error message: "An unexpected error has occurred. Error message: Could not load type 'Microsoft.VisualStudio.DataDesign.SyncDesigner.SyncFacade.SyncManager' from assembly'Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage, Version=9.0.0.0, Culture=neutral,PublicKeyToken=b03f5f711d5013a'. I am taking a course online in Advanced Visual Basic and most of it involves working with databases. If I cannot get past this error, I cannot do any of theassignments. I am using the free 90 day download of Visual Studio 2008 and will buy it before trial expires, but only if it starts working and stops generating error messages
View 4 RepliesI got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
Here is my dataset.xsd code
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)"
[code]....
I'm just trying to implement a 'no duplicates' catch on my insert customer form, but it just slips through my if statement to the else everytime. This is the source. Also I tried a .Equals with the same results :(
Protected Sub srcAllClients_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs) Handles srcAllClients.Inserting
[Code].....
I developed a winform application and I want to send the .exe file to someone else. That means that my datasource for my connection string is not the same any more
Dim da As OleDbDataAdapter
Dim dt As New DataSet
Dim objConnection As OleDbConnection = New OleDb.OleDbConnection
[Code]....
Trying to figure out if there is anyway built into windows 7/Vista/XP and/or Dpinst to verify that a driver is installed? I created a program that uses DPinst to install a driver and now I need to figure out how to tell the user that it is safe to close the program once the driver is install as the driver takes longer on some machines to install. Would anyone know how to get this to work?
View 7 RepliesHow do I strip out the data source from the connection string so that I only have the directory path and file name.
My connection string is thus:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMartinMy DocumentsVisual Studio 2008ProjectsRestelRestel IIRestel IIRestel.mdb
I'm creating a dataset (AddressDataset) that has 2 datatables - addreess and state.
Addrees: line varchar, state_id number
State: state_id number, state_name varchar
I've created a data relation between state id on these tables. I'm setting up to combo boxes: cboAddreess, and cboState. I'd like cboState to change to the correct value when address changes.
Dim dbSelCommand As OleDbCommand
Dim dbSelCommand2 As OleDbCommand
dbSelCommand = New OleDbCommand
[code]....
This gives me "address cannot be found in binding source".
My program so far reads a certain webpage's source code and places it in a textbox. This much has already been accomplished.
Now I need to pick certain strings out of the rather large amount of text data and have the lines stored in variables, but the trick of it is, the exact string is unknown. The exact function should be, that the code finds certain tags from the source code, say <td> and </td> and takes the string data in between those tags, what ever it may be.
I'm using an ObjectDataSource to bind an object to a GridView. In the OnRowDataBound event handler I'm trying to determine if a certain button should be visible or not. When the runtime encounters this statement it fires an "No default member found for type 'Pledge'." error[code]...
View 1 RepliesI am looking to make a data connection with a network server(sql server 2005). When I run the data source configuration wizard, it allows me only to pick a local database file. I want to use a connection string like this "Data Source=SQLSERVER;Initial Catalog=mydb;User Id=username;Password=password;" I know I can do that programmatically. But I would like to know whether I can do that using the data source wizard so that I will be able to use Bindingsources and tableadapters.
View 4 RepliesI'm trying to use ASP.NET MVC with older versions of IIS that have trouble with MVC's default routing. I found a suggestion to add .mvc.aspx to my routes. So instead of this:
routes.MapRoute( _
"Default", _
"{controller}/{action}/{id}", _
[Code]....
What do I need to change in IIS and/or my MVC application to get the default page to work correctly?
NOTE: I tried adding RouteTable.Routes.RouteExistingFiles = True per this answer, but that didn't seem to fix the problem.
i googled many and many keywords and sentences but , i cant found a code that opens the default web browser and gets it a address ( address is : text1.text )
View 3 RepliesI have XML files I am trying to read and import. I have XSD files and have used the XSD.exe tool to create classes for the elements found in the XML files. The problem I have having is that the same file structure can be used for different "message types" (different data structures for different purposes). Because of this, the structure of the file is roughly this:
<Envelope>
<BatchID>SomeNum</BatchID>
<Messages>
[code]....
Where the Order element is, it could be one of a few different element types in the message based on the message type. Currently, I'm trying to read an order file.The XSD tool created all the classes fine but it creates an 'Item' object for that inner element and makes it one of the other strong types during the deserialization, so I end up with something like:
Envelope.Messages(0).Item
Item is just an object and is not strongly typed until the deserialization happens. If I look at the data in Item in a watch window during debugging, it shows it is the strongly typed class and has all the data in the members I would expect to see, but I can't seem to access them by name or set an instance of the strongly typed Order class equal to the Item object. Any attempts I've made so far to read the data have resulted in the "No default member found for type 'Order'" error.
Im trying to set one variable equal to another but it says "No default member found for type 'Decimal'" what does that mean?Both the varuables are deciamls, one is a regular decimal that I declare in the sub and another is an array that I declare in the class. The line is:
tempx = xo(i)
this is in a for loop with i as the variable.
I used to run the following code on WIN XP PRO and it used to work. But why not running anymore on WIN 7:
Dim Log As New System.Diagnostics.EventLog()
Log.Source = "Demo Log"
Log.WriteEntry("Hello World", EventLogEntryType.Warning)
It gives the following error message: The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security.Luai Alrantisi, BSc in Computer Engineering, University of Ottawa 2007, Canada. IT Manager of MTN Mobile Telecom.
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
I have an ADSL connection that requires username password login (PPPoE). This looks just like a phone dial up connection dialog box.But all the codes i've seen for automatically connecting to internet, or even detecting a connection do not work.I'm looking for a way to have my software check for an active connection to internet, and absent that, to connect via the default connection.I'm on XP. I don't know if that makes a difference.I have set properties to save the username password and not to prompt for them. So if I double-click the connection it will connect without any dialog box.
View 4 Replies