MS SQL Server :: Connecting Instructions?

XML Output Instructions?

Apr 22, 2008

I'm doing a data conversion project, and am considering the possibility of using Reporting Services to create the required XML export files. Can anyone recommend some good documentation on using Reporting Services 2005 for creating XML files? The online docs are not that helpful.

View 1 Replies View Related

Installation Instructions

Dec 21, 2007

Can anyone suggest a good book or tutorial on installing Sql Server Express as an embedded database with an application? My company makes a software product sold in retail and we sell 10,000+ units per year. I have been going over the MSDN site, these forums, Technet etc. and I haven't found a good, inclusive instruction set on installing SQL Server Express with zero user intervention. This is very important for this type of application. The underlying database needs to be invisible to the user. I have looked at several in-process databases including SQL Server Compact and VistaDB, but they have shortcomings that make them not a good fit for this application. They are definitely much easier to install, though.

I found the MSDN articles on "Embedding Sql Server Express in your Customer Application" that talks about creating a wrapper to install SQL Express and the application. It just seems like there are lots of security issues (with Vista and UAC) that have to be dealt with, configuration issues, issues with creating databases in code once your application starts, etc.

I am looking for a good technical reference on doing this type of work.

Any recommendations would be greatly appreciated.

View 3 Replies View Related

ActiveX, DTS, And Other Confusing Instructions

Feb 15, 2005

Hi everybody.

I've been looking on-line for about a day now and can't find what I'm looking for. I don't know much about ActiveX and even less about using it in a DTS package. If you guys could help me out be telling me what to use/give a few minimal examples I can figure the rest out. I just can't find enough info on the web to do what I want.

I'll describe what I've got, what I'm trying to do with it, and we'll see what you guys think.

What I've got:
A table that stores To, Subject, MsgText, MsgHTML, and FileAttachment locations.

What I'd Like to do:
Write out the info in the table into a text file and then copy it to the Pickup folder to be sent. Now, I know DTS has an e-mail task, but the Dynaprops/e-mail task are being flaky. The information in the E-Mail doesn't always seem to update like I'd like it.

How I was planning on doing it:
Write an ActiveX script to Create the E-mail, store it in the DB, and then Write it out to the txt file to be sent.

I think this'd be a good way to do it, but then again I could be wrong. Maybe use something else? Please help. I could use it.

Your help is more than appreciated.

Thanks!
-Me

View 2 Replies View Related

Instructions For SQL Server Management Studio Express?

Dec 6, 2005

Are there some instructions for SQL Server Management Studio Express?
I downloaded it at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en

View 1 Replies View Related

Possiblity / Instructions On How To Install Report Builder Locally Without Hitting Report Server

Feb 16, 2007

We have a remote business client who has a proxy server setup and this translates into receiving a 407 proxy authentication blocking error when attempting to download the report builder application for deployment off the report server which is housed locally with us. The proxy server does not allow them to download application type files off another site. At the moment, they would not like to disable the proxy for these users to allow them to deploy the application on their client or add the report server as a trusted site. Is there a method by which Report Builder can be locally installed on the client pc instead of online only with it knowing the correct report server to access and then still launch correctly when the report builder button is pressed through report manager?

I am not a web application guru by any means and we have tried to replicate the oneclick deployment and what occurs in the local settings/apps/2.0 subdirectories, but the application still attempts to download/install again. If we attempt to just launch the local executable on the client, report builder assumes the client pc (localhost) is the report server to access. Is there a method which will succeed?

View 1 Replies View Related

Instructions For Setting Up A Sybase ASE Server As A SQL Server 2005 Linked Server?

Dec 28, 2005

I have a Sybase Adaptive Server Enterprise server which I need to set up as a linked server in SQL Server 2005. The Sybase server is version 12.5.2, and the Sybase ODBC driver version is 4.20.00.67. I have already installed the Sybase client software on the server.

I also created a SystemDSN on the SQL Server to connect to the Sybase server. I tested the connection and it was able to connect.

I ran the following code to create the linked server:

<code>

EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServerName', @srvproduct=N'Sybase', @provider=N'MSDASQL', @datasrc=N'Sybase System DSN', @provstr=N'"Provider=Sybase.ASEOLEDBProvider;Server Name=servername,5000;Initial Catalog=databasename;User Id=username;Password=password"'

</code>

I then ran sp_tables_ex to make sure I could view the tables in the Sybase database. Here is the error message I get:

<code>

OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[DataDirect][ODBC Sybase Wire Protocol driver]Error parsing connect string at offset 13. ".

Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName".

</code>

Any ideas what is happening here?

View 10 Replies View Related

Connecting To SQL In ASP.net 20

Aug 6, 2006

I have a database that is currently connected and working properly in My SQL Server Management Studio. The problem I am havings is when I open My ASP.net 20 and Look in my Server Solutions I can not find the database to connect to it . It seems to be trying to use SLQ Express and not my SLQ Server Management Studio. How do I get my database to connect in my application? All I can see from within the Server solutions in ASP is the database .bak file which is the backup of the database. I thank you in advance.

View 5 Replies View Related

Connecting To SQL 6.5 With VB.NET

Apr 5, 2004

Hi,

I am trying to connect to a SQL 6.5 database with VB.NET.

Is this possible, and if so, what kind of connection string is used and what mode of data access (OleDB, ODBC, etc.)

I have had several problems doing this and I am starting to wonder if there is anything special that needs to be done or if it is even possible. Thanks in advance!

View 3 Replies View Related

Connecting To SQL 6.5

Oct 28, 1999

Has anybody experienced SQL 6.5 to stop responding to new connections to the server but still letting the existing connections run?

View 1 Replies View Related

Connecting To DB

Sep 21, 2004

is ther a system stored procedure to connect to a database passing the username and password as parameters.. ??

View 6 Replies View Related

Connecting To 6.5 Over TCP/IP

Dec 8, 1999

I am trying to connect through a wan over TCP/IP to a SQL Server v.6.5 sp5a.
I am not logging into the domain, I am just trying to connect via ODBC. I keep getting an error 1326
which when I look in TechNet or MSDN refers to problems with Named Pipes. I have
TCP/IP configured for port 1433, Named Pipes, and Multiprotocol support all configured on the server.
Should I remove the Named Pipes support, or is that not the problem?

View 1 Replies View Related

Connecting To SQL DB

Jan 13, 2005

Hi,

I have a server (Server A) and would like to retrieve a query from a SQL DB which is held on another server (Server B), if I created a VPN or opened a port from one server to another could I acheive this?

BTW I do not have SQL running on the Server A

Am I asking for trouble?

Thanks,

Sanj

View 1 Replies View Related

Connecting To MS SQL

Mar 2, 2004

Hey everyone. I'm having some serious problems connecting to my database. I've pretty much bugged my server admin to death and I still can't connect to it. I've tried almost all the programs out there as well as http://www.aspenterprisemanager.com. I've probably spent a good 12 hours on this task (im trying to put MaxWebPortal on my site) and I'm going to ask for help. This is what my admin gave me for the SQL db:

Database Name: S5464_sehs
SQL Server: mssql4.uplinkearth.com
ODBC DSN: S5464_sehs
Username: sehs.us
Password: **********

Would anyone be able to help me to connect to this?

View 4 Replies View Related

Connecting To Sql 2k Thru Sql 7 EM

May 17, 2004

Can I connect to SQL server using sql 7 EM? currently it is not allowing me
to connect, but some one told me that there is a work around.Anyone heard/aware of it?

Regards,
Harshal.

View 3 Replies View Related

Connecting To Dbf

Aug 21, 2006

Hi,

I am having trouble connecting to a dbf file inside an SSIS package. How do I connect to a dbf file in SSIS.

Thanks

Brian

View 1 Replies View Related

Connecting From VS.net

Jan 16, 2008

Hey all! I am new in this form and also new with the SQL serve. I have installed that free express edition of SQL server 2005 and when i am trying to connect to server from my C#.net application i am not able to do it and the error i am getting is the user is not SQL thrusted user. I am able to connect directly thru SQL server using this userid and password but not thru C#.net application.

I have read online that so many people are having that problem. so is it the problem of swl server Express edition or do i have to make some setting to connect to the application.

Please please please please someone guide me . I am stuck here in the beginning only. I would really appreciate it.

the code that i wrote is here:----

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

}

}
protected void Submit_Click(object sender, EventArgs e)

{

String querry;

SqlDataReader dbread;

try

{

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["Conn1"]);

SqlCommand comm = new SqlCommand();

conn.Open();

querry = " Select password from login where userId='" + TxtUser.Text + "'";

comm.CommandText = querry;

comm.Connection = conn;

dbread = comm.ExecuteReader();

dbread = null;

if (dbread.HasRows)

{

while (dbread.Read())

{

if (dbread["password"].ToString() == Txtpwd.Text)

{

Response.Redirect("home.aspx");

}

}

Response.Write("Your Password Doesn't Match");

}

else

{

Response.Write("Your User Name Is Wrong");

}

conn.Close();

}

catch (Exception ex)

{

Response.Write(" This is an Error - " + ex.Message );

Response.End();

}

Thanks,
Komal

View 3 Replies View Related

Connecting To IBM DB2

Jul 18, 2007

We need to connect to an DB2 server using ODBC provider, so we tried witht he folowing:

Driver={IBM DB2 ODBC DRIVER};database=FirstDB; hostname=IP address; port=50000;protocol=TCPIP;

But when we try to connect using the above connection string we get teh following error:

"Test Connection failed because of an error in initializing provider. ERROR [IM004][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

we are not getting wat is the problem. we are able to connect to this DB2 database from the same DB2 server but we are not able to connect to the server from a remote machine.

Thanks in advance.

View 1 Replies View Related

Connecting Through C#

Jan 23, 2007

When I look at the connection string it's:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ProcBuilder.mdf;Integrated Security=True;User Instance=True

This works fine on my machine, but when I try to run it on another computer it tells me:

"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."

It should not be trying to connect remotely, it's a local DB. Do I
have to install SQL Express on the machine I'm installing this on for
it to work?

View 1 Replies View Related

Connecting .mdf Through RDA

Feb 8, 2008

Dear All,

We have Database in local system and another database in remote system.
We have to connect to the database in the remote system through RDA.
How can we achieve this?
Kindly help.
Thanks in advance.

Regards,
Sasi.

View 6 Replies View Related

Connecting To Sqlserver In Asp.net

Jul 15, 2006

hi , I want to connect to sqlserver2000 with VS.Net2003 in Asp.net I
've added a new user in security section in enterprise manager and
wrote my code , but there is no output from database , codes are
correct and I think there is something wrong with sqlserver or IIS or
sqlconnectin setting , plz help me to fix my problem , tnx .

View 2 Replies View Related

Connecting To SQL Issue

Aug 2, 2006

I have a mdf file and log file from msde. I have successfully connected to it in my Visual Studios ASP.net 2.0 Desktop. I am having a problem where it connects. fine but it does not list the tables , diagrams etc. I am trying to build the intake screen with this data but have no tables. Can some one give me a couple of suggestions of why? I am very new to ASP.net and would appreciate any help .

View 4 Replies View Related

Error While Connecting

Sep 18, 2006

Hey all,I am new to ASP.NET. While executing a simple code , i got the error: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Whats wrong? RegardsYasir

View 1 Replies View Related

Connecting To MSSQL In VBA?

Jan 9, 2007

This is kind of the wrong place to ask VBA questions, but I've been poking around for a day and haven't got the answer, so I am hoping I can get some help here.
I am wondering if I can connect to MSSQL in MS Word Macro. If so, can I have some sample code please?
Thanks

View 3 Replies View Related

Connecting To SQL Error 40

Mar 9, 2007

I'm trying to connect to an SQL server, but I'm unable. It suggests this is because SQL server does not allow remote connections, and points me to the named pipes provider, error 40 Could not open a connection to SQL server.
I am running SQL express service pack 2 under Vista. I am a member of SQL administrators (set during installation).
Under the SQL Server Configuration manager, SQL server and Browser are running, the protocols for sqlexpress and the native client have enabled shared memory, named pipes, and tcp/ip.
I tried removing and creating a new database. Now it sits under the database Engine section of Management Studio Express, with a white circle on the database icon. When I try to connect to this database, using either windows authentication or sql server authentication, it fails.
What else is there to try? If there was a troubleshooting guide, that would be helpful.

View 1 Replies View Related

Connecting SQL Server To The Net?

Jun 28, 2007

Hi all. Im using Visual Web developer 2005 and have successfully connected my SQL Server to Visual Web developer website. When i run it locally, its fine. But, i now would like the site to be placed on the net - but im not sure how to connect it properly in the webhost. Can someone tell me how this is done please, or a link? cheers.

View 4 Replies View Related

Connecting To A Remote OLE DB

Sep 2, 2007

Hey, all. I've mainly worked with MySQL databases before. I'm working on an (old) ASP page that uses this connection string:strConnect = "Provider=SQLOLEDB; Data Source=SQL1.MYDBSERVER.NET; Initial Catalog=...; User ID=...; Password=..."
It works fine on the production server, but the local copy fails if I try to access the Products page (which uses the database), with this error: Microsoft OLE DB Provider for SQL Server (0x80004005)[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied./html/products.asp, line 19Similarly, if I plug the connection info into Tools/Connect to Database in Visual Studio, I get: Connection failed:SQLState: '08001'
SQL Server Error: 17
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. Am I doing something wrong? Do I need more info from the hosting provider to connect remotely? Or is the database not accepting remote connections at all?Thanks in advance for your help!

View 1 Replies View Related

Connecting To SQL Server

Sep 12, 2007

Hi, I have a problem in logging in to an SQL Server database engine. I can log in to the engine with Windows authentication method. The problem is, when I create a page with an SqlDataConnection control, the page can not connect to the database engine eventhough I select "Use Windows Authentication" when configuring the SqlDataConnection. What should I do?Best regards,Haris

View 3 Replies View Related

Connecting To SQL Database?

Sep 24, 2007

I am very new to web development using Microsoft Visual Studio. (my primary expertise is Framemaker 2003). I am currently going through your ASP.NET 2.0 videos and reproducing the lesson content on my development system. I have Microsoft Visual Studio 2005 Professional Edition. I also have Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft .NET Framework SDK v1.1 and Microsoft .NET Framework SDK v2.0.
I seem to be having difficulties with the SQL interface because when I try to use the Property object from Lesson04, I get System.Web.HttpExceptioon {"Unable to connect to SQL Server database."}. When I subsequently tried to Add New Item - SQL Database from Lesson08, I get a Microsoft Visual Studio error box "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251"
Any ideas? I know the videos are based on use of the Microsoft Visual Studio Express -- are there significant configuration differences between it and Microsoft Visual Studio Professional that would make these lessons incompatible?

View 10 Replies View Related

Connecting With Database

Sep 26, 2007

Using web dev and sql 2005 express
I have published web app and database to my server but can,t get connection string to connect with the database.
---------------------------------------------------------------------
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
---------------------------------------------------------------------
I have created a user in the logins in the sql server security node and give him every permission
going.
I have also created a login in the security node for the database..... and given him all permissions
But I still can,t get the connection string from the web app to connect to the database?
Where am I going wrong

View 5 Replies View Related

Error Connecting To DB

Nov 10, 2007

I downloaded an ASP.NET web application from the web to learn the .NET framework. I was successful in running the website on my laptop using ASP.NET Development Server that comes with Visual Studio 2005. My laptop is running Windows XP Professional and SQL Server 2005. I am now trying to do the same on my desktop computer running Windows Vista; however, for some reason i am getting an error when the website tries to connect to the DB. Here are the steps i have followed so far:1. I tried to configure the website DB connection the same way i configured it on my laptop. Basically I use the following connectionStrings: <connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=True" providerName="System.Data.SqlClient"/> </connectionStrings>2. That same connection string worked fine on my laptop. But I got the following error on my desktop: 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)I am wondering if the error is related to Vista. When i try to connect to that DB using SQL Management Studio via Windows Authetication and do not run it as Administrator then I cannot connect to the DB. In other words, only when i run SQL Management Studio as administrator i am able to use Windows authentication to connect to that DB.3. Next, I tried creating a SQL login. I made sure I can use that login to access the DB directly using SQL Management Studio. In addition, I changed the database to allow "Local and remote connections" "Using both TCP/IP and named pipes".4. Changed the connectionStrings in web.config to: <connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=False;uid=*****pwd=****" providerName="System.Data.SqlClient"/> </connectionStrings> Obviously, the actual connectionString has the actual user name i created and the correct password instead of (*) asterisks.5. And once again, I got same error as above Any help will be appreciated!

View 8 Replies View Related

Connecting To The SQL Database

Nov 21, 2007

Hi all,
I am new to this field. I am trying to Connect to the database using the following code. The code does not give an error but gives an empty grid view.
Can somebody figure out the mistake?protected void Page_Load(object sender, EventArgs e)
{if (!IsPostBack)
BindGridView();
}void BindGridView()
{
System.Data.SqlClient.SqlConnection sqlconnect = new System.Data.SqlClient.SqlConnection("");//added connection string here
String command = "SELECT * from table";System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand();
sqlcommand.CommandText = command;
sqlcommand.Connection = sqlconnect;System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
da.SelectCommand = sqlcommand;DataSet ds = new DataSet();
sqlconnect.Open();
sqlcommand.ExecuteNonQuery();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
sqlconnect.Close();
}

View 8 Replies View Related

Connecting To SQL Server

Dec 12, 2007

Hi
i'm having lots of problems connecting my application to a database. I'm using Visual Web developer 2008 (coding in VB) and trying to connect to a locally installed version SQL server Express.
what i'm trying to do is using a DropDownList box get a user to select a name. This will then automaticly run a SQL query to pull data out of the DB and into a GridView. i'm coding (in VB only) everything under the DropDownList.SelectedIndexChanged section.
the query i want to run is -
SELECT name, description, data_added, priority_id FROM task WHERE (owner_id = (SELECT owner_id FROM owner WHERE (owner_id = @owner_id)
The owner_id field references another table (owner). Therefore i run the inner query to get the owner_id based on the selected name in the dropDownlist, then let the outer query pull out all tasks which match the result from the inner query.
my code at the moment is Dim ds As New DataSet
Dim myconnection As SqlConnection 'create a connection
'create connection to DB
myconnection.ConnectionString = "server=localhost;database=taskDB"
'create the sql commandDim objcmd As New SqlCommand("SELECT name, description, data_added, priority_id FROM task WHERE (owner_id = (SELECT owner_id FROM owner WHERE (owner_id = @owner_id)))", myconnection)
objcmd.Connection.Open()
'open the connection to DB
Dim objreader As SqlDataReader = objcmd.ExecuteReader Dim da As New SqlDataAdapter
da.SelectCommand = objcmd
'fails here sql not allowing remote connection
da.Fill(ds)Me.GridView1.DataSource = da
Me.GridView1.DataBind()
'close the connection to the DB
objcmd.Connection.Close()

The application fails when you select a name from the drop down box.
fails at - myconnection.ConnectionString = "server=localhost;database=taskDB" Error is "Object reference not set to an instance of an object." If i comment out this line, i get the same error but at it stopps at the objcmd.connection.open(). Strange.

Can anyone tell me what i am doing wrong? Have i setup the connection to the DB ok?

Thanks
Cj

View 1 Replies View Related