CommuniMail - Need to Use MS SQL

Message
Author
RickSanson
Posts: 36
Joined: Mar 14, 2007 6:27 pm

Need to Use MS SQL

#1 Postby RickSanson » Apr 06, 2007 8:22 pm

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
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

Re: Need to Use MS SQL

#2 Postby admin » Apr 09, 2007 6:22 am

RickSanson wrote: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
Posts: 36
Joined: Mar 14, 2007 6:27 pm

#3 Postby RickSanson » Apr 09, 2007 10:10 am

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
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#4 Postby admin » Apr 09, 2007 10:35 am

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
Posts: 36
Joined: Mar 14, 2007 6:27 pm

#5 Postby RickSanson » Apr 09, 2007 11:22 am

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
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#6 Postby admin » Apr 09, 2007 11:26 am

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

RickSanson
Posts: 36
Joined: Mar 14, 2007 6:27 pm

#7 Postby RickSanson » Apr 09, 2007 11:42 am

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
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#8 Postby admin » Apr 09, 2007 11:45 am

$dbh defined in database module.

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

RickSanson
Posts: 36
Joined: Mar 14, 2007 6:27 pm

#9 Postby RickSanson » Apr 09, 2007 11:46 am

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

RickSanson
Posts: 36
Joined: Mar 14, 2007 6:27 pm

#10 Postby RickSanson » Apr 09, 2007 11:49 am

$dbh defined in database module.
Which is where please?