Web Wiz Forums - SQL Server connection ?

Print Page | Close Window

SQL Server connection ?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26384
Printed Date: 03 April 2026 at 4:53am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server connection ?

Posted By: madmojo
Subject: SQL Server connection ?
Date Posted: 08 October 2008 at 3:55pm

<%
Set baglanti=Server.CreateObject("ADODB.connection" )
baglanti.Open "driver={microsoft access driver (*.mdb)}; DBQ=" &Server.MapPath("name.mdb" )
SQL="select * from tblAuthor ORDER BY Author_ID desc"
Set kayitseti = baglanti.Execute(SQL)
i=1
Do While i<31 and not kayitseti.Eof
%>

<%=kayitseti("Username")%><br>

<% kayitseti.Movenext
i=i+1
Loop
kayitseti.Close
baglanti.Close %>

Access To SQL Server ? How to make ?

-------------
http://www.avsaadasi.ws - Avşa Adası

http://www.avsa.ws - Avşa

Replies:

Posted By: madmojo
Date Posted: 09 October 2008 at 10:01am

To become loose

Acsess

<%
Set Baglantim=Server.CreateObject("Adodb.Connection")
Baglantim.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db.mdb")
%>

Ms Sql

<%
Set Baglantim=Server.CreateObject("Adodb.Connection")
Baglantim.Open "driver={SQL Server};server=xxxx;uid=xxxx;pwd=xxx;database=xxxx"
%>

-------------
http://www.avsaadasi.ws - Avşa Adası

http://www.avsa.ws - Avşa