| View previous topic :: View next topic |
| Author |
Message |
RickSanson
Joined: 14 Mar 2007
Posts: 36
|
 Posted: Apr 06, 2007 8:22 pm Post subject: Need to Use MS SQL |
 |
|
Great Applicaiton!
I need to use MS SQL as a backend DB. Any suggestion regarding DBD::ODBC and where that may be configured???
Thanks! |
|
| Back to top |
|
 |
admin
Site Admin
Joined: 22 Mar 2006
Posts: 1287
|
| Posted: Apr 09, 2007 6:22 am Post subject: Re: Need to Use MS SQL |
|
|
| 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 |
|
| Back to top |
|
|
RickSanson
Joined: 14 Mar 2007
Posts: 36
|
| Posted: Apr 09, 2007 10:10 am Post subject: |
|
|
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! |
|
| Back to top |
|
|
admin
Site Admin
Joined: 22 Mar 2006
Posts: 1287
|
| Posted: Apr 09, 2007 10:35 am Post subject: |
|
|
| 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. |
|
| Back to top |
|
|
RickSanson
Joined: 14 Mar 2007
Posts: 36
|
| Posted: Apr 09, 2007 11:22 am Post subject: |
|
|
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! |
|
| Back to top |
|
|
admin
Site Admin
Joined: 22 Mar 2006
Posts: 1287
|
| Posted: Apr 09, 2007 11:26 am Post subject: |
|
|
| The only one way is to use everywhere DBD::ODBC and then correct _ALL_ not working queries. We do not see other way. |
|
| Back to top |
|
|
RickSanson
Joined: 14 Mar 2007
Posts: 36
|
| Posted: Apr 09, 2007 11:42 am Post subject: |
|
|
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! |
|
| Back to top |
|
|
admin
Site Admin
Joined: 22 Mar 2006
Posts: 1287
|
| Posted: Apr 09, 2007 11:45 am Post subject: |
|
|
$dbh defined in database module.
As for consulting, not sure that we able to provide such service as free support for Communimail. |
|
| Back to top |
|
|
RickSanson
Joined: 14 Mar 2007
Posts: 36
|
| Posted: Apr 09, 2007 11:46 am Post subject: |
|
|
| Free??? I didn't say free... |
|
| Back to top |
|
|
RickSanson
Joined: 14 Mar 2007
Posts: 36
|
| Posted: Apr 09, 2007 11:49 am Post subject: |
|
|
| Quote: | | $dbh defined in database module. |
Which is where please? |
|
| Back to top |
|
|
|
Register
Search
Profile
Log in to check your private messages
Log in
