SQL Server other than Microsoft, MySQL?

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Has anyone attempted using an SQL Server other than
Microsoft? MySQL would be easier to implement for our team.
We don't use Microsoft Servers or Microsoft Networking.
Any reason why it couldn't work with MySQL?

Andy
 
Hi andy

Please be a little more specific whats the problem.
We have the server running without any problems...

Best Regards,
Mario
 
The only thing we do, is to copy all the files to a folder, copy my.ini to
%10% and install & start mysql

e:\mysql\bin\mysqld-nt.exe --install
net start mysql


Mario
 
Please, excuse me for not being more specific.
I would like to use MySQL as the host for Target Designer.
I have not actually tried it. I'm simply asking if it can
be done before I spend countless hours attempting it.

Andy
 
With some fairly elaborate hacking - anything is possible.

However, TD was written as a client for SQL Server. It undoubtedly has
connect strings, etc. that refer specifically to starting the appropriate
OLEDB/ODBC/etc.provider (whatever interface they used) for connecting to MS
Sql Server. You'd have to hack TD, or write a replacement provider
(OLEDB/ODBC/etc.) to fool TD into thinking it's talking to MS SQL even
though you'd handle the MySQL Parts.

In short - it's not worth the effort.
 
Back
Top