Newbie Connection Question

[cyberbiker]

I have no knowledge of MySQL to speak of so please be patient. I am at the "Crawl before you walk stage"
I am currently developing an application using SQL Server7 Desktop. I am looking at the feasablity of perhaps distributing this app with MySQL
I currently use WindowsNT Security to connect to the database. Would I be able to do the same with MySQL?
My current connection string is:
"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=disdb;Data Source=TERRYLAPTOP"

If I understood what I read last night, this string should work by changing the provider and the datasource.

Is this a substantially correct understanding?

Terry (cyberbiker)

 

[sleipnir214]

MySQL, to the best of my knowledge, can only use its internal user tables for authentication. NT authenication is not available because MySQL is platform agnostic, so the authors have to write for every platform.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[cyberbiker]

Interesting and actually should have been obvious.
I am working on an app that will be sold to various size organizations. I had planned on using Access database tables for small customers and SQL Server for larger.
I was asked about using my app with a SCO UNIX server and went exploring and began developing some interest in MySQL as an option for the smaller companies as well as larger companies based on the information I have found.
I need to finish this app for demo purposes before I get to far afield, but it looks as if although my app will need very little modification to connect to MySQL, it will need some modifications. However, I think it will need no more modifications than I will need to make for the ACCESS version and the pricing looks real good to my eyes.
It did quit snowing here, but now my pickup is sitting on ice so it will be tomorrow before I can get to the book store.
Hopefully, the next question I ask will be more sensible.
I truly appreciate your help.

Terry (cyberbiker)

 

[ingresman]

This is an interesting area, cross db security. I'd love to do some work around LDAP but I havn't got the time or resource