can not find installable isam

[Guest]

I have created a mysql database on a host server and have put webforms on the
host server. I have within my code behind files the connection string for a
mysql prov and when a web forms attempts to hit tables I get the above error:
can not find installable isam. I have attempted to contact my hoster but he
has not been very helpful. The actual string for connection is:

strsqlconnection = "Provider=MySQLProv;Data Source="the host server
name given to me";Initial Catalog=my database name;UserId=my user
nae;Password=my password;"

any wisdom? Thanks.

 

[Shawn Wildermuth (C# MVP)]

Hello bindurajeesh,

Most likely you're trying to use this with the OleDb managed provider. AFAIK,
ISAM's are only exposed through their ODBC driver which would require the
Odbc Managed Provider. If you are not using either of these, some more context
to the kind of managed provider you are using would be useful (e.g. show
us a snippet of the code where you assign the connection string includeing
what Connection class you're using).


Thanks,
Shawn Wildermuth
Speaker, Author and C# MVP
http://adoguy.com

 

[Guest]

Thank you a snippet follows:

strsqlconnection = "Provider=MySQLProv;Data
Source=mysql29.secureserver.net;Initial Catalog=memphisproject;User
Id=memphisproject;Password=Hodge121;"
objoledbconnection = New OleDb.OleDbConnection(strsqlconnection)
objoledbcommand = New OleDb.OleDbCommand
objoledbcommand.Connection = objoledbconnection
objoledbcommand.Connection.Open()
strsql = "select businessname, password from tblSponsor where
businessname = '" & txtBusinessName.Text & "' and password = '" &
txtPassword.Text & "'"
objoledbcommand.CommandText = strsql
objoledbdatareader = objoledbcommand.ExecuteReader
objoledbdatareader.Read()

Thanks

 

[Shawn Wildermuth (C# MVP)]

Hello bindurajeesh,

Off the top of my head, my guess is that the connection string is incorrect
in someway. Have you tried to see if your connection string is valid here:

http://www.connectionstrings.com/


Thanks,
Shawn Wildermuth
Speaker, Author and C# MVP
http://adoguy.com

 

[Guest]

yes I have gone to that site and even took out the initial catalog entry in
the string. I changed code to use odbc.connection etc. and added dsn to the
connection string to no avail. Thanks for your comments. I will continue my
search.