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 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 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 RepliesI 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" />
odbc 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 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 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 RepliesTrying 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 RepliesI'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".
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'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 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 have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
I'm using the Microsoft Excel Driver to import an Excel document into a adodb.recordset so that I can remove duplicate rows and put it into the SQL Server database.
The first column has values like 192, 13U, JJJ, etc. but for some reason the query casts it as a double value, and any rows with alpha values get converted to Null. From what I can tell this is because the Majority type is numeric instead of text.
I tried casting it, but got an error.
Here's my function:
Function Read_Excel(ByVal sFile As String) As ADODB.Recordset
On Error GoTo fix_err
Dim rs As ADODB.Recordset
[Code]....
I was able only to get the orignal VC6 code from Silicon Lab , my application being in VB .Net I need to rewrite those function to test my connecttion to a CP210x SL USB/UART driver ( So I can pass RS 232 data to an encoder) How should I declare LPCVOID in the function below. The error I get is :
[Code]...
I have VB Application and VB dll. I am retrieving the data using MS ODBC and through VB application and passing it to VB dll. Dll is then processing the data and inserting the data into Oracle 10g database. Dll uses OraOledb driver. Now when i retrieve the data in my web-page which uses MS ODBC, it displays the data as garbled.
View 10 RepliesI`m using oleDbConnection in order to Select a BLOB data from Oracle column, and I have to stick with this type of connection since all my application is using it.
After I used the following code, I got the error: unspecified [code]....
I have an error "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression". I am using VBdotNet2005 and MS Access as its database, and I can't really get the hang of this error.
View 8 RepliesIm trying to create a windows service with vb.net but when I run: InstallUtil.exe myservice.exe
I'm getting the following error in the MyService.InstallLog file: Restoring event log to previous state for source DebtorInvoiceMailingService.An exception occurred during the Rollback phase of the System.Diagnostics.EventLogInstaller installer. System. Security. SecurityException: The source was not found, but some or all event logs could not be searched.Inaccessible logs: Security.An exception occurred during the Rollback phase of the installation. This exception will be ignored and the rollback will continue. However,the machine might not fully
DebtorInvoiceMailingService.vb
Imports System.ServiceProcess
Imports System.Timers[code].....
I have column in the table of Import but sometimes not insert Image
and i have DataGridView to show image int column image[url]...
I have an error ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. and I've been trying to solve this but unfortunately I couldn't get the hack of this error. I'm a newbie in dotNet.
Public Sub LogInContinue(ByVal senter As Object, ByVal e As EventArgs)
Dim LibDS As DataSet = New DataSet
Dim LibDA As OdbcDataAdapter = New OdbcDataAdapter("SELECT * FROM tblUserAccount WHERE Uname='" & txtUserName.Text & "'", LibConn)
[code]......
Modifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 RepliesI'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