Author |
Topic |
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-30 : 18:12:55
|
How do i do it? do i have to set up an ODBC? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-30 : 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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 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
30421 Posts |
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 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 13and 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 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-31 : 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
131 Posts |
Posted - 2007-07-31 : 10:22:45
|
i don't think i have ausername and password?! |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 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
131 Posts |
Posted - 2007-07-31 : 10:28:24
|
don't i have to setup a system ODBC? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-31 : 10:33:35
|
No, not with OLEDB. E 12°55'05.25"N 56°04'39.16" |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 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
30421 Posts |
Posted - 2007-07-31 : 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=SSPIbut 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
131 Posts |
Posted - 2007-07-31 : 10:40:33
|
MSSQL server is running local can't connect to it?! hmm uid and pwd?? |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 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
131 Posts |
Posted - 2007-07-31 : 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
38200 Posts |
Posted - 2007-07-31 : 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 Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 12:18:01
|
it was running, i just restarted itin Client Protocols: should i have Shared memory = 1TCP/IP = 2NamedPipes = 3VIA = Disabled ? |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 12:19:10
|
and should i restart IIS? |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 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
582 Posts |
Posted - 2007-07-31 : 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
TryProvider=sqloledb;Data Source=.\SQLEXP;uid=john;pwd=j0hn ThanksKarunakaran |
|
|
jarv
Posting Yak Master
131 Posts |
Posted - 2007-07-31 : 13:20:00
|
i've done it! thanks very much for all your help, now i hav eto convert databases?! |
|
|
Next Page
|