اتصال به اكسس 2007

[هواشناس]

بنام خدا
با سلام
داخل asp‌كلاسيك راهي هست كه بشه از ديتابيس اكسس2007 استفاده كرد

حالت عادي كه ايراد Unrecognized database format رو ميده و اجرا نميشه؟

[alireza_s_84]

سلام :
کانکشن استرینگت رو اینجوری بذار :


Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\db.accdb"

موفق باشی

[هواشناس]

بنام خدا
ممنون و متشكر كار كرد

[bloverman]

یه نگاه به این صفحه هم بنداز انواع connection string ها با Access 2007
http://www.connectionstrings.com/access-2007

[هواشناس]

بنام خدا
با تشكر -سايت جالبي بود


Connection strings for Access 2007http://www.connectionstrings.com/Content/Images/Icons/access2007.gif

Providers to use when connecting to Access 2007
» ACE OLEDB 12.0 (http://www.connectionstrings.com/access-2007#p84)
» .NET Framework Data Provider for OLE DB (OleDbConnection) (http://www.connectionstrings.com/access-2007#p20)
ACE OLEDB 12.0

Type: OLE DB Provider
Usage: Provider=Microsoft.ACE.OLEDB.12.0
Manufacturer: Microsoft



Standard security
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;


With database password
This is the connection string to use when you have an Access 2007 database protected with a password using the "Set Database Password" function in Access.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;


DataDirectory functionality
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccess2007file.accdb;Pers ist Security Info=False;


.NET Framework Data Provider for OLE DB

Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library » (http://www.connectionstrings.com/Providers/net-framework-data-provider-for-ole-db)


Bridging to ACE OLEDB 12.0
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;








و صفحه اول سايت



The Connection String Reference

Database Servers
http://www.connectionstrings.com/Content/Images/Icons/sqlserver2008.gifSQL Server 2008 (http://www.connectionstrings.com/sql-server-2008)
http://www.connectionstrings.com/Content/Images/Icons/sqlserver2005.gifSQL Server 2005 (http://www.connectionstrings.com/sql-server-2005)
http://www.connectionstrings.com/Content/Images/Icons/sqlserver.gifSQL Server 2000, 7.0 (http://www.connectionstrings.com/sql-server)
http://www.connectionstrings.com/Content/Images/Icons/sqlserver2005ce.gifSQL Server Compact Edition (http://www.connectionstrings.com/sql-server-2005-ce)
http://www.connectionstrings.com/Content/Images/Icons/oracle.gifOracle (http://www.connectionstrings.com/oracle)
http://www.connectionstrings.com/Content/Images/Icons/db2.gifIBM DB2 (http://www.connectionstrings.com/ibm-db2)
http://www.connectionstrings.com/Content/Images/Icons/mysql.gifMySQL (http://www.connectionstrings.com/mysql)
http://www.connectionstrings.com/Content/Images/Icons/sybaseads.gifSybase Advantage Database Server (http://www.connectionstrings.com/sybase-advantage)
http://www.connectionstrings.com/Content/Images/Icons/sybasease.gifSybase Adaptive Server Enterprise (http://www.connectionstrings.com/sybase-adaptive)
http://www.connectionstrings.com/Content/Images/Icons/informix.gifInformix (http://www.connectionstrings.com/informix)
http://www.connectionstrings.com/Content/Images/Icons/postgre.gifPostgre SQL (http://www.connectionstrings.com/postgre-sql)
http://www.connectionstrings.com/Content/Images/Icons/universe.gifIBM UniVerse (http://www.connectionstrings.com/ibm-universe)
http://www.connectionstrings.com/Content/Images/Icons/unidata.gifIBM UniData (http://www.connectionstrings.com/ibm-unidata)
http://www.connectionstrings.com/Content/Images/Icons/as400.gifAS/400 (IBM iSeries) (http://www.connectionstrings.com/as-400)
http://www.connectionstrings.com/Content/Images/Icons/progress.gifProgress (http://www.connectionstrings.com/progress)

More Database Servers
http://www.connectionstrings.com/Content/Images/Icons/firebird.gifFirebird (http://www.connectionstrings.com/firebird)
http://www.connectionstrings.com/Content/Images/Icons/interbase.gifInterbase (http://www.connectionstrings.com/interbase)
http://www.connectionstrings.com/Content/Images/Icons/paradox.gifParadox (http://www.connectionstrings.com/paradox)
http://www.connectionstrings.com/Content/Images/Icons/ingres.gifIngres (http://www.connectionstrings.com/ingres)
http://www.connectionstrings.com/Content/Images/Icons/mimer.gifMimer SQL (http://www.connectionstrings.com/mimer-sql)
http://www.connectionstrings.com/Content/Images/Icons/lightbase.gifLightbase (http://www.connectionstrings.com/lightbase)
http://www.connectionstrings.com/Content/Images/Icons/pervasive.gifPervasive (http://www.connectionstrings.com/pervasive)
http://www.connectionstrings.com/Content/Images/Icons/sqlbase.gifSQLBase (http://www.connectionstrings.com/sqlbase)
http://www.connectionstrings.com/Content/Images/Icons/cache.gifCaché (http://www.connectionstrings.com/cache)
http://www.connectionstrings.com/Content/Images/Icons/teradata.gifTeradata (http://www.connectionstrings.com/teradata)
http://www.connectionstrings.com/Content/Images/Icons/vistadb.gifVistaDB (http://www.connectionstrings.com/vistadb)
http://www.connectionstrings.com/Content/Images/Icons/dbmaker.gifDBMaker (http://www.connectionstrings.com/dbmaker)
http://www.connectionstrings.com/Content/Images/Icons/netezza.gifNetezza DBMS (http://www.connectionstrings.com/netezza)
http://www.connectionstrings.com/Content/Images/Icons/valentina.gifValentina (http://www.connectionstrings.com/valentina)


Data Files
http://www.connectionstrings.com/Content/Images/Icons/excel2007.gifExcel 2007 (http://www.connectionstrings.com/excel-2007)
http://www.connectionstrings.com/Content/Images/Icons/excel.gifExcel (http://www.connectionstrings.com/excel)
http://www.connectionstrings.com/Content/Images/Icons/text.gifTextfile (http://www.connectionstrings.com/textfile)
http://www.connectionstrings.com/Content/Images/Icons/access2007.gifAccess 2007 (http://www.connectionstrings.com/access-2007)
http://www.connectionstrings.com/Content/Images/Icons/access.gifAccess (http://www.connectionstrings.com/access)
http://www.connectionstrings.com/Content/Images/Icons/visualfoxpro.gifVisual FoxPro / FoxPro 2.x (http://www.connectionstrings.com/visual-foxpro)
http://www.connectionstrings.com/Content/Images/Icons/dbf.gifDBF / FoxPro (http://www.connectionstrings.com/dbf-foxpro)
http://www.connectionstrings.com/Content/Images/Icons/sqlite.gifSQLite (http://www.connectionstrings.com/sqlite)
http://www.connectionstrings.com/Content/Images/Icons/filemaker.gifFilemaker (http://www.connectionstrings.com/filemaker)

Miscellaneous
http://www.connectionstrings.com/Content/Images/Icons/olap.gifOLAP, Analysis Services (http://www.connectionstrings.com/olap-analysis-services)
http://www.connectionstrings.com/Content/Images/Icons/sharepoint.gifSharePoint (http://www.connectionstrings.com/sharepoint)
http://www.connectionstrings.com/Content/Images/Icons/msproject.gifMS Project (http://www.connectionstrings.com/ms-project)
http://www.connectionstrings.com/Content/Images/Icons/acdi.gifActive Directory (http://www.connectionstrings.com/active-directory)
http://www.connectionstrings.com/Content/Images/Icons/exchange.gifExchange (http://www.connectionstrings.com/exchange)
http://www.connectionstrings.com/Content/Images/Icons/quickbase.gifIntuit QuickBase (http://www.connectionstrings.com/quickbase)
http://www.connectionstrings.com/Content/Images/Icons/composite.gifComposite Information Server (http://www.connectionstrings.com/composite-information-server)
http://www.connectionstrings.com/Content/Images/Icons/lotusnotes.gifLotus Notes (http://www.connectionstrings.com/lotus-notes)
http://www.connectionstrings.com/Content/Images/Icons/dsn.gifDSN (http://www.connectionstrings.com/dsn)
http://www.connectionstrings.com/Content/Images/Icons/udl.gifUDL (http://www.connectionstrings.com/udl)
http://www.connectionstrings.com/Content/Images/Icons/msindexserver.gifIndex Server (http://www.connectionstrings.com/index-server)
http://www.connectionstrings.com/Content/Images/Icons/htmltable.gifHTML Table (http://www.connectionstrings.com/html-table)

[pasargadsaeed]

سلام
براي اتصال به اكسس 2007 زدم
dim Access_Connectionstring As String = " Provider = Microsoft.jet.OLEDB.5,0;data source=DbaGavahi.mdb "
خطا داد تو انجمن گشتم
زدم
dim Access_Connectionstring As String = " Provider=Microsoft.ACE.OLEDB.12.0;data source=DbaGavahi.mdb "

خطاي زر داد كمك كنيد ممنون
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

[kashaneh]

دوست عزیز پسوند فایل های اکسس در نسخه های 2007 و 2010 متفاوت از پسوند mdb هست که شما استفاده کرده اید! با کمی دقت مشکلتان برطرف می شود... موفق باشی

[mp_mp353]

دوست من شما برای 2007 و یا 2010 باید از این کانکشن استرینگ استفاده کنید:

OleDbConnection con=new OleDbConnection("Microsoft.ACE.OLEDB.12.0;data source=db.accdb");

با VB
Dim con as New OleDbConnection ("Microsoft.ACE.OLEDB.12.0;data source=db.accdb")