SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 setting up ith IIS
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

jarv
Posting Yak Master

109 Posts

Posted - 07/30/2007 :  18:12:55  Show Profile  Reply with Quote
How do i do it? do i have to set up an ODBC?

tkizer
Almighty SQL Goddess

USA
35935 Posts

Posted - 07/30/2007 :  18:28:40  Show Profile  Visit tkizer's Homepage  Reply with Quote
You do not need to use ODBC to connect from a web site to SQL Server. In fact, you shouldn't. ODBC is so old. Are you familiar with ADO.NET and connection strings? If not, you need to get a book that deals with this.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  05:41:49  Show Profile  Reply with Quote
can someone please help, I have visual studio and ODBC and they sometimes connect I don't knwo how to test my site with MSSQL server??! please help!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 07/31/2007 :  06:03:56  Show Profile  Visit SwePeso's Homepage  Reply with Quote
www.connectionstrings.com

Or this which I find better
http://www.carlprothman.net/Default.aspx?tabid=81


E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 07/31/2007 06:05:16
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  10:08:50  Show Profile  Reply with Quote
thanks, i have a SQL connection string:

Data Source=localhost\SQLEXPRESS;Initial Catalog=john


and the error i get is: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/pubspace/includes/functionlib.asp, line 13

and when i use my other connection:

driver={SQL Server};server=mute\SQLEXPRESS;uid=John;pwd=j0hn;database=john


I get the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
/pubspace/includes/functionlib.asp, line 13


Edited by - jarv on 07/31/2007 10:13:37
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 07/31/2007 :  10:15:33  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Provider=sqloledb;Data Source=localhost\SQLEXPRESS;Initial Catalog=john;User Id=<myUsername>;Password=<myPassword>



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  10:22:45  Show Profile  Reply with Quote
i don't think i have ausername and password?!
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  10:24:52  Show Profile  Reply with Quote
i tried:

Provider=sqloledb;Data Source=localhost\SQLEXPRESS;Initial Catalog=john;User Id=John;


and now i get:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/pubspace/includes/functionlib.asp, line 13
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  10:28:24  Show Profile  Reply with Quote
don't i have to setup a system ODBC?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 07/31/2007 :  10:33:35  Show Profile  Visit SwePeso's Homepage  Reply with Quote
No, not with OLEDB.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  10:36:59  Show Profile  Reply with Quote
where do i setup my username an dpassword? i can't even login to my database now via windows login
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 07/31/2007 :  10:40:15  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You need a SQL server account.

Or (if you have read the links I posted earlier)
Provider=sqloledbData Source=localhost\sqlexpress;Initial Catalog=john;Integrated Security=SSPI

but then you have to set up IIS to incorporate integrated security.




E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  10:40:33  Show Profile  Reply with Quote
MSSQL server is running local can't connect to it?! hmm uid and pwd??
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  10:46:40  Show Profile  Reply with Quote
i just added Integrated Security=SSPI on teh end of my connection string, still says: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I have IIS running!how would i setup a SQL server account if i needed to?
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  12:00:08  Show Profile  Reply with Quote
i have just switched back to my ACCESS DATABASE and i cannot login anymore I am using the correct UserName and Password taht are in my database!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35935 Posts

Posted - 07/31/2007 :  12:09:01  Show Profile  Visit tkizer's Homepage  Reply with Quote
Since you are getting SQL Server does not exist or access denied error, you've got some configuration issue as that's a message that indicates network issues, the service is stopped, or various other connection-related problems. Check to make sure that the SQL Server service is running. Based upon the error, you are running SQL Server 2000, so the service will be named MSSQLSERVER if you installed the default instance or MSSQL$InstanceName if you installed a named instance. Make sure it says Started and Automatic.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  12:18:01  Show Profile  Reply with Quote
it was running, i just restarted it

in Client Protocols: should i have
Shared memory = 1
TCP/IP = 2
NamedPipes = 3
VIA = Disabled ?
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  12:19:10  Show Profile  Reply with Quote
and should i restart IIS?
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  12:49:12  Show Profile  Reply with Quote
ok I reinstalled the SQL EXPRESS MANAGEMENT and now i can connect to the console and create a database!

I have teh connection string:
Provider=sqloledb;Data Source=localhost\SQLEXP;uid=john;pwd=j0hn


and get the error: Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/pubspace/includes/functionlib.asp, line 13

Go to Top of Page

karuna
Aged Yak Warrior

581 Posts

Posted - 07/31/2007 :  13:11:30  Show Profile  Send karuna a Yahoo! Message  Reply with Quote
quote:
Originally posted by jarv

I have teh connection string:
Provider=sqloledb;Data Source=localhost\SQLEXP;uid=john;pwd=j0hn


and get the error: Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/pubspace/includes/functionlib.asp, line 13



Try
Provider=sqloledb;Data Source=.\SQLEXP;uid=john;pwd=j0hn


Thanks
Karunakaran
Go to Top of Page

jarv
Posting Yak Master

109 Posts

Posted - 07/31/2007 :  13:20:00  Show Profile  Reply with Quote
i've done it! thanks very much for all your help, now i hav eto convert databases?!
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000