This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 请教一个ASP.NET与MS ACCESS问题我得到一个error message something like "couldn't find file in c:\windows\system32\inetsrv\mydb.mdb.我用ODBC,过去一直正常,最近有人把内部网络修改了一下,又装了OFFICE2007,我的系统是windows server 2003.不知咂搞的,请教高手指点迷津,小弟有礼了.
-od2nw(cool);
2008-2-24
{242}
(#4284714@0)
-
Better to use OleDb. The connection string is like Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path+filename;User Id=admin;Password=;
-deep_blue(BLUE);
2008-2-25
(#4286394@0)
-
是一个不错的WORKAROUND.试一哈.多谢
-od2nw(cool);
2008-2-25
(#4286464@0)
-
In .NET, ODBC is not good solution.Unless in some scenarios, such as you need to connect to special data source and you only have ODBC driver. Otherwise, it’s better to use other providers. OlaDb provider has better performance and more flexible.
-deep_blue(BLUE);
2008-2-25
{212}
(#4286543@0)
-
windowssystem32.... what a heck appropriate place to place a db....
-win(秋天的菠菜);
2008-2-25
(#4286445@0)
-
多谢各位.问题解决了.在SQL STATEMENT 里用了myanotherdb.dbo.table这种用法适用于SQL SERVER.SWITCH BACK TO ACCESS就出现了上述问题.
-od2nw(cool);
2008-2-26
{117}
(#4290849@0)
-
Why use Access rather than SQL-server (Express) as your database?
-deep_blue(BLUE);
2008-2-27
(#4292467@0)
-
Originally we use access, now for some reason we need sqlserver. In web.config, we have a switch. Thanks for asking.
-od2nw(cool);
2008-2-27
(#4292875@0)
-
I see. Do you mean switch to different ODBC DSN? If so…Although you can use ODBC or OleDb, SqlClient is best choice for SQL server. It uses native access to SQL server; hence there is even much better performance than OleDb, of course much much better than ODBC.
-deep_blue(BLUE);
2008-2-27
{207}
(#4293083@0)
-
thank you for your comments.for sql server we use sqlclient for connection only, for access we kept using odbc, there is a lot of work transfer odbc to any better solutions page by page. so for we don't find any serious problem. we just add a connectionstring switch between sqlserver and access in web.config, and some small changes in sql statements for linked tables in access and different databases in sqlserver. that't all.
-od2nw(cool);
2008-2-28
{403}
(#4295714@0)