ورود

View Full Version : اتصال به دیتابیس



Asad.Safari
چهارشنبه 05 اسفند 1383, 18:52 عصر
با سلام

ببینید ایراد این از چیه؟

my coonection:


<%
' response.Write(Server.MapPath("/test_main/test.mdb")) if problems connecting to database uncheck this
' and use it to find where the path is being set to and correct as needed.
Set test_connector = Server.CreateObject("ADODB.Connection")
test_connector.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("test.mdb")
'line below is just another way to set up the connection string if the above does not work.
%>




Error:


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xe7c Thread 0xf7c DBC 0x1102fec Jet'.
/testbuilder/include/test_connect.asp, line 6



:موفق:

Asad.Safari
شنبه 08 اسفند 1383, 11:53 صبح
بابا اگه کسی میدونه ما رو یه هلپ کنه!!!

f1..................f1 please
please f1 to me!



Thank :wise1:

esi022
یک شنبه 09 اسفند 1383, 12:07 عصر
sir asad اگه بگم seach کن ناراحت نمیشی
خیلی بحث شده
از oledb استفاده کن نه acess driver

Asad.Safari
یک شنبه 09 اسفند 1383, 14:11 عصر
مشکل حل شد!

از dsn استفاده کردم!

pedramr
دوشنبه 10 اسفند 1383, 09:56 صبح
..
xDb_Conn_Str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("yourbank.mdb") & ";"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open xDb_Conn_Str
sSql = "SELECT * FROM [TableName]"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sSql, conn
..