Why Has This Connect Posting Been Set To [Won't Fix]?

Jun 29, 2007

I have a connect posting here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=284301&wa=wsignin1.0 that has been set to Resolved (Won't fix). I'm very annoyed about that for starters because its something that is EASILY fixed but what's even worse is that there is no explanation as to WHY it has been set to this.



I have complained voraciously about the lack of feedback on Connect postings in the past, and to be fair it has improved, but this is going back to the bad old days.



Why has this been set to "Won't fix"?



-Jamie



[Microsoft follow-up]

View 3 Replies


ADVERTISEMENT

Posting A Query?

Nov 15, 2007

Its very difficulty to find the link to post query...
In this forums site...pls tell me the location...where can I find the link to post a query...

View 1 Replies View Related

Posting Stopped ?!?!

Mar 31, 2004

It appears that posting of messages has stopped for at least an hour. I've never seen that happen in this forum during US daytime hours!

-PatP

View 4 Replies View Related

Need Help Posting To Sql Table With A Sproc

Jan 4, 2005

To all,

Here's the error:
Input string was not in a correct format.
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.FormatException: Input string was not in a correct format.

Source Error:


Line 159:
Line 160:objConn.Open()
Line 161:objCmd.ExecuteNonQuery()
Line 162:objConn.Close()
Line 163:


Source File: C:FullerAviationSupplymanagecatalog.vb Line: 161

Stack Trace:


[FormatException: Input string was not in a correct format.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +194
managecatalog.SubmitProd(Object s, EventArgs e) in C:FullerAviationSupplymanagecatalog.vb:161
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573





Here's the code from my vb file:


Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub

#End Region


Protected WithEvents dgProductCatalog As datagrid
Protected WithEvents tbxProductName As TextBox
Protected WithEvents tbxInventory As TextBox
Protected WithEvents dgCatProd_Active As DropDownList
Protected WithEvents dlvendor As DropDownList
Protected WithEvents dlSubcat As DropDownList
Protected WithEvents btnLinkvend As Button
Protected WithEvents tbxshortdesc As TextBox
Protected WithEvents tbxlongdesc As TextBox
Protected WithEvents qtyPA As TextBox
Protected WithEvents pricePA As TextBox
Protected WithEvents qtyPB As TextBox
Protected WithEvents pricePB As TextBox
Protected WithEvents qtyPC As TextBox
Protected WithEvents pricePC As TextBox
Protected WithEvents sizeX As TextBox
Protected WithEvents dlX As DropDownList
Protected WithEvents sizeY As TextBox
Protected WithEvents dlY As DropDownList
Protected WithEvents sizeZ As TextBox
Protected WithEvents dlZ As DropDownList
Protected WithEvents weight As TextBox
Protected WithEvents dlweight As DropDownList
Protected WithEvents dgInsertProduct As Button
Protected WithEvents thumbfile As TextBox
Protected WithEvents mainfile As TextBox



Dim objDA As SqlDataAdapter
Dim objDS As New DataSet()
Dim objDX As New DataSet()
Dim objDV As New DataSet()
Dim objDU As New DAtaSet()
Dim objDW As New DAtaSet()
Dim objDT As DataTable
Dim objDR As DataRow
Dim objConn As SqlConnection = New SqlConnection(ConStr)

Sub Page_Load()

If Not IsPostBack Then
BindData()
End IF

End Sub

Sub BindData()


objDA = New SqlDataAdapter("GETCATALOG",objConn)
objDA.Fill(objDS, "MainCatalog")
objDT = objDS.Tables("Catalog")
dgProductCatalog.DataSource = objDS
dgProductCatalog.DataBind()


objDA = New SqlDataAdapter("GETSUBCAT",objConn)
objDA.Fill(objDX, "SubCat")
dlSubcat.DataSource = objDX
dlSubcat.DataValueField = "SubCat_ID"
dlSubcat.DataTextField = "SubCat_Name"
dlSubcat.DataBind()

objDA = New SqlDataAdapter("GETVENDOR",objConn)
objDA.Fill(objDV, "Vendor")
dlvendor.DataSource = objDV
dlvendor.DataValueField = "VendorID"
dlvendor.DataTextField = "CompanyName"
dlvendor.DataBind()

objDA = New SqlDataAdapter("GETSIZEUNITS",objConn)
objDA.Fill(objDU, "Units")
dlX.DataSource = objDU
dlX.DataValueField = "Size_ID"
dlX.DataTextField = "Size_Unit"
dlX.DataBind()

dlY.DataSource = objDU
dlY.DataValueField = "Size_ID"
dlY.DataTextField = "Size_Unit"
dlY.DataBind()

dlZ.DataSource = objDU
dlZ.DataValueField = "Size_ID"
dlZ.DataTextField = "Size_Unit"
dlZ.DataBind()

objDA = New SqlDataAdapter("GETWEIGHTUNITS",objConn)
objDA.Fill(objDW, "Units")
dlweight.DataSource = objDW
dlweight.DataValueField = "weight_unitID"
dlweight.DataTextField = "weight_Unit"
dlweight.DataBind()

End Sub

Sub SubmitProd(s As Object, e As EventArgs)

Dim objCmd As New SqlCommand("INSERTPRODUCT", objConn)
objCmd.CommandType = CommandType.StoredProcedure
objCmd.Parameters.Add("@prodName", tbxProductName.Text)
objCmd.Parameters.Add("@descShort", tbxshortdesc.Text)
objCmd.Parameters.Add("@descLong", tbxlongdesc.Text)
objCmd.Parameters.Add("@qtyPA", SqlDbType.int ).Value = qtyPA.Text
objCmd.Parameters.Add("@qtyPB", SqlDbType.int ).Value = qtyPB.Text
objCmd.Parameters.Add("@qtyPC", SqlDbType.int ).Value = qtyPC.Text
objCmd.Parameters.Add("@pricePA",SqlDbType.money).Value = pricePA.Text
objCmd.Parameters.Add("@pricePB",SqlDbType.money).Value = pricePB.Text
objCmd.Parameters.Add("@pricePC",SqlDbType.money).Value = pricePC.Text
objCmd.Parameters.Add("@vendorID", dlvendor.SelectedItem.Value)
objCmd.Parameters.Add("@inventoryAvail", SqlDbType.int).Value = tbxInventory.Text
objCmd.Parameters.Add("@imageThumb", thumbfile.Text)
objCmd.Parameters.Add("@imageLarge", mainfile.Text)
objCmd.Parameters.Add("@sizeX", sizeX.Text)
objCmd.Parameters.Add("@sizeY", sizeY.Text)
objCmd.Parameters.Add("@sizeZ", sizeZ.Text)
objCmd.Parameters.Add("@sizeUX", dlX.SelectedItem.Value)
objCmd.Parameters.Add("@sizeUY", dlY.SelectedItem.Value)
objCmd.Parameters.Add("@sizeUZ", dlZ.SelectedItem.Value)
objCmd.Parameters.Add("@weight", weight.Text)
objCmd.Parameters.Add("@prodActive", dgCatProd_Active.SelectedItem.Value)
objCmd.Parameters.Add("@weightU", dlweight.SelectedItem.Value)
objCmd.Parameters.Add("@SubCat_ID", dlSubcat.SelectedItem.Value)


objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()

tbxProductName.Text=""
tbxInventory.Text=""
tbxshortdesc.Text=""
tbxlongdesc.Text=""
qtyPA.Text=""
pricePA.Text=""
qtyPB.Text=""
pricePB.Text=""
qtyPC.Text=""
sizeX.Text=""
sizeZ.Text=""
sizeZ.Text=""
weight.Text=""
BindData()

End Sub




And here's the Stored Procedure:

CREATE PROCEDURE INSERTPRODUCT
(
@prodName nvarchar(50),
@descShort nvarchar(3000),
@descLong nvarchar(4000),
@qtyPA int,
@qtyPB int,
@qtyPC int,
@pricePA money,
@pricePB money,
@pricePC money,
@vendorID int,
@inventoryAvail int,
@imageThumb nvarchar,
@imageLarge nvarchar,
@sizeX nvarchar,
@sizeY nvarchar,
@sizeZ nvarchar,
@sizeUX int,
@sizeUY int,
@sizeUZ int,
@weight nvarchar,
@prodActive int,
@weightU int,
@SubCat_ID int
)

AS

INSERT INTO ProductCatalog (ProductName, Desc_Short, Desc_Long, qty_PerA, qty_PerB, qty_PerC, Price_PerA, Price_PerB, Price_PerC, VendorID, InventoryAvail, image_Thumb, image_Large, Size_X, Size_Y, Size_Z, SizeUnit_X, SizeUnit_Y, SizeUnit_Z, weight, Prod_Active, weight_unit, SubCat_ID) VALUES (@prodName, @descShort, @descLong, @qtyPA, @qtyPB, @qtyPC, @pricePA, @pricePB, @pricePC, @vendorID, @inventoryAvail, @imageThumb, @imageLarge, @sizeX, @sizeY, @sizeZ, @sizeUX, @sizeUY, @sizeUZ, @weight, @prodActive, @weightU, @SubCat_ID)
GO


Any help would be greatly appreciated.

Regards,
Seth

View 2 Replies View Related

Helpful Blogs - Take A Look Before Posting

Aug 29, 2007

I think we could solve quite a few questions much faster by posting helpful blogs here.
Some questions are asked over and over and the answer is typically: see this blog. People simply don't know it's out there.

So, if you are the author of a useful Reporting Services blog, or have found a Reporting Services blog particularly helpful, please post it here (keep it strictly to links that you feel solve a large number of RS questions).

If you would, also provide a short description as to the content of the blog.


I'll start with these:

Session Timeouts -- http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
SSRS Setup -- http://prologika.com/CS/blogs/blog/archive/2007/07/12/ssrs-setup-woes.aspx
Complex SQL Issues -- http://spacefold.com/lisa/category/SQL-Server.aspx

View 2 Replies View Related

Posting An Image To SQL Server 2005

Jun 22, 2007

Hello Everyone I am trying to write image files to sql server using the following code. I have recieved the following error message
Failed to convert parameter value from a String to a Byte[].  Please help.  I am sure it is a problem gathering the iostream.  I am not very familiar.  Any help is gretaly appreciated.
Thanks in advance
Here is the code:
'Dim User As MembershipUser = Membership.GetUser(CreateUserWizard1.UserName)
'Dim t As TextBox = DirectCast(FormView1.FindControl("aspnet_UserID"), TextBox)Dim objConn As SqlConnection
Dim objCom As SqlCommand
If Me.FileUpload1.HasFile Then
Dim fileExtension As String
Dim fileOK As Boolean = False
fileExtension = System.IO.Path. _
GetExtension(FileUpload1.FileName).ToLower()Dim allowedExtensions As String() = _
{".jpg", ".jpeg", ".png", ".gif", ".mwv"}For i As Integer = 0 To allowedExtensions.Length - 1
If fileExtension = allowedExtensions(i) Then
fileOK = True
End If
Next
'TryDim imagestream As System.IO.Stream = FileUpload1.FileContent
Dim data() As ByteReDim data(imagestream.Length - 1)
imagestream.Read(data, 0, imagestream.Length)
imagestream.Close()objConn = New SqlConnection(strNewConnection)
objCom = New SqlCommand("insert into ProfileImagesAndDocs(aspnet_userid,img_name,img_data,img_contenttype)values(@aspnet_userid,@imagename,@Picture,@CategoryName)", objConn)
'---------------------------------------------
'this is the aspnet_useridDim useridparameter As SqlParameter = New SqlParameter("@aspnet_userid", SqlDbType.VarChar)useridparameter.Value = Me.aspnet_userid.Text
objCom.Parameters.Add(useridparameter)
'---------------------------------------------
'This is the image name Dim imagenameparameter As SqlParameter = New SqlParameter("@imagename", SqlDbType.VarChar)imagenameparameter.Value = Me.FileUpload1.FileName
objCom.Parameters.Add(imagenameparameter)
'----------------------------------------------
'this is the picture dataDim pictureParameter As SqlParameter = New SqlParameter("@Picture", SqlDbType.Image)
pictureParameter.Value = data
objCom.Parameters.Add(pictureParameter)
'----------------------------------------------
'this is the profile area or category i.e. video introDim categorynameParameter As SqlParameter = New SqlParameter("@CategoryName", SqlDbType.VarChar)
pictureParameter.Value = "IntroVideo"
objCom.Parameters.Add(categorynameParameter)
 
objConn.Open()
objCom.ExecuteNonQuery()
objConn.Close()
'bookmark
Label1.Text = "File uploaded!"
'Catch ex As Exception
Label1.Text = "File could not be uploaded."
End If

View 2 Replies View Related

Help On Execute Proces Task --posting Secoind Time

Feb 20, 2008



Hi,

I have a batch file which is located in different server. When I try to execute in BIDS it is running fine. But when I execute as SQL agent job it is not executing.

In the execute process task under executable I have supplied the batch file path . For example \112.89.93.9abcsample.bat.

It is executing fine when I execute this in BIDS supplying the above path under executable. But when I run this as SQL agent job it keeps on running and does not end and it is doing anything.

Do I need to mention any cmd.exe file under executable and give the path under arguments tab?

Any help is appreciated.

Thanks




View 10 Replies View Related

How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

Sep 12, 2005

How do I prevent SQL Server 2000 from posting successful backupcompletion messages to the Windows 2000 Application Event Log?I have scheduled jobs which backup my transaction logs on 50+ databasesand it always writes to the Windows 2000 application event log uponcompletion.Due to the frequency of the jobs it only takes a day for theApplication Log to fill up, which is causing other jobs to get hung upwhen trying to write to it. On my Windows 2000 server, I have theapplication log event viewer setting correctly set as:"When maximum log size is reached - Overwrite events as needed" but forsome reason this setting no longer applies like it did for the pastthree years. SQLServerAgent and MSSQLSERVER both run under a localAdmin account, without a domain.When I researched how prevent SQL Server from logging this type ofmessage, I found that I can use sp_update_alert to disable thismessage, but I cannot findthe message_id to correctly disable this message. In sysmessages, themessage I am trying to suppress iserror:18265severity:10dlevel:128description:Log backed up: Database:%1, creation date(time): %2(%3), first LSN: %4, last LSN: %5, number ofdump devices: %7!d!, device information: (%8).mslangid:1033I tried calling sp_update_alert as follows:exec sp_update_alert @name = 'Log backed up: Database: %1, creationdate(time): %2(%3), first LSN: %4, last LSN: %5, number of dumpdevices: %7!d!, device information: (%8).', @enabled = 0but got the error message:Server: Msg 14262, Level 16, State 1, Procedure sp_update_alert, Line105The specified @name ('Log backed up: Database: %1, creation date(time):%2(%3), first LSN: %4, last LSN: %5, number of dump devices: %7!d!,device inf') does not exist.Looks like it can only handle 128 characters.How can I disable this message from being logged in the ApplicationLog? Or alternatively, how can I get the event viewer to behave asexpected and"Overwrite events as needed"?Thanks,Mike Orlando

View 9 Replies View Related

SQL 2005 -- Export Table To A Fixed Width Flat File -- Posting Again

Dec 7, 2006

I am sorry, I am posting this message again, since I did not get anyreply.I want to export a table into a "fixed width" file using SQL 2005import export wizard.This is the version I have:SQL Server 2005 - 9.00.2047.00For some reason it joins all the rows together. For EX: if the tableis like this:Create table Mytable (col1 varchar(50) null, col2 varchar(60) null,col3 varchar (100) Null)Insert into MyTable values ("abcdef", "12345", "8900")Insert into MyTable values ("xxxxxxx", "11111111", "22222222")Insert into MyTable values ("yyyyyyyyy", "5555555555555555","6666666666")Insert into MyTable values ("abcdef", "12345", "8900")Insert into MyTable values ("xxxxxxx", "11111111", "22222222")Insert into MyTable values ("yyyyyyyyy", "5555555555555555","6666666666")It is not exporting every row in a single line. Actually if I open itin "Ultra Edit", it is all in one line.I used to do this regularly with SQL 2000 import export wizard and itexported every row in one line.I looked at the setting:The header row delimiter has {CR}{LF}Code page has 1252 Ansi-Latin.In the Advanced tab:String:dt_str.I tried changing the header row delimiter to just {CR} or just {LF}.Also I tried changing the string to dt_text and nothing seems to help.Please help.Thank you

View 1 Replies View Related

SQL 2012 :: Applications Cannot Connect Because Logins Cannot Connect To Their Default Databases

Oct 17, 2014

I designed the AlwaysOn wrong, but every time we fail over from primary server to another server, my applications cannot connect because the sql logins cannot connect to their default databases. Once I run the command to link the login with the user in the default database then the users are able to connect. Did I do something wrong when designing AlwaysOn?

View 9 Replies View Related

Connect To Object Explorer But Cannot Connect To Integration Services.

Mar 9, 2006



I try to import my SSIS packages which are created using the Business Intelligent studio into SQL server 2005 but I cannot do that.

I am running SQL server 2005 enterprise edition.

Also when i tried to connect to Integration services using Object explorer, it only prompt me for server name. I cannot change the username and password which is disabled.

Then how am i supposed to connect to Integration services on a server in this case?

View 4 Replies View Related

Cannot Connect W/ Java App But Can Connect W/ .Net App - SQL Server Express 2005

Dec 12, 2006

I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).

The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.

SQL Server Express 2005 is installed in mixed mode.

Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.

These are my values in my Java app web.xml -

<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.

And yes, the port is 1055 - I checked to find it.

I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).

Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?

View 7 Replies View Related

Connect By DSN

Sep 5, 2006

Hi, how can i connect MSSQL through System DSN. i know how to create DSN. but i don't know how to code the connection string. regards, 

View 1 Replies View Related

Connect To The DB??

Nov 21, 2007

Hi,
I am a beginner in asp.net so sorry for my question ..
I want to make the event for the button when clicked , inside this event I will be transfer the value of dropdownlist into the DB by use ( WHERE ) condition ..
My question is :
- how I write the connection to the DB ?? is this a connection statement in the web.config ?? or what ?? because it generate an error by this code.. SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection("Data Source=-SQLEXPRESS;Initial Catalog=2C2Mdb;Integrated Security=True");
SqlCommand cmd = new SqlCommand();cmd.CommandType = System.Data.CommandType.Text;cmd.CommandText = "INSERT Meeting (mSessionNO) VALUES (" + DropDownList2.selectedvalue + ") WHERE [HijriYear]=" + DropDownList1.SelectedValue ;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery ();
sqlConnection1.Close();
 
 
What is the proplem ???

View 3 Replies View Related

Best Way To Connect Sql

Apr 28, 2008

HI,
May i know which is fastest and best way to connect sql with asp.net.I mean web.config appsetting or creat a class.vb throught public shared.
Thanks with best regards,

View 3 Replies View Related

CANNOT CONNECT

Jun 13, 2008

I have atlast installed SQL Server 2005 on Vista. However, when I try to connect using Database Engine as Server type, I get this message:===================================Cannot connect to MY-MACHINE-NAME.===================================Login failed for user 'My-Machine-NameUsername'. (.Net SqlClient Data Provider)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476------------------------------Server Name: MY-MACHINE-NAMEError Number: 18456Severity: 14State: 1Line Number: 65536

View 1 Replies View Related

How To Connect?

Jun 21, 2008

I have created DSN connection for sql server database. Now How do I connect to database through code and open the table for retriving and saving records?

View 3 Replies View Related

I Don't Know How To Connect With Ms Sql

Jan 2, 2006

Hello,

View 1 Replies View Related

Can&#39;t Connect

Aug 20, 2001

I need help on SQL Server 7.0 on connection to the server. The error message is "General Network error, Check your network documentation, ConnectionOpen(Connect)" when I try to add SQL server registration.

I was able to the server but occasionally I couldn't able to connect to the server. Does anyone knows what I should do to fix the problem?

Thanks,
Neal

View 1 Replies View Related

Cannot Connect To SQL

Jan 20, 2000

When trying to connect to SQL Ent. Mgr., got an error message:

A connection could not be established to [servername] - cannot open user default database '<ID>'.
Using master database instead.
Please verify SQL Server is running and check your SQL Server registration properties...

I have not seen this message before. There is one server and 4 PCs. All worked fine before.
Now one PC connects, three - don't. Did not see anything unusual with the registration properties;
All users show in [servername]/security/logins. Did not notice anything relevant in the
"DBA survival guide".

Will appreciate any advice

View 1 Replies View Related

Connect With Asp

Feb 21, 2008

how to connect ASP with sql server

View 1 Replies View Related

Cannot Connect.

Nov 7, 2001

Hi there,
We just upgraded our webserver from NT4 to W2K and I now cannot connect from my desktop SQL Server client to the new SQL Server 200 in order to export data to the new database.
I just get the error "timeout expired".
What things should I be looking at to resolve this problem?

View 1 Replies View Related

Can't Connect To DB Using ASP

Oct 19, 2004

I am trying to connect to a SQL Server 2000 database using VBScript on an active server page, but I can't connect. I think my SQL Server may be set up wrong in the security settings.

I have my authenication set to Windows Authenication Only, and I have an "sa" account with a password.

Here is my code:


Code:



<%
dim objConn
dim sqlCmd
dim FromWebPage as string
FromWebPage = "FromWebPage"

'create connection
objConn = Server.CreateObject("ADODB.Connection")

'connect to the SQL Server db (local machine)
objConn.ConnectionString = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=(local);DATABASE=SteelBoard;UID=sa;PWD=password;"
objConn.Open

sqlCmd = "insert into TestTable (FirstName) values ('" & FromWebPage & "')"

'put data into database
objConn.Execute(sqlCmd)

'close the connection
objConn.Close
objConn = nothing
%>

View 1 Replies View Related

IIS/MS SQL/ASP... Can't Connect

Mar 27, 2004

I have an ASP script with the following code in the global.asa:


Application("DBConnectString")="DSN=Test_Server;UID=Michael;PWD=xxxx"


But I get the error:


Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/TheResort/i_asputils.asp, line 8


Problem:

I setup the ODBC portion and it correctly saw the MS SQL server, and the test connection worked fine. Yet when I ever I enter that ODBC name "Test_Server", and the password of the Win XP Pro user I am signed in as, it fails to connect.

How can I be sure what domain,user,password I need to enter?

View 1 Replies View Related

Cannot Connect

Apr 7, 2004

Hi Group,
I get the following error when I try to connect to SQL Server 7.0 (Beta Version) from my ASP page. I'm using this for testing purposes.

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/CheckLogin.asp, line 27


Line 27 in CheckLogin.asp is:objConn.Open strSecurity
Here is my connection string:
strSecurity = "DSN=Operations" This is in an .inc file.

Am I missing something?
I've tested the DSN connection and it is OK. I am using TCP/IP as opposed to named pipes.

TIA

View 5 Replies View Related

Connect To SQL

Feb 24, 2006

Hi,
I have installed The SQL server 2000 on my local computer without being connected to the server.I have a visual basic form and I want it to be connected to my SQL server database(which is in my local computer).
What's the code that enables me to connect my visual basic form to my SQL database?
Thanks in advance

View 1 Replies View Related

Can Sql 2k5 Connect To Sql 2k

Mar 17, 2008

Hi,

this is probably a really dumb question... but can sql server 2005 management studio connect to a sql 2000 database remotely ?

sorry its probably a really dumb question... but i cant figure out why mine wont connect.

View 2 Replies View Related

How To Connect Using C#

Jul 23, 2005

HiI'm trying to connect to a MS SQL Server using ASP.NET / C#. I'vealready got some VB code that works but I'm unable to translate it toworking C# code. Can anyone help me out?Working VB code:Dim ConnConn = CreateObject("ADODB.Connection")Const ConnectionString = "DSN=dsn_name;database=database_name"Conn.Open(ConnectionString, "user_name", "password")Not working C# code:string ConnectionString = "Initial Catalog=database_name;" +"Data Source=dsn_name;" +"User ID=user_name;" +"Password=password;" +"Integrated Security=SSPI;";SqlConnection Connection = new SqlConnection(ConnectionString);Connection.Open();Connection.Close();

View 3 Replies View Related

Connect Via Ip Not Name - Why?

Jul 23, 2005

HiMy colleague has set up MSDE on his machine. I am only able to connectto his machine via IP and not servernameWhy is this? I want to use ACCESS as a fornt end and can't useing IPaddressJerry

View 2 Replies View Related

Can't Connect

Sep 19, 2005

Win 2000, sqlServer 2000 Personal editionTrying ot connect using .asp Vb Script1. Sql server set to use Windows Authentication2. Log onto Windows 2000 as Jim Bunton {no password)3 Server 'Study' running ok4. sql query analyseri. "SELECT User_Name > dboii. [using database NorthWind]"SELECT * FROM Customers" > gives expected result5. VB script** BEGIN CODE connect.asp ***<%@ LANGUAGE="VBSCRIPT"%><%Option explicitresponse.expires = 0%><!-- #include file="adovbs.inc" --><html><head><title></title></head><body><%dim Cn, CnStrSet Cn = Server.CreateObject("ADODB.Connection")Cn.ConnectionTimeOut = 1Cn.provider="sqloledb"response.write "Conn Provider is " & Cn.providerCnStr="Data Source=Study;Initial Catalog=Norhwind;UserId=sa;Password=;"' Tried all sorts of user id's and paswords'CnStr="Data Source=Study;Initial Catalog=Norhwind;User Id ='Jim Bunton';Password=;"'CnStr="Data Source=Study;Initial Catalog=Norhwind;User Id=dbo;Password=;"'CnStr="Data Source=Study;Initial Catalog=Norhwind;User Id =JimBunton;Password=;"'CnStr="Data Source='Study';Initial Catalogue='Norhwind';User Id='StudyJim Bunton';Password=;"%><p>----------</p><%response.write "Cnstr = " & CnStr'ERROR ALWAYS OCCURS ON NEXT LINECn.open CnStr'Error Type:'(0x80004005)'Unspecified error'/myweb/mywebs/connect.asp, line 35%><p>----------</p><%response.write "The End - ran ok"%></body></html>**** END CODE *****? what to do???? am I missing something 'obvious' out ???--Jim Bunton

View 1 Replies View Related

How To Connect *****!!!!!!!!???????????

Mar 19, 2007

How to connect With sql server database with C# forms.....

View 5 Replies View Related

Could Not Connect To SQL.

Feb 16, 2007

When i am trying to create a new database project in VSTE DB Prof and say finish an error is thrown saying "WHEN CONNECTING TO SQL SERVER2005, THIS FAILURE MAY BE CAUSED BY THE FACT THAT UNDER THE DEFAULT SETTINGS SQL SERVER DOES NOT ALLOW REMOTE CONNECTION". I have checked all services and started all the required ones.I am also using a local connection, i am trying to connect to the database on my system.How to handel this error?

View 1 Replies View Related

How To Connect From Asp

Dec 25, 2006

How do I connect to sql server express from asp.

to sql server I would do as follows but this is not working with sql server express

<%
Dim objconn ,mserver,dbName,UserID_db, PassWD
Dim strCon
Set objconn=Server.CreateObject("ADODB.Connection")
mserver="iphere"
dbName="dbname"
UserID_db="login"
PassWD="password"
strCon="Provider=SQLOLEDB.1;Data Source=" & mServer & ";Initial Catalog=" & _
dbName & ";User ID=" & UserID_db & ";Password=" & PassWD & ";"
objconn.Open strCon
response.write "opened"


%

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved