Connect to a database with ASP?

både og - et eksempel på mysql;

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={mysql};SERVER=database_server;DATABASE=database;UID=brugernavn;PWD=password;"

og så mssql;

set conn = server.createobject("adodb.connection")
conn.open "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=database_server;uid=brugernavn;pwd=password;DATABASE=database"

Hello!

But I guess I can't just copy the files in MySql togheter with the ASP-app to an other computer and run? I need the MySql-application as well?

With other words: Is it only possible to move an application in ASP to an other system with a database like Access that builds one databasefile that can be used with out the database application?

Best regards

Fredrik

do you understand danish or do you prefer english?

Hello!

I'm from sweden and I have some difficulties to understand danish I'm afraid. So prefer english if this it is OK.

Best regards
Fredrik

ok...

access/asp can be moved to everywhere where you have an ASP-server - that means a computer with PWS/ISS

MySQL/asp is not so easy to move, but first of all you need a PWS/IIS server again so that the ASP can be runned. MySQL needs a MySQL-"server" (that just mysql in itself) and the MYODBC driver - if that is installed on the other computer it is easy to move the database alså, but it needs one change in the setup (in the db-connection in your ASP) because the servername, username and password can be a different from the original computer.

but does the other computer not support MySQL it is not possible to move the asp/mysql files and then expect the site to run...

hope that answers your question - else just ask

Hello!

Then I guess that is not possible at all to connect to a MySQL or MSSQL with PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA since it seems to use a path to a database file?

/Fredrik

correct - each database have its own connection... thats why i said you have to write this to connect to mysql;

Conn.Open "DRIVER={mysql};SERVER=database_server;DATABASE=database;UID=brugernavn;PWD=password;"


and mssql

set conn = server.createobject("adodb.connection")
conn.open "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=database_server;uid=brugernavn;pwd=password;DATABASE=database"

Hmm!
Ok, just one more question.

For MySQL you use:
Conn.Open "DRIVER={mysql};SERV.....

But for MSSQL you use:
conn.open "PROVIDER=MSDASQL;DRIVER={SQL Server};SERV...

What does "PROVIDER=MSDASQL; do for good since you do not use it with MySQL?

Best regards
Fredrik

well - it is to different drivers... you cant install your graficcard sith the drivers from your soundcard

Hmm!

But it seems to be total different technics:

For MySQL you use:
Conn.Open "DRIVER={mysql};SERV.....

But for MSSQL you use:
conn.open "PROVIDER=MSDASQL;DRIVER

For MYSQL you do not use Provider at all, but a driver. Can you explaine what the Provider does, compare to just use the driver.

Best regards
Fredrik

they just have each their way - with access you can also connect with a driver instead of a provider

Then my absolute last question, it is not possible to connect to a MySql with the PROVIDER-way?

Best regards
Fredrik

dunno - maybe you can read it at www.mysql.com

but is it important to do that?

I just would like to know all the ways it is possible to connect to a database and wich one is the best.

Best regrads and tanks for your time.
Fredrik Andersson

The "provider"-method connects directly to JET which is the database - but the "driver"-method connects to access which is only a frontend to the database JET. Therefore the way to tha data is shorter with the "provider"-method...

but i cannot answer that talking about mysql and mssql - but as far as i know there is only one way to these databases... but again; on the mysql and microsoft pages it should be possible to read much more