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 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 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 RepliesI 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]......
Is there a way to get a list of ODBC drivers that are installed on a Windows XP machine from .NET?
I basically would like to see (in .NET) what is in:
Control Panel->Administrative
Tools->Data Sources (ODBC)->"Drivers"
Tab.
how to install a ODBC driver using vb.net windows application ?
View 3 RepliesI'm receiving this error from the ODBC SQL Driver as mentioned :- ERROR [07002] [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error.
Here's my VB
CODE:
And this is the stored procedure i'm calling :-
CODE:
I currently connect to a MySQL database using the ODBC MySQL 5.1 Connector, how would I be able to detect if the driver is installed before a connection attempt?
View 4 Repliesthis is code where i want to insert ConnectionString=<%$ConnectionString =""%>[code]....
I can not connect MySql (SQL YOG) at all to this control, this is prob from .net control and not MySqlMark the thread as answered
Can anyone recommend an ODBC driver for Excel in VB 2010 Express? This is a 'legacy' problem having just being forced to move from VB6 to 2010.
View 1 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 am new to vb .net i just want to ask why is it i don't see the odbc data adapter in the toolbox pane? i just have (under data) pointer, dataset, datagridview, bindingsource, and binding navigator.
View 3 RepliesI am using MySQL ODBC 3.51 Driver to connect odbc to MySQl.But it shows the following error.
[Code]...
I'm currently doing a project that includes access 2010 My question will be what driver can I use for an access 2010 *.accdb type file? For a *.mdb it works perfectly well with
ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
But, when I changed the mbd to accdb:
ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"
It resulted in errors:
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'
And then it shows me that my code for
If dsLogin.Tables(0).Rows.Count = 1 Then
IndexOutOfRangeException was unhandled
Cannot find table 0
I knew it must be the driver but I don't know what accdb driver I can use for the connstring.
I'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 RepliesHow would I convert the two individual byte values (in hex) to a decimal value representing the concatenated hex values? For example, if I have the
Dim byte1 As Byte = &H99
Dim byte2 As Byte = &H99
' I want the decimal representation of the hex value "9999" ' (byte1.ToString + byte2.ToString) which should be "39321" Currently I use the following code:
Dim decVal as integer
decVal = Val("&H" + Hex$(byte1).ToString + Hex$(byte2).ToString)
However, when I use this, the value (decVal) comes out to "-26215"
I think I need a two dimensional byte array I currently have something like this:
Dim MbyteData(196608) As Byte
' Open the file that is to be loaded into a byte array
Dim oFile As System.IO.FileInfo
oFile = New System.IO.FileInfo(sFilePath)
[code]....
I now need to load several files at once (say four) so I need four arrays of 196608 bytes and I want to reference them by a number - 0 to 3, assuming the array is zero based. If I use Dim MbyteData(196608, 3) as byte or Dim MbyteData(3, 196608) as byte the syntax seems to be correct but I hit an error ("Number of indices is less than the number of dimensions of the indexed array") when I try to add the extra dimension to the stream read with something like oFileStream.Read(MbyteData(index), 0, MiByteCount).
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 RepliesIs it possible in VB to truncate a larger data type ( an int with a value greater than 255) to a smaller one, say a Byte (which only goes up to 255) in a way such that the 8LSBs of the integer are copied to the newly created byte. I have tried this using CType with the following code, however it does not work.
Dim TestByte As Byte = CType(Test, Byte)
Where the variable "Test" is an integer with a value of 419. This code always results in the Overflow exception.
[code].....
When I used to use Farpoint controls (w/VB6), there was an option on a listbox to set it to mulit-character search mode. It seems that VB.NET (at least 2005) doesn't have this capability. If I type a "G" and then an "A", it first jumps to the first item that starts with a "G" and then the first item with an "A". I want it to jump to the first item that starts with "GA." What is the easiest way to accomplish this functionality?
View 8 RepliesHow should I split a string separated by a multi-character delimiter in VB?
i.e. If my string is say - Elephant##Monkey, How do I split it with "##" ?
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 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 have a small vb.net application that fires a crystal report through crystal viewer.
The report uses an ODBC connection provided by 32-bit software accounts package, which is installed in the ODBC 32-bit This all works fine on 32-bit XP and 32-bit Win7 with no problems, When run on a win7 64-bit machine the application launches ok, but when it comes to running the report, it prompts for a database logon box for the odbc connection.
When the report is run seperate on its own, on the exact same pc through crystal reports desginer it runs fine, Its almost like the application is not picking the 32-bit ODBC set up is it the case that the connection needs to be coded rather than using the report connection,
i 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 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 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]
Why does C# define Byte+Byte=Int32 instead of Byte+Byte=Byte like VB?
View 1 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]....