ODBC driver does not support the requested properties

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

hi,

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

sagar.

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

hi,

I think so. I hope it will work.

sagar.

Thes Fall Code For MySql 3.51

VB Code:

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

hi,

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

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)

@abble:

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

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

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. ;)

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??

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
-----

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

but i find another error that really make me confuse
http://i582.photobucket.com/albums/s...mysqlerror.jpg

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??

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
----------

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)

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