Hi
I am new to .net and sql server....i have just installed VS 2005 and sql server7.0...
I am doing my coding in vb.net......so i wanted to know the connection of the datagrid to the db in my sql server 7.0.
Can some one pls help me with this urgently.
Hi
I've been trying to get DotNetNuke to connect to a SQLServer Express database but no luck. I've had no luck with info from their forums...
The connection string I'm supposed to use is:
<add
name="SiteSqlServer"
connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
I just can't get it to connect to the database. Says something that remote connections are not allowed. I've done the Area thing and allowed all connection including remote connections.
Can't we use the standard string like:
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
providerName="System.Data.SqlClient" />
...to connect? I'd like to setup a user and give the username and password in the connection string - real easy and non-complicated...
Any ideas or help?
Andre
Hi!
I have developed a database in MS SQL Server 2005 Express, to which I would require only bulkadmin server role from an external java application, because I only need to update rows, insert values or use select queries in the database.
The problem is that, using either the Microsoft JDBC Driver 1.1 or the Java JDBC ODBC Driver and the Windows XP Data Base (ODBC) configurations, I need a user with sysadmin server role inside Sql Server, otherwise JDBC won't connect to the database using the selected user. Even if I leave the sql login with setupadmin or any server role lower than sysadmin, the connection is refused.
Is there no way to connect using JDBC to MS Sql Server 2005 other than granting the connected user sysadmin rights? My code looks as follows:
Code Snippet
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://FIREBLADE\SQLEXPRESS";
String user = "username";
String password = "password$$";
Connection conn;
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
if (conn != null)
System.out.println("SQL Server Connection established ...");
I have heard that Java JDBC connections to Microsoft require high-level access.
Any informed answer is more than welcome. Thanks for reading my post!
I have a child package where the ConnectionString property of a Connection Manager is set by a Parent Package Variable Configuration. I set up a script task that brings up a message box with the value of the ConnectionString property right before the dataflow task.
MessageBox.Show(Dts.Connections["CPU_*"].ConnectionString.ToString());When I run the parent package, the message box shows that the connection string is changing with every iteration, but in the dataflow it always draws the data from the same source.
The connection manager is an ADO.Net type, RetainSameConnection is set to False, and I've been researching this for days.
(Update 2/23/2015): To make this stranger, when I look at the diagnostic logs, they tell me that when the new connections are being opened they are using the new connection strings.
[Microsoft follow-up]
I submitted a posting to connect here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=287213
Here is what I wrote:
A number of tasks output data to variables or text files. e.g. WMI Data Reader Task, Execute SQL Task, Web Service Task.
Consuming that output in a data-flow isn't particularly easy. You either need a Flat File source adapter (which requires an othrewise superfluous connection manager) or write come code in a script component to parse the recordset. There is simply no easy way to push data from these sources into the dataflow.
Thw built-in mechanism for passing data between different tasks is raw files. Currently they can only be used by the dataflow but I see no reason why they couldn't be used by other tasks as well. It makes complete sense to me for a WMI Datareader Task to push some data into a raw file and then we chew that data up in a dataflow.
The following response came back
Our current architecture actually doesn't have the buffer system as in Data Flow, when you are in the Control Flow. What you are asking would require us to build a similar buffer system in the Control Flow, which is a fundemantal architectural change. We'll not be able to take this, sorry.
I'm afraid I don't understand that response. Obviously I know that buffers are only in the data-flow - but I don't see why that's relevant. Raw files are just files on the file system, same as any other. OK, their format is very proprietary but its you guys that built the format. Essentially all I'm asking you to do is output the data in raw file format as opposed to flat file format. There's no notion of buffers in a raw file because its just a lump of data. Or is there? If not, I'm afraid I don't understand your answer.
Please could you clarify the answer?
-Jamie
Hi
I have a string which contains the year and month, now i wanted to know what is the starting day of that month in that particular year.
For Ex: string STR = "Jan2006" then by any chance i can know the starting day of this month as whether it is Sunday etc. I need the string "sunday" as output. Also, I need to know how many number of days that particular month contains. Any function or stored procedure which will give out these two outputs will be much appreciated.
Thanks!
Santhosh
Hi There
I am using SS2005 Enterprise Edition, proper release version not a ctp or anything
When i try navigate to my packages in MSDB i get the following error.
Encrypt not supprted in Sql Server.
I have done some checking and it is a known fact the sql server will enxrypt packages, and that the resolution is to use certificates.
Also some indications from links i have found that this is just a ctp or beta version issue.
Can someone please tell me if there is anyway around this besides certificates.
One is to use file system for packages, but how can i at least delete the packages deployed to sql server so far ???
nxPlease help , Thax
So,
I have a Server running Windows 2003, windows firewall offline, with Sql Server 2005 and SQL Server 2005 Mobile Edition. This server is running behind a firewall.
When I try to PULL data with RDA from the internal network, all work's great! But when I try it from the exterior, internet, I always receive this message: Failure to open SQL Server with given connect string. [ connect string = Provider=sqloledb;Data Source=<MY INTERNET IP>,11433;Network Library=DBMSSOCN;Initial Catalog=testdb;User Id=sqlceuser;Password=test; ]
On my firewall, I unblocked port 80 and 11433 and mapped them to my internal server IP with port 80 and 1433. I use port 11433 on internet because my ISP block the 1433.
How can I solve this problem?
hello,
im working with VB 2005 and i have this error when triyng to connecting to the server database from my pocket pc application.
"Failure to open SQL Server with given connect string."
this is part of my code:
rdaOleDbConnectString = "Provider=sqloledb;Data Source=localhost;Persist Security Info=SSPI;User ID=id;Password=password;Initial Catalog=praia"
rdaUrl = "http://server/SqlMobile/sqlcesa30.dll"
localConnection = "Data Source=My DocumentsPraiaDB6.sdf"
If File.Exists("My DocumentsPraiaDB6.sdf") Then
File.Delete("My DocumentsPraiaDB6.sdf")
End If
Dim engine As New SqlCeEngine
engine.LocalConnectionString = localConnection
engine.CreateDatabase()
engine.Dispose()
MsgBox("DB Mobil empty created!")
'Init RDA Object
Dim rda As SqlCeRemoteDataAccess = Nothing
rda = New SqlCeRemoteDataAccess(rdaUrl, localConnection)
rda.InternetUrl = rdaUrl
rda.LocalConnectionString = localConnection
rda.Pull("Reserva", "select * from Reserva", rdaOleDbConnectString, RdaTrackOption.TrackingOn)
rda.Dispose()
the problem is in rda.Pull(...)
it can not connect to rdaOleDbConnectString
please help me
Thanks!
João
I have a server with 3 SQL Server named instances on it - servername, servername/TST and servername/GOLDSTD. I have several databases on the default instance (servername) but users cannot access the databases unless they are given system admin privileges to their login. This occurs using both SQL Server Logins and Windows authentication logins. If I move the database to a different named instance (servername/TST), the problem no longer exists and users can connect with dbo privileges. Any suggestions or is this typical for default instances? Thanks in advance for any help
View 8 Replies View RelatedI added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
Hi, sorry but I am just getting my feet wet with the ADS wizard. I have managed to get the PPC emulator running the ADS wizard and have the emulator ActiveSync connected with desktop. Port 1024 opens from the emulator to the desktop. On the ADS wiz I can connect to the device .sdf. WHen I try to connect to the desktop I am getting a connection failure in the ADS wiz log and after stepping through the code VS watch window gives the following message for the SQL exception:
Message "Failure to open SQL Server with given connect string. [ connect string =
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Northwind.accdb; Jet OLEDBystem
Database=C:\Documents and Settings\vhaporellinr.POR-EE778886\Application Data\Microsoft\Access\system.mdw ]" string
I do not know enough to know where to go next to move past this no-doubt simple problem. Can you direct me to the appropriate docs or refs to start digging into looking for solutions?
Is there a particular Northwind.mdb file that is supposed to be used?
Are we talking some kind of permissions issues on the database?
I was assuming I did not have to install SQL Server 2005 and the SQL Server management console(?) to do development with the SSCE. Is that correct?
THank you for any helping pointers you can provide.
How much RAM is necessary for concurrent SQL connections? My server has 2 Xeon processors, 1GB RAM, a 10GB database size on a TCP/IP box. CPU utilization can run 80-90% and pages/sec can sometimes jump up to 40, especially is the users are running reports from the SQL database. I've been told by some people that I have enough RAM to support the 130 SQL user connections. Others I've been told that I need at least 40MB RAM per user (which means that I'm about 4GB short of RAM). Based on previous entries, I obviously need more, but how much more is the question.
View 3 Replies View RelatedI need a help in SQL Server 2000.
I am having a string variable in the format like -- (1,23,445,5,12)
I need to take single value at a time (like 1 for 1st, 23 for 2nd and so on) from the variable and update the database accordingly. This is like a FOR loop.
Can anyone help me out in splitting the variable using the comma separator...
I am writing SQL data apps using VB.NET 2003, MSDE is being used as theserver.When I create and instance of the server, it has a the formatmachinename/instancenameThis is fine for the developement machine but how does my code connect tothe server when it is on another machine ? When an instance of MSDE is runon the target, it will produce...anotherPCname/instancenameThanks for any help
View 11 Replies View Related
There are two machines(A and B) in intranet . The network between the machines is well.
I can't use client in machine A to connect the sql server in Machine B until i set the "connection timeout" a bigger number such as 30 seconds. If i use the default "connection timeout" to connect , it will return a error message "
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
But The correspondence of executing sql command is very quick after the connection is established.
Why need i bigger "connection timeout"？ Is that a configuration problem?
Thanks
Can I connect from a SQL Server 2005 database to a SQL Server 2000 database, without establishing a linked server connection.
I need to fire a SELECT query on a SQL Server 2000 database, but don't want to add it as a linked server. Is there any way I can do this or its not possible??
I have a report with this data query:
select ID1 = 6, ID2 = 15, ID3 = 3, ID4 = 3
The data is evidently static here, and hence database access is not required.
Is there a way to omit the connection string in the Datasource, or have a disconnected Datasource that does not connect to any database?
Currently I am setting the connection string arbitrarily, but it would be ideal to omit it altogether.
TIA,
ana
Hi,
I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.
SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.
So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.
However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.
I am using Windows Authentication where the I used a SQL Server account which exists with €œsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.
What do I do next please?
Hi I am trying to write the following connection string:public static SqlConnection connect() { SqlConnection sqlConn = new SqlConnection("server=9.0.3042;database=Menu;Connection Lifetime=300"); return sqlConn; } I am trying to connect to a sql database using c# code. The code above is in a seperate file. The code below is the code used to talk to the database SqlConnection sqlConn = connection.connect(); sqlConn.Open(); SqlCommand menubar = new SqlCommand("Select * from Menu_table", sqlConn); SqlDataAdapter dataAdapter5 = new SqlDataAdapter(); dataAdapter5.SelectCommand = menubar; DataSet dataSet5 = new DataSet(); dataAdapter5.Fill(dataSet5); DataTable selcartest4 = dataSet5.Tables["table"]; However the connection is just timing out like I have the wrong address set for the connection on the first bit of code posted any heklp would be great cheers J
View 4 Replies View RelatedHow do I create a connection string to connect to a Sql Server database?
I am using VB.Net to authenticate log on details.
What is the synax of the connection string?
I have tried one version but keep getting an error "Type SQLDataAdapter is not defined.
Can anyone help me with this?
Hey guys,
sorry to bother you with something so newbish, but I am trying to connect to a remote sql server db, using vb6.
I want to use ado to do so but have been having problem with some of the samples I have found online.
I will probably just test the connection out on an existing database like pubs or northwind.
Can anyone provide me a code snip please?
This forum has always been a great resource for me, thanks again guys!
Hello,I am doing the web based project for the final year of my cousein Information Technology using Asp.net and ms-sql server.But to startwith that I need to connect my web pages to the database.So Can anyone tell me how to connect my page web to the ms-sqlserver using Asp.net(Connection String)?.It will be better if someonegive me the code for the connection string along with the explainationso that I don't have problem understanding it.Any kind of help will be appreciated.Thank You.Suchen Chodankar.
View 1 Replies View RelatedHi all,
View 9 Replies View RelatedHi,
I've been trying to setup a merge replication environment for a SQL Server 2005 publisher. This connection can only happen via the internet and Port 1433 cannot be opened. The replication has to be enabled only via the intenet, which is why i figured web synchronization would be a feasible choice. I've since enabled the publisher and also set up the web synchronization on a SSL based virtual directory.
However, while setting up a subscription on the client machine (using Management Studio), the first step in the wizard is to connect to the publisher.
Essentially, i need to configure a subscriber to synchronize with a publisher using web synchronization over the internet, with no direct connection to the publisher.
I've followed all the steps specified in a multitude of web sites and "Books Online", however, i come back to the same problem at the subscriber.
Is there a way to get around this or am i not doing something correct?
Ashish
Hi,I trying to connect to the sql server in the network. The sqlserver is in the machine called "pinnacle". I am Using the following connection string to connect and i am getting the error "Sql server does not exist or Access denied"Public databaseConnectionStringSQL As String = "Data Source=(pinnacle);Initial Catalog=cms;Trusted_connection=True;User Id=dbuser;Password=password"Any help will be appriciated.Reagrds,Thiyasoft
View 4 Replies View Relatedi'm using sql server 2005 express edition as the database server for my web application. Right now, i want to deploy it and the problem is, my hosting is using sql server 2000. So, is it possible to deploy my database that has been created in sql server 2005 in the sql server 2000? I'm afraid that the connection string for sql server 2000 is different from sql server 2005. In addition, i'm using forms authentication in my web application. So, some data regarding to the forms authentication like dbo.asp_net.membership table, dbo.asp_net.roles table is in my database. Is it the table that has been created like dbo.asp_net.membership can be used in sql server 2000 since it is created by asp.net forms authentication function?
View 2 Replies View RelatedI have the Visual Studio 2005 Team Suite trial version and the SQL Server 2005 trial (which came with team suite) installed in my machine.
When I installed the SQL Server 2005 I installed it in the Windows Authentication mode. So every time I open SQL Server 2005 it doesnt ask for Username/Password (Its greyed out). The only thing available were:
Server Type: Database Engine
ServerName: ServerSue
Authentication: Windows Authentication.
Here is my Problem:
I created a small application in C#. In the web.config file I created the following:
<appSettings>
<add key="resumecon" value="SERVER=ServerSue;database=Resume;"/>
</appSettings>
Then in the Code behind I created the following string:
string strResCon = ConfigurationManager.AppSettings["resumecon"].ToString();
Then in method (for a Login page) I created the connection string as follows and wrote code to insert some values into the Resume database. I called this method on a button click event.
SqlConnection conLogin = new SqlConnection(strResCon);
When I run the page and when I click the button I get the following error:
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
I think some thing is wrong in the addkey of webconfig? How do I change this?
I am slightly confused about SQL Server connections strings. When I used the following connection string:
string strConn = "server=deciusawa;database=xxxx;uid=xxxx;pwd=xxxx";
I get an error saying "Format of the initialization string does not conform to specification starting at index 13. "
I spent ages trying to figure out why this was and I eventually discovered that adding an "@" symbol before the string fixed it, i.e.
string strConn = @"server=deciusawa;database=xxxx;uid=xxxx;pwd=xxxx";
Most of the examples I have seen to not use the "@" symbol so I am just wondering what is does and when you need to use it?
Thanks,
Mark
I am using SQL server express 2005. I can drag and drop a grid control on to my web form and choose the data source to point to a SQL server database. Then datais nicely displayed on my web form.
Now I need to manually create my connection to the database as I need to read from a text file and then populatea database table with those values I read from the text file. I have not had any success with this though and I am stuck and need some help.
Below is my C# code and I list the web.config code where my connection string is stored.
Note that I can trace into the C# line of code below. If I then do a "Quick Watch" on "myConnection" in the debugger, the followingerror message is displayed:
ServerVersion 'myConnection.ServerVersion' threw an exception of type 'System.InvalidOperationException' string {System.InvalidOperationException}
So I don't know what the problem is here. If someone can help me out I would be forever thankfull
C# code:
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["TheDividerConnectionString"]);
Here is the connection string as defined in the web.config file:
<connectionStrings> <add name="TheDividerConnectionString" connectionString="Data Source=BVCOMPUTERSQLEXPRESS;Initial Catalog=TheDivider;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings>
I'm trying really hard to set this website up so that I can have a web layer... bll, and dal. But I can't figure out the connection string in the config file. Can someone take a look? <connectionStrings> <add name="SearchConnectionString" connectionString="Data Source=AURORASQLEXPRESS;Initial Catalog=Search;"/> <add name="SearchEngine.DAL.Properties.Settings.SearchConnectionString" connectionString="Data Source=AURORASQLEXPRESS;Initial Catalog=Search;" providerName="System.Data.SqlClient"/></connectionStrings>
View 3 Replies View RelatedI've been using my old connection string for years, and it has worked fine in 1.1 and 2.0 betas
It's pretty basic: "Data Source=Computername;Initial Catalog=MyDB;Integrated Security = true"
For some reason, I am having trouble getting this to work on SQL Server 7 with the release code of asp.net 2.0
What does work is to open up TCP/IP on the server network utility (I
usually only use named pipes) and change the connection string to "Data
Source=123.123.123.123;Initial Catalog=MyDB;Integrated Security = true"
The latter (with the IP of the box istead of 123....) works great, so I
can be sure that my IWAM account has correct permissions to access the
DB.
Does ASP.NET talk with sql servers using a different protocol than
Named Pipes by default? I'm a bit spooked to open up TCP/IP on my
production box as I saw the damage that SQL Slammer did a few years
back, and want to keep everything as locked down as possible.
Thanks,
John
I am using asp.net 2.0, and am attempting to connect to a SQL Server 2000 database. When I run the web page either in the debugger, or by viewing it in the browser, I get the following error message:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
I think that maybe my values for uid, and pwd are not correct? If this is the problem, then I don’t know what their values should be? Should uid always be equal to sa ??(If so why?)
Also I don’t know what the password should be. I don’t know what the name of the password as it was assigned over two years ago when I installed sql server 2000. I might need some instructions on how to find this value in SQL server.
Someone please help me if you can. Here is a snippet of the code I am using:
String sqlStmt = "INSERT INTO LogIn (UserName,PassWord) VALUES ('JohnyRocket','FastestRocket99')";
SqlConnection sqlConn = new SqlConnection("server=localhost;uid=sa;pwd=;database=MyWebSite;");
SqlCommand sqlCmd = new SqlCommand(sqlStmt, sqlConn);
sqlConn.Open();