Help For ConnectionString Unicode

Mr.akbari

New member
Joined
May 22, 2019
Messages
3
Programming Experience
Beginner
Hi
Please help me
I have a database with password ￿崯๥�徟쩜�槽ஜ떂킁슾Ζ왔䵌䨠鑣
I will add information to the database when I add the database and save the database password in the settings. When I load the data in the database it fails.

Error : Format of the initialization string does not conform to specification starting at index 153

VB.NET:
Me.IDsTableAdapter.Connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\DataBaseApp.mdb;Persist Security Info=True;Jet OLEDB:Database Password=￿崯๥�徟쩜�槽ஜ떂킁슾Ζ왔䵌䨠鑣"
            Me.IDsTableAdapter.Fill(Me.DataSet_DataBaseApp.IDs)
I wrote the following code on the form loading, but it still fails. After many reviews, I noticed that the error is from the database password. Please inquire how to connect to this database with this password.

Please help me
 

Mr.akbari

New member
Joined
May 22, 2019
Messages
3
Programming Experience
Beginner
Hello again
This code is for vb6 years ago
I want to connect to the database now with this password, but it makes a mistake
Error : "Format of the initialization string does not conform to specification starting at index "

Code In Vb6 And DataBase Access 2000 And Password = "￿崯๥�徟쩜�槽ஜ떂킁슾Ζ왔䵌䨠鑣" -> Symbol And Character utf-8

Code:
var_13C = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & var_3E8 & ";Jet OLEDB:Database " & ChrW(80) & ChrW(97) & ChrW(115) & ChrW(115) & ChrW(119) & ChrW(111) & ChrW(114) & ChrW(100) & ChrW(61) & ChrW(1) & ChrW(65535) & ChrW(23855) & ChrW(62229) & ChrW(3685) & ChrW(57110) & ChrW(63041) & ChrW(24479) & ChrW(51804) & ChrW(56531) & ChrW(27133) & ChrW(2972) & ChrW(46466) & ChrW(53377) & ChrW(49854) & ChrW(918) & ChrW(50772) & ChrW(19788) & ChrW(18976) & ChrW(37987) & ";Jet OLEDB:Encrypt Database=True"
Please inquire how to add this password to the Strings connection on vb.net

Please Help Me
Thank you
 

JuggaloBrotha

VB.NET Forum Moderator
Staff member
Joined
Jun 3, 2004
Messages
4,524
Location
Lansing, MI; USA
Programming Experience
10+
I believe you need to add "Character Set=utf8;" to your connection string:
Code:
Me.IDsTableAdapter.Connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\DataBaseApp.mdb;Persist Security Info=True;Character Set=utf8;Jet OLEDB:Database Password=￿崯๥�徟쩜�槽ஜ떂킁슾Ζ왔䵌䨠鑣"
Source: VB.NET, MySQL and Unicode
 

Mr.akbari

New member
Joined
May 22, 2019
Messages
3
Programming Experience
Beginner
I believe you need to add "Character Set=utf8;" to your connection string:
Code:
Me.IDsTableAdapter.Connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\DataBaseApp.mdb;Persist Security Info=True;Character Set=utf8;Jet OLEDB:Database Password=￿崯๥�徟쩜�槽ஜ떂킁슾Ζ왔䵌䨠鑣"
Source: VB.NET, MySQL and Unicode
thanks for your help
But this is the case that you said goes to MYSQL and stores information that is not for the database
thanks
 
Top Bottom