Sql 2005 Connectivity
Mar 15, 2007
Hello,
I am attempting to connect directly to an instance of sql 2005 from the VS Pocket PC emulator running Mobile 5.0. I have installed AtiveSync 4.0 and successfully cradled the device to establish connectivity to the internet. I have also successfully browsed to the IP of the server that i is running sql 2005. I am able to populate a datagrid via a stored procedure resultset which accepts no parameters. When attempting to pass variables into a stored procedure a SqlException was thrown stating that the procedure excpects these parameters. I have successfully built the app and ran the executable from my local machine and successfully passed these parameters to the procedures. I dont know what the problem could be. Any help would be of great assistance, this problem has halted productivity.
/**********Connection string
Persist Security Info=False;Integrated Security=False;Server=192.168.0.200,1234;Initial Catalog=BatchScan;User ID=BatchScanServerUser;Password=B4uBaTch*uSc@n
TCP/IP protocols are successfully configured on sql 2005 with dynamic ports disabled and all ips using port 1234
Thank you in advance.
View 4 Replies
ADVERTISEMENT
Dec 5, 2007
Hello
I'm having a problem with the server connection and my C# code. The code executes alright but no data is entered into the database behind it. I'm pasting the connection code over here as well. The sql commands are used in the code. I think I used the sql server mobile edition which is installed along with visual studio.net 2005. Anyone know what's wrong, and can help me out? Thanks in advance.public static void storeInDb(string trackName, string artist, string albumTitle, string year, string path, uint[] fp)
{
string connStr="Data Source=.\SQLEXPRESS;AttachDbFilename='"+path+"\Data\ACI.mdf';Integrated Security=True;User Instance=True";SqlConnection conn = new SqlConnection(connStr);
conn.Open();string sql = "INSERT INTO Clip(Song, Artist, Album, Year) VALUES('" + trackName;sql = sql + "','" + artist + "','" + albumTitle + "','" + year + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql="SELECT max(ClipID) FROM Clip";
cmd = new SqlCommand(sql, conn);int id = Int32.Parse(cmd.ExecuteScalar().ToString());for (int i = 0; i < fp.Length; i++)
{
sql="INSERT INTO Hash VALUES ("+id+","+(i+1)+","+(int)fp[i]+")";cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
conn.Close();
}
View 1 Replies
View Related
Apr 29, 2008
I have an application which is under development in VS 2005 but the database is in SQL Server 2000. We are facing some strange problem with the connectivity between VS 2005 - SQL Server 2000.
I have tried all the possible ways or solutions i found when searching in google but unable to find a solution.This had become a major challenge for us now to identifiy the root cause of the problem
Error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Please suggest.
Thanks,
Hemant
View 2 Replies
View Related
Feb 13, 2007
I am an application developer with an existing system developer in SQL Server 2005 Express and Visual Studio 2005.
I have installed the system I wrote at a physician's office, and it is working fine on a local computer utilizing XP operating system.
There is a requirement to allow other terminals to connect to this XP terminal to execute the application, so I am exploring possibilities for connecting remotely from the other computers in the physician's office.
I am running Virtual Machine for my client computer.
I modified SQL Server 2005 on my main computer. I enabled both TCP/IP and Named pipes in the SQL Server Surface Area Configuration utility. I also set SQL Server Browser to start automatically.
The local application is successfully connecting with the following connectionstring: Data Source=localhostsqlexpress;Initial Catalog=MedicalDB;Persist Security Info=True;User ID=sa;Password=thepassword
I realize that I would have to substitute the server name for localhost before I could connect from the application, but I wanted to first "connect" to the database from my second machine successfully before I began trying to connect from my application. I can Ping the pc that is running sql server express, I am able to "telnet" my pc that is running SQL Server Express.
Both my computers are in the same workgroup and there is no domain.
There are no aliases in my configuration, and there is no encryption on the server.
Ther error message I recieve is:
Cannot connect to DDD
An error has occurred while attempting connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings SQL Server does not allow remote connections. (providor: Named Pipes Providor, Error: 40 Could not open a conneciton to Sql Server) (Microsofi SQL Server, Error: 1326)
View 1 Replies
View Related
Aug 14, 2007
I have an application which uses ADO to connect to Database. DSN name is specified in the connection string used by ADO as part of the application logic.
This application is working perfectly fine when it is run from a Windows 2003 Enterprise Edition (EE) Server and successfully connects to a remote MSSQL 2005 EE Database installed in another Windows 2003 EE Server.
This application is working perfectly fine also when it is run from a Windows 2003 Standard Edition (SE) Server and successfully connects to the local MSSQL 2005 EE Database installed in the same Server.
But this application FAILS to work when it is run from the Windows 2003 SE Server and connecting to the remote MSSQL 2005 EE Database installed in Windows 2003 EE Server. Error returned to the Application has this description: "Provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"
Can somebody give me more insights into the problem and help me in overcoming the issues in the last scenario?
Thanks.
View 1 Replies
View Related
Apr 30, 2007
We have an OLD vbscript process that is running on a Windows 2000 box. The box has Sql Server 7.0 on it (not sure if relevant). The process used to hit a Sql Server 2000 database, but that database was recently migrated to 2005 (on different server). Now the connection string obviously no longer works, and we can't even add a DSN to 2005 (does not recognize new server). The machine pings the new SQL server without any problem, but cannot connect for data access.
I assume there should be some driver that I can install to fix this, but have yet to find one on the web. Does anyone have a recommended download to remedy this?
Thanks in advance.
View 1 Replies
View Related
Mar 29, 2006
Hi all
I am trying to connect to an AS400 to download data to a 64bit sql server 2005 server. I am able to do this easily by migrating existing sql2000 DTS packages but how do i do this is in an SSIS project creating the process from scratch? and how do i incorporate activex transforms like you could in DTS2000 into the trasnform with copy columns?
Please help i am slowly turning grey trying to get this to work.
thanks
Chris
View 1 Replies
View Related
Aug 16, 2007
hi all. i m looking for help in Java - SQL Server 2000 Connectivity.i worked on Java- Oracle & Java - MS Access format.now i m looking to work on Java - SQL Server 2000. I m using JBuilder 2005. what sort of configuration needed in JBuilder or SQL Server 2000, like adding JAR files and all other stuffs? or what to do? lemme know quickly. thanx in advance.
View 5 Replies
View Related
Oct 1, 2007
I read your blogs regularly on SQL-Server Express 2005 which I have been actively deploying with my software product for about a year now. I have migrated most of my products to SQL-Server from Microsoft Access. I have found SQL-Express very stable and have had no significant problems. My products are mainly accounting based such as payroll systems, hotel management systems, school academic results management systems.
My favourite front ends tools are Visual Basic 6.0, and Microsoft Access. Typically, with MS Access I link to tables via the SQL-Server ODBC driver and all the client front ends share a common security file, an access work group file. I have been using this approach for up to a decade with no problems.
Currently I am deploying a hotel management system and payroll system in a hotel about to be opened. Against our advice, they purchased computer systems running Windows Vista Business instead of XP which we are sure our software suites, the wireless network and other software solutions such as CCTV work perfectly. This has caused a lot of problems.
On my side I had the extra task of dealing with Office 2007.
2 key problems arose.
After setting up a simple Ethernet network connecting the Vista computers I could not connect to SQL-Server Express in Windows Authentication mode via SQL Native Client and SQL Server ODBC drivers from another computer on the network (i could only connect locally); I could only connect to it from another machine using SQL Authentication mode, which is not my preference.
Secondly, I could not share the security file with more than one client of the network. The file seems to be locked exclusively by one client that first grabs the file, hence you cannot log on to software. This defeats clientserver idea. HEEEEELP.
A way round this was to have at least one computer on the network running XP (or any windows not Vista) and share the security file from it. I wish to know the reason for this behaviour on Vista.
As to the first problem of not being able to connect of SQL-Server Express 2005 via Windows Authentication mode from another machine on the network, I found the cause: The PASSWORD PROTECTED SHARING setting on Sharing and Discovery option for networking on Windows Vista.
When this setting is turn ON you cannot connect to the SQL-Server engine. The error Login failed for user ": Not associated with a trusted SQL Server connection is given. When I turn off this setting, I immediately could log on. I have validated this on several setups and this seems to the consistent. PLEASE SHARED THIS With others.
Thanks Dr Folami
View 2 Replies
View Related
Oct 5, 2007
We recently moved from SQL 2k to SQL 2K5 and existing application stopped working with following error message.
[DBNETLIN][ConenctionOpen (SECCreateCredentials()).]SSL Security error.
The code used to make connection is as below.
Option Explicit
Const NewConnStr = "Provider=SQLOLEDB;Persistant Security=False;User ID=%DBUser;Password=%DBPassword;Initial Catalog=%DBName;Data Source=%DBServer,%DBPort;Network Library=dbmssocn"
Dim oConn
Dim sConnStr
Dim sServer
sServer = "SQLSERV01"
Set oConn = CreateObject("ADODB.Connection")
On Error Resume next
sConnStr = Replace(Replace(Replace(Replace(Replace(NewConnStr, "%DBUser", "test1"), "%DBPassword", "test1"), "%DBName", "model"), "%DBServer", sServer), "%DBPort", "1433")
Call oConn.Open(sConnStr)
This script runs under stripped-down Windows enviornment (Windows PE) with very basic components (i.e. no GUI, only command-line interface). I am trying to find out if there is any client side setting to bypass "self-generated SSL ceritificate" on server. I have tried all things on server side from disabling shared memory protocol, setting "Force Encryption" property etc. Could somebody help me with name of this property?
Also, is it possible to not use self-generate certificate on server. We don't want any kind of encryption for SQL connections.
Thanks..
View 7 Replies
View Related
May 5, 2007
Hi,
I have installed one default and one named instance of SQL Server 2005 Dev. Editition SP2 on my server.
The Named service is configured to use Shared, NamedPipe and TCP (Port 4333).
There is no firewall on the machine. But still i am not able to connect to it form remote computer.
can any one help me with these. this is urgent.
Thanks.
KV
View 1 Replies
View Related
Jul 25, 2007
Hi,
Can anyboday tell me how to connect the clien and server in SQL Server 2005.
Thanks & Regards
View 3 Replies
View Related
Apr 24, 2008
how should i change my comnnetion string when i host the website in the server. i am having errors? but in local host its working fine?
View 3 Replies
View Related
Sep 3, 2001
Hi,
I am responsible for an application that uses the Borland Database Engine to connect clients to the database server - it's called SalesLogix. I am in the process of upgrading the databases in the working environment to SQL 7 from SQL 6.5 and on the whole it has been (relatively) successful, however I have a majorly inconvenient issue with a few client machines. Occasionally, after upgrading the SQL client and having upgraded the database server I cannot make a connection any longer and instead when I try through the BDE I am presented with the message 'General SQL Error' and the BDE error code for a general SQL error, and nothing more. It has only happened on a couple of machines, but with no apparent pattern. The clients can still connect to SQL 6.5 databases as long as the SQL 6.5 client utilities are still installed so I don't know what to think. Any ideas?
Cheers,
Anthony
View 1 Replies
View Related
Sep 8, 2003
Please Help.
I can ping my sql server using the IP address but not using the host name.
I run win XP desktop and SQL 2k sp 3 on WIN 2k SP3 two nodes active/passive cluster configuration.
Urgent
View 1 Replies
View Related
Sep 7, 1999
i have a server in US and the other at india iam trying to connect both the sql servers but iam unable to do it. Please tell me how to connect them
regards
aafreen
View 1 Replies
View Related
Jul 13, 2006
Hello everybody.
I am connecting my computer to the internet and when i see the ip address of my computer i try:
telnet ipaddress 1433 but it says 'connection failed'.
this happens even when i try to access my sql server from another computer through the internet.
I have installed service pack 4,configured the server connectivity by adding the tcp/ip protocol and checked the port:it is 1433.
Also checked the firewalls ,but no results.
please help
View 4 Replies
View Related
Nov 22, 2007
We are trying to setup a role based security access within our client software so that users have read only access to the database. Right now we are not able to connect to the database. This is a blocking issue for us on the project right now
Please let us know how to proceed now ?
Thanks in advance
Kishore
View 4 Replies
View Related
Jul 20, 2005
Is it possible to approach a MS SQL Server using TCP/IP? I have lookedeverywhere but have not found any documentation about the protocol toconnect to MS SQL Server.I wish to connect to MS SQL Server directly through TCP/IP, without using MSlibraries (since i am not doing this on a windows system).Thanks in advance,Eddie Gieze
View 2 Replies
View Related
May 31, 2006
I am building a C# Windows app. I have a form and have also create a db. I tested the db connectivity in Server Explorer and the test came back successfully. According to my manual, I just need to drag the db item from the server explorer to my form designer to creation the connection. When I do this nothing happens... what am I doing wrong?
If I do the same thing in VS2003 the sqlConnection1 shows up, how do I accomplish the same thing with 2005?
View 1 Replies
View Related
Nov 6, 2006
hi friends,
i am developing a dictionary for pocket device
i am using sql ce database .
i have included and copied that file in the project but every time exception occurs saying check the directory . file can not be found.....
may be this a little one but help me......
its urgent..........
View 5 Replies
View Related
Jan 21, 2008
hi,
how to connect the database for first time
iam working for a website in that i have a form. how to connect the form to the database.
throw enterprice managment
thanks
View 1 Replies
View Related
Dec 27, 2004
Hi:
I m in new in ASP.net and can't connect sql server db with ASP.net.I write exact code.but it give error in connection string and server error some time.I found that error is in web.config file.can any one have running project of asp.net with sqlserver db..
if any one have then mail the project at this mail address..
ray_boby@hotmail.com
View 1 Replies
View Related
Jul 26, 2005
Hi im new to ASP.NET.. can anyopne pelase tell me how to make database connectivity with sql server 2000.i need to insert data into sqlserver2000 database from an ASP.NET Web form. please provide me with a asample code.thank you
View 1 Replies
View Related
Dec 13, 2005
I am using webforms for ASP .NET which has code in C#. My database is running on SQL Server 7. Whats the best way to connect to database. I have tried ODBC connection through myConnection=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);but it gives me an error that can not connect to the SQL Server 2005 or it does not allow remote connections though it is running SQL Server 7 and not SQL Server 2005. Thanks in advance.
View 1 Replies
View Related
Jan 11, 2006
I am using SQL SERVER 2000 and asp.net How shoul i connect using OLEDB provider?.
In connection string, i am giving Provider=SQLOLEDB.1,datasource .
It's giving error in conn.open() that login failed for database. i am also poroving username and password in connection string, so i want code for the same.
awaiting for reply...
View 2 Replies
View Related
Apr 2, 2001
Hi,
I have a sql server that I cannot connect to in Enterprise Manager. I can connect no problem with Query Analyzer, but EM always gives me a "timeout expired" error. I am using tcp/ip, and my network card is configured exactly the same as another server that i can connect to fine. Any ideas? I really need to figure this out. this has nothing to do with timeout intervals, or anything like that, as it's all default settings, same as the other database...thanks.
View 1 Replies
View Related
Apr 2, 2001
Here's my post from a few minutes ago, thanks for the answer but that's not a fix, and trying to reconnect doesn't help. it never connects. I'm posting again, as otherwise people wouldn't read the older thread once it's replied too
I have a sql server that I cannot connect to in Enterprise Manager. I can connect no problem with Query Analyzer, but EM always gives me a "timeout expired" error. I am using tcp/ip, and my network card is configured exactly the same as another server that i can connect to fine. Any ideas? I really need to figure this out. this has nothing to do with timeout intervals, or anything like that, as it's all default settings, same as the other database...thanks.
View 1 Replies
View Related
Jul 2, 2001
I have a few ASPs that were written to pull from an Access 97 database. Now that we have converted the data over to a SQL database, the ASPs have been changed accordingly. My problem is that I have two ASPs which use an Inner Join between three tables where the main field (in this case it is called "INDEX") is what the pull is based on. When I try to run the ASPs I recieve this error .
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INDEX'.
The line that it identifies is where the connection is actually opened.
This is only occuring on the ASPs that use the column INDEX and an inner join. The straight style number pulls (which have the same connection string)
are working fine. Any ideas?
View 1 Replies
View Related
Feb 17, 2000
hello , i have a small problem , an associate want to connect to a micrsoft sql server under nt from a pc with only dos! can such a thing be done?
View 1 Replies
View Related
Mar 17, 1999
What do I need to do to enable a client PC to See a SQL server database? I keep getting ODBC timeout errors.
Help
View 2 Replies
View Related
Jan 5, 2003
Hi all,
I'm currently trying to connect my ASP page with an SQL server 2000 DB. I already know, how to connect with Access, through the the cobnnection object...
examlpe:
---------------------------
Dim objConn
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.ConnectionString = "DSN=cb_access_db"
'objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=F:dbCB_database.mdb"
objConn.Open
---------------------------
Now, i have SQL 2000 running on my local syste, and i'v ecreated a DSN..
How would i connec to it???
any input, or exampkles would help.Thanks!
DAve
View 2 Replies
View Related
Aug 6, 2003
Hi,
We have a client machine that has Win98. From that they are running VB app that connects SQL 2000 Server.
Here is the code in the registry under
HKEY_CURRENT_USERSOFTWAREVB and VBA Program SettingsAppname folder
for running that application.
Provider=SQLOLEDB.1;Initial Catalog=dbname;Data Source=xxxx;Integrated Security=SSPI
From ODBC the system can connect to the database.
But from SQLOLEDB
It comes back with error:
-2147467259
Unable to connect.
Any ideas?
Thanks,
Anu
View 4 Replies
View Related
