如何在asp中使用我的sql(How to use my sql in asp)

   IT问题网   2021-01-21 00:00:00

问 题

嗨先生/女士,



在我们的asp应用中,我们使用mdb(微软访问)作为数据库。



现在我们想到我的sql作为后端。



lt;%
set con = server.createobject(" adodb.connection"
con.open " driver = {microsoft access driver(* .mdb)}; dbq ="amp; server.mappath(" ../ fooddubai.mdb")amp; " ; pwd = expolink"

%gt;






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



需要更改什么?







我必须使用什么是数据库连接字符串?

在这种情况下,对于mysql是否有必要使用odbc。



请关注我为此。



谢谢。

解决方案

您可以使用不同的提供程序连接到mysql。请检查以下链接以查看连接字符串和选项:



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



使用myodbc,您的连接字符串将如下所示:

 driver = {mysql}; server = localhost;选项= 16834; database = mydatabase; 

标签:何在使用



分享:

  • 微信
  • QQ好友
  • QQ空间
  • 新浪微博


热门推荐

如何制作wpf鼠标事件?(How can made wpf mouse event )

problem how can made wpf mouse event see more: c# please ...

如何在包含三个用于用户输入的asp.net服务器控件的表中动态添加行(how to add rows dynamically in the table containing three asp.net server controls for user input)

problem hi a table having 5 rows and 3 columns, each ro ...

如何将string []数组值分配给cookie(How to assign a string[] array values to a cookie)

problem i have a string array and it is filling by databa ...

在基本MSI项目中从InstallShield显示消息“安装程序需要64位处理器”(Show message “Setup requires a 64Bit processor” from InstallShield in basic MSI project)

problem i am using installshield 11 and creat ...

c ++编程语言(c++ programming language)

problem hello all, i am looking to design c++ code for is ...

MySql DB(如何在部署时添加DB)(MySql DB(how to add DB at the time of deployment))

problem hello, i am going to deploy(c#.net with mysql 5.0 ...

如何为15个链接按钮单击事件实现相同的代码(How to implement same code for 15 linkbutton click events)

problem hi, i want to bind a tree in horizon ...

在数据网格中更改字段的名称(change field's name in a datagrid)

problem how can i change name of the each header columns ...

使用多个mdi表单(working with mutiple mdi forms)

problem hello i have a c sharp application, which contai ...

更改Html对象Zindex(Change Html Object Zindex)

problem hi all i have an object in my page. i ...

GDI +中发生一般错误的问题。(problem with A generic error occurred in GDI+.)

problem hi all when i want save image from fileupload fa ...

编写非肥皂网服务(Writing Non soap web service)

problem please let me know how to write a non ...

在asp.net和c#中动态创建按钮(Dynamically created button in asp.net and c#)

problem hi, i am creating online examination ...

文件上传问题,找不到文件(File Upload problem, file not found)

problem hi, from my asp.net form, i am trying ...

请在下拉列表中解决错误(please solve error in dropdown list)

problem please solve the error i have 2 dropdownlist. in ...

更改属性上的ReadOnly属性不起作用(Change ReadOnly attribute on property doesn't work)

problem i''ve tried to change a readonly attr ...

我如何分割我的表格(how do i split my form)

problem ok i want to split my form in half so on the left ...

将templatefield动态添加到gridview(adding templatefield dynamically to gridview)

problem give the tutorial to add template field, controls ...

在c#的帮助下导出pdf文件(Export pdf File with the help of c#)

problem how to convert more then one pdf file ...

计算中间日期并在gridview中显示它(calculate inbetween date and show it in gridview)

problem hello friends, by using date time pi ...