YAFLogo

eutychus
  • eutychus
  • 100% (Exalted)
  • YAF Lover Topic Starter
10 years ago
Hello, friends ...

I am trying to set up yet another forums on a brand new website, but a having problems getting past the connection string stage.

I have tried the following formats in my db.config file:

"Server=MYSQL5005.MySitePanel.net;Database=db_99c78f_yaf;Uid=99c78f_yaf;Pwd=YOUR_DB_PASSWORD;"

or

"Driver={MySQL ODBC 5.1 Driver};Server=MYSQL5005.MySitePanel.net;Database=db_99c78f_yaf;Uid=99c78f_yaf;Password=YOUR_DB_PASSWORD;"

With either one, it either fails the database connection test or it says that the connection string is in the wrong format.

Is there a different connection string format I should be using?

Thanks!

Sponsor
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer
10 years ago
Currently YAF doesn't work with MySQL. Even if you use some previous versions that worked you shoud use MySQL .NET connector.(ADODB)
eutychus
  • eutychus
  • 100% (Exalted)
  • YAF Lover Topic Starter
10 years ago
Can you give me an example of a connection string I should be using then?
eutychus
  • eutychus
  • 100% (Exalted)
  • YAF Lover Topic Starter
10 years ago
Anyone? Anyone? Bueller? Bueller?
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • YAF Leader YAF Version: YAF 3.1.16
10 years ago
I don't use MySQL, but if you want MS SQL, this is what works.

<add name="yafnet" connectionString="Data Source=serverHERE;Initial Catalog=databasenameHERE;User ID=usernameHERE;Pwd=passwordHERE;" providerName="System.Data.SqlClient"/>

Can you give me an example of a connection string I should be using then?

Originally Posted by: eutychus 

eutychus
  • eutychus
  • 100% (Exalted)
  • YAF Lover Topic Starter
10 years ago
Okay ... is it possible to use YAF with an access database (*.mdb) stored in the App_Data folder of an existing application?
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
10 years ago
No only ms sql is upported
eutychus
  • eutychus
  • 100% (Exalted)
  • YAF Lover Topic Starter
10 years ago
Good enough! Thanks for your help!
eutychus
  • eutychus
  • 100% (Exalted)
  • YAF Lover Topic Starter
10 years ago
Woot! It works!
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer
10 years ago

No only ms sql is upported

Originally Posted by: tha_watcha 

Keep in mind that:

1. My scripts for MySQL, Firebird and Postgre are under GPLv2, that is incompatable with current YAF's Apachev2 version. Normally,you can use it with previous YAF versions only before the license was changed to Apache2.

2. I was fixing bugs for more than in year in my personal vzf code only, you will have troubles, because many things were changed and you can't use the scripta from the box.

3.Jaben's changes in datalayer don't fit with data layers because some data types should be prepared first. You will be forced to apply patches to ORM.

I just warned you about pitfalls. If I were you a would stick to MSSQL Server in the current situation.

eutychus
  • eutychus
  • 100% (Exalted)
  • YAF Lover Topic Starter
10 years ago
One quick suggestion. It might do well to mention in the installation instructions that it must be an MS SQL database. When I read it, it just said to create a database which, to most users, would suggest MySQL. I think mentioning that in the instructions would save a lot of frustration with us newbies.
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
10 years ago

One quick suggestion. It might do well to mention in the installation instructions that it must be an MS SQL database. When I read it, it just said to create a database which, to most users, would suggest MySQL. I think mentioning that in the instructions would save a lot of frustration with us newbies.

Originally Posted by: eutychus 

Not sure which install instructions you mean but in the documentation (wiki)

https://github.com/YAFNET/YAFNET/wiki/Installation 

It already says in the Installation Requirements ... "Microsoft SQL Server 2005 or above."