| Author |
 Topic  |
|
jarv
Posting Yak Master
107 Posts |
 Posted - 07/30/2007 : 18:12:55
|
| How do i do it? do i have to set up an ODBC? |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 07/30/2007 : 18:28:40
|
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/ |
 |
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 05:41:49
|
| 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! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 10:08:50
|
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 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 07/31/2007 : 10:15:33
|
Provider=sqloledb;Data Source=localhost\SQLEXPRESS;Initial Catalog=john;User Id=<myUsername>;Password=<myPassword>
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 10:22:45
|
| i don't think i have ausername and password?! |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 10:24:52
|
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
|
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 10:28:24
|
| don't i have to setup a system ODBC? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 07/31/2007 : 10:33:35
|
No, not with OLEDB.
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 10:36:59
|
| where do i setup my username an dpassword? i can't even login to my database now via windows login |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 07/31/2007 : 10:40:15
|
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" |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 10:40:33
|
| MSSQL server is running local can't connect to it?! hmm uid and pwd?? |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 10:46:40
|
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? |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 12:00:08
|
| 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! |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 07/31/2007 : 12:09:01
|
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/ |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 12:18:01
|
it was running, i just restarted it
in Client Protocols: should i have
Shared memory = 1
TCP/IP = 2
NamedPipes = 3
VIA = Disabled ? |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 12:19:10
|
| and should i restart IIS? |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 12:49:12
|
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
|
|
|
|
karuna
Aged Yak Warrior
581 Posts |
Posted - 07/31/2007 : 13:11:30
|
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 |
|
|
|
jarv
Posting Yak Master
107 Posts |
Posted - 07/31/2007 : 13:20:00
|
| i've done it! thanks very much for all your help, now i hav eto convert databases?! |
|
|
|
Topic |
|
setting up ith IIS
