CommuniMail - Need to Use MS SQL

[RickSanson]

Great Applicaiton!

I need to use MS SQL as a backend DB. Any suggestion regarding DBD::ODBC and where that may be configured???

Thanks!

[admin]

Great Applicaiton!

I need to use MS SQL as a backend DB. Any suggestion regarding DBD::ODBC and where that may be configured???

Thanks!

Hello,

we're not sure that application will be able to work with MS SQL, since it was developed to use MySQL and CSV databases. MySQL and MS SQL have a bit different SQL query structure (syntax).

Thanks

[RickSanson]

Thanks!

We can create the table structure exactly like My SQL for Communimail. No problem there!

The issue is the communications (ODBC?) between Communimail and MS SQL.

Any thoughts regards DBD::ODBC?

Thanks!

[admin]

Structure is not a problem of course. The main problem here is queries. For example, complicated query from several tables on MS SQL will look different than on MySQL. And also do not forget about built-in database functions - they are different.

[RickSanson]

Hmmm...

I really, really need to be able to pass, back and forth, data between Communimail and MS SQL...

Any thoughts there at all???

Thank you for your help!

[admin]

The only one way is to use everywhere DBD::ODBC and then correct _ALL_ not working queries. We do not see other way.

[RickSanson]

This is a start and thank you!

Where is $dbh defined??? I assume that mailadmin.cgi is the place to start...

I am not a developer but my technology partner is. The problem there is that he is lost in a Microsoft world and is having difficulty understanding the rest of us...

Is there a chance that you could help me understand Communimail is structured please???

Thank you!

[admin]

$dbh defined in database module.

As for consulting, not sure that we able to provide such service as free support for Communimail.

[RickSanson]

Free??? I didn't say free...

[RickSanson]

$dbh defined in database module.

Which is where please?