MyODBC slower?

[Wes98765]

I MyODBC connection really slower? If it is I still want to use a dsn connection to the database what should I use?

Thanks

Wes

 

[WizyWyg]

Windows machine right? You need odbc to run mysql correctly.

 

[Wes98765]

So you must use ODBC connection type with mysql when connecting with a windows machine?

 

[QatQat]

What do you need the connection for?

If it is for programming stuff then you can use a DSNless connection, it is definitely faster.

If you are trying to connect from access then DSN may be the only option.


Bye


Qatqat

I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.

 

[apatterno]

In your own programs, you can use MySQL's own libmysql, (functions like mysql_connect, mysql_query etc.).

The reason you must use ODBC for connecting from external applications (such as Access, Excel or Outlook) is that ODBC is a standard interface meant to support a lot of different databases. An "ODBC Driver" is simply a module that handles standard ODBC function calls and turns them into database-specific calls. Although it is slower it still supports a wide range of databases through one uniform interface.

_{I REALLY hope that helps.}
Will