Snitz Forums 2000 - SQL server with ASP ??

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

SQL server with ASP ??

New Topic

Topic Locked

Printer Friendly

Author

Topic

quince
Junior Member

Canada
103 Posts

Posted - 07 January 2005 : 18:21:04

hello guys.... i have a question and i want to ask you about it ...
could i connect the asp with SQL server .... ?

if yes what are the changes for those:

Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open("DRIVER={Microsoft Access Driver (*.mdb)};"DBQ=" & Server.MapPath("project1.mdb"))

and is there any changes for the asp code ?

and if no thanks a lot for you to reply on me..

thanks guys i know that i am asking so many question over here... but i am doing my senior project so i will graduate ....

The Impact
Junior Member

Australia
398 Posts

Posted - 07 January 2005 : 19:07:08

You need to change the connection line to

cnn.Open("Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;")

There will quite possibly be changes to your SQL as well. The Differences Between Microsoft SQL Server and Microsoft Access Query Syntax are listed in that article from Microsoft.

laser
Advanced Member

Australia
3859 Posts

Posted - 07 January 2005 : 19:07:13

There are some great examples in the Snitz code - config.asp

quince
Junior Member

Canada
103 Posts

Posted - 10 January 2005 : 17:00:34

okay thanks guys for replying on me ..
i got what i need

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.28 seconds.