如何在ASP中使用我的SQL [英] How to use my sql in asp

问题描述

尊敬的先生/女士，

在我们的asp应用程序中，我们使用mdb(microsoft access)作为数据库.

现在，我们将我的sql视为后端.

Hi Sir/Madam,

In our application of asp,we have use mdb(microsoft access )as database.

Now we are thinking of my sql as back end.

<%
Set con = Server.CreateObject("ADODB.Connection")
con.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../fooddubai.mdb") & ";PWD=expolink"

%>

这是我们的数据库连接代码.

需要更改什么?



我必须使用什么数据库连接字符串?
在这种情况下，对于mysql是否需要ODBC.

请为此指导我.

谢谢.

This is our database connection code.

what need to be changed?



what is database connection string i have to use?
Is ODBC is necessary or not for mysql in this case.

Please guied me for this.

Thanks.

推荐答案

，您可以使用可用于连接到MySQL的其他提供程序.请检查以下链接以查看连接字符串和选项:

http://www.connectionstrings.com/mysql [

you can use different providers available for connecting to MySQL. pl check the following link to see the connection strings and options:

http://www.connectionstrings.com/mysql[^]

using MyODBC, your connection string will look like:

Driver ={mySQL}; Server =localhost; Option =16834; Database =myDataBase; 

这篇关于如何在ASP中使用我的SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！