473,414 Members | 1,609 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

Type Expected, err in vb 2015. trying to define a mysql connection

1
Hello, I keep finding this err, on the line " Public conn As New MySqlConnection(constr)" stating that type expected and I cant seem to find the problem, please help.

Expand|Select|Wrap|Line Numbers
  1. Imports MySql.Data.MySqlClient
  2. Imports System.Runtime.InteropServices
  3. Imports System.Text
  4. Module Module1
  5.     Public constr As String = "server=localhost;userid=root;password=;database=library"
  6.     Public conn As New MySqlConnection(constr)
  7.     Public com As New MySqlCommand
  8.     Public adptr As MySqlDataAdapter
  9.     Public fullname As String = ""
  10.     Public usrid As Integer = 0
  11.     Public username As String = ""
  12.     Public usType As String = ""
  13.     Public usLevel As Integer = 0
  14.     Public callingBookFom As Integer = 0
  15.     Public printchecker As Integer = 0
  16.     Public ReadOnly a As Object
  17.     Public Property ChFr As Integer
  18.     Public Property NoCh As Integer
  19.     Public Property ChTo As String
  20.     Public Property RS1 As Object
  21. End Module
Sep 27 '15 #1
0 1309

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Luke Wojtow | last post by:
Hi all, http://bugs.mysql.com/bug.php?id=3779 Discussion about insecurity of mysql_pconnect in multi-server/multi-user environment.Can anyone explain what Hartmut Holzgraefe meant by "But even...
0
by: DH | last post by:
I must work with phpMyAdmin 2.6.0-pl3 installed on a client's Windows NT web server. I've not previously encountered options for charset and collation using phpMyAdmin, and am not sure what to set...
0
by: Peter Höltschi | last post by:
I try to install MySQL Connection/J on a Windows XP box. MySQL on localhost works fine. But I cannot load the MySQL Connection/J Driver. The CLASSPATH variable is set like this:...
3
by: Jon | last post by:
I'm learning about datatables. When using the example provided by MS in the ..NET Framework Class Library for DATATABLE (see below) I get an error on line 3 that says "Type expected". Is something...
14
by: Geoff Jones | last post by:
Hi I'm trying to use a class that I've written in a form. Unfortunately, when I write something like: Public x As New myClass I get the compile time error: "Type Expected". Indeed, the...
4
by: obmij | last post by:
Hi all, I am a WAMP newbie and would appreciate your help! I have installed Apache 2.2.4, Mysql 5 and PHP 5 have got them all up and running and tested them separately, I was able to do the...
3
by: tulika dutta | last post by:
after 8 hrs my MySQL connection with JDBC gets time out. It gives the error java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying...
6
by: Matt Rose | last post by:
Update a MYSQL db password using crypt() technology on MYSQL connection. I am looking to update a user table of passwords that were inserted without using crypt() on a Perl development project. I...
1
by: ziycon | last post by:
I'm developing an application in VS2008 using c# and I had a SQLite database work but want to go with mySQL. Can anyone point me to the best way to use a mySQL connection with c#, should I use a...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.