ODBC driver does not support the requested properties

[freshervb]

Hi guys


I'm connecting VB with mysql database using mysql connector/odbc v5 driver. While executing following error comes


RUn-time error '-2147217887 (80040e21)': ODBC driver does not support the requested properties


Any body known this ,reply pls

Will mysql connector/odbc v5 driver support stored procedure


thanks

[sagarpassion]

hi,

odbc driver 5 is beta version. it having problem. bettere use 3.51.
wat u have write in connectionstring??

sagar.

[freshervb]

hi sagar

I'm using this connection string

gConStr = "Driver={MySQL Connector/ODBC v5 Driver};SERVER=lax-7;DATABASE=deed;UID=sa;PWD=sqladcl;option=18475;"



Will MySQL 3.51 support stored procedures with output parameters




thanks

[sagarpassion]

hi,

I think so. I hope it will work.

sagar.

[asd9001]

Thes Fall Code For MySql 3.51

Dim atch As String
atch = "Provider=MSDASQL;DRIVER=MySQL ODBC 3.51 Driver;Server=localhost;database=agc;Option=16387"
cn.ConnectionString = atch
cn.Open
Adodc1.ConnectionString = cn
Adodc1.LockType = adLockOptimistic
Adodc1.CursorLocation = adUseClient
Adodc1.CursorType = adOpenDynamic
Adodc1.CommandType = adCmdTable
Adodc1.RecordSource = "agc" 'db name
Adodc1.Refresh
 
Set DataGrid1.DataSource = Adodc1
 
DataGrid1.Refresh

[sagarpassion]

hi,

I know 3.51 & it working fine but any one know how to do connector/odbc v5 driver?? problem wid recordset.

[abble]

Dim MyConString As String = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Database=test;User=root;Password=1234;Option=3;"
Dim MyConnection As New OdbcConnection(MyConString)

[RhinoBull]

@abble:

this is NOT VB.Net - this is VB.Classic (VB6 and prior) forum so please pay attention to what and where you post.

[sagarpassion]

hay rhino this is not .net concept. this is just connection to mysql by odbc driver...we r using vb classic

[RobDog888]

OdbcConnection and Dim MyConString As String = "Driver={MySQL ODBC 3.51 Driver};...
are vb.net objects and syntax.
You can not declare a string variable and set it equal to a value on the same line in VB 6, only in .NET

Perhaps thats why you are getting errors if you are using it in VB 6.

[shenen]

hello
i'm new in this forum and also get same problem
when i debug it show the error in this syntax


Set rsGrid = New ADODB.Recordset
rsGrid.Open "select datatemp.no as [NO],datatemp.pn as [PART NUMBER]," _
& "datatemp.nb as [DESCRIPTION],datatemp.jum as [QTY]," _
& " datatemp.harsat as [PRICE] from datatemp", conn, adOpenDynamic, adLockOptimistic

i'm using MYSQL v5 and odbc driver v3.51

does any one have the clue??

[sagarpassion]

there may b prob in query...
print ur query at runtime and check the same....
try below query
----
rsGrid.Open "select datatemp.no as [NO],datatemp.pn as [PART NUMBER]," & _
& "datatemp.nb as [DESCRIPTION],datatemp.jum as [QTY]," & _
& " datatemp.harsat as [PRICE] from datatemp", conn, adOpenDynamic, adLockOptimistic
-----

[shenen]

thx sagar for the reply
i already found solution for the previously problem

but i find another error that really make me confuse


when i debug it also refer to this syntax
rsGrid.Open "select datatemp.no as [NO],datatemp.pn as [PART NUMBER]," _
& "datatemp.nb as [DESCRIPTION],datatemp.jum as [QTY]," _
& " datatemp.harsat as [HARGA] from datatemp", conn, adOpenDynamic, adLockOptimistic

i can fix it by using this syntax
rsGrid.Open "select * from datatemp", conn, adOpenDynamic, adLockOptimistic

but the problem is i cant change the column title like i want

is it because the ODBC Driver doesnt support or what??

[sagarpassion]

no this is not because of ODBC....
try this
----
rsGrid.Open "select datatemp.no [NO],datatemp.pn [PART NUMBER]," & _
& "datatemp.nb [DESCRIPTION],datatemp.jum [QTY]," & _
& " datatemp.harsat [PRICE] from datatemp", conn, adOpenDynamic, adLockOptimistic
----------

[imHanna]

HI.

i got the same problem too and i already changed it MySQL ODBC 3.51 Driver. the error occurred at the bold codes.

TQ


conn.ConnectionString = "uid=studentuser;pwd=123;server=studenthost;driver={MySQL ODBC 3.51 Driver};database=student;dsn=STUDENT;"
conn.Open
Set rs1 = New ADODB.Recordset
'rs1.Open Source2, Connect, 3, 3, 1

conn.Execute "DROP TABLE IF EXISTS daftaryuranasrama", , adExecuteNoRecords

Set rs1 = New ADODB.Recordset

rs1.Open "select * from daftaryuranasrama", conn, adOpenStatic, adLockReadOnly

result = CreateFieldDefFile(rs1, App.Path & "\report\report.ttx", True)

[sagarpassion]

rs1.Open "select * from daftaryuranasrama", conn, adOpenDynamic, adLockOptimistic
try this