|
Hi Folks
I wonder if anyone has any ideas that could help me. I've written an application in VS 2005. I use Inno Setup for Installation, which I have used previously with success.
When I go to install the program on another machine I get the following 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: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)
I've checked my Sql Area Configuration and can confirm that I allow remote connections although via using TCP/IP only and have also tried TCP/IP and named pipes.
I've checked the SQL Browser and this is also running.
I've checked my Connection strings and these are fine.
Can someone help please?
Thanks alot.
Kris MCP
|
|
|
|
|
|
Hi Still no go I'm afraid.
I went to IP Addresses and checked all enabled. I've kept it so I can enable Dynamic ports as a little unsure of this. 
Kris MCP
|
|
|
|
|
Any firewall between the servers?
|
|
|
|
|
Hi
There shouldn't be. I've been into the Windows Firewall and put all SQL to be allowed under exceptions.
Kris MCP
|
|
|
|
|
hi, I'm practicing how to use sql language in vb 6.0 via ADODC. I'm getting problem with adding a data in INSERT INTO statement. Because my code in the command buttons is just...
Adodc1.RecordSource = "INSERT INTO tblname(firstname, lastname) VALUES('" & txtfname.Text & "','" & txtlname.Text & "')"
but the data in the textbox are not saved in the data base...
can you help me please.
|
|
|
|
|
Did you try with Connection object
myConn.Execute "INSERT INTO tblname(firstname, lastname) VALUES('" & txtfname.Text & "','" & txtlname.Text & "')"
OR also you can it with Command object
OR
Try your way
Adodc1.RecordSource = "INSERT INTO tblname(firstname, lastname) VALUES('" & txtfname.Text & "','" & txtlname.Text & "')"
Adodc1.Refresh
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
i've tried the
Adodc1.RecordSource = "INSERT INTO tblname(firstname, lastname) VALUES('" & txtfname.Text & "','" & txtlname.Text & "')"
Adodc1.Refresh
but there was an error saying "Operation is not allowed when the object is closed" . what should i do?
|
|
|
|
|
Do you have an open connection to the database? Doesn't sound like it from that error message.
|
|
|
|
|
how can I open the connection to the database??
|
|
|
|
|
(1)
Before going to execute any query first check your database connection is open or close.
(2) Did you try with connection object :
myConn.Execute "INSERT INTO tblname(firstname, lastname) VALUES('" & txtfname.Text & "','" & txtlname.Text & "')"
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
yup, I've tried it and it worked but I've also change my data base connection using stored procedure.
Thanks for the help. 
|
|
|
|
|
I am not getting this point : "but I've also change my data base connection using stored procedure" ?
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
Instead of using the ADODC. I've changed the connection to this
Private nameConn As ADODB.Connection
Private nameCMD As ADODB.Command
Private nameRST As ADODB.Recordset
Private Sub ConnectTODB()
Set nameConn = New ADODB.Connection
nameConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\meki\meki training\dbnames.mdb"
nameConn.Open
Set nameCMD = New ADODB.Command
Set nameCMD.ActiveConnection = nameConn
End Sub
so that the nameComm.Execute command will work.
|
|
|
|
|
Oh! Good
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
Hi all
in sql2005 when u create table and make a primary key column in the table sql automaticaly make on this column clusterd index
my question is i want to make a composite clusterd index which contain the primary key and another columns
when i make that as all know i meet the problem say there is one clusterd index in the table so i can't create another one ......
and when i delete the primary key and make the composite clusterd index it work but i want to recreate the primary key on the one spacifed column
when i make that sql told me it'll remove the latest composite clustered index to make the primary key as clustered index
how can i fix this problem plz
and thnx for advice
Kareem Elhosseny
|
|
|
|
|
What you can do is remove the primary key - make the (custom) clustered index as you want it - and then reassign the primary key.
This will make the primary key's index non-clustered and allowing you to have your custom clustered index.
|
|
|
|
|
Dear Alsvha
thnx for your advice at the first but i try wht u advice me but it not working when i remove the primary key and make the clustered index as i want then when i reassign the primary key sql remove the clustered index wht i
make before to create the clustered index for the primary key column
u can add me for more communication
kareem_elhosseny@hotmail.com
see u soon with my all greeting .
Kareem Elhosseny
modified on Sunday, June 8, 2008 3:13 AM
|
|
|
|
|
Haven't had that happen in any version of SQL Server 2005 I've worked with.
I've never had problems with creating a custom clustered index in that way. Are you sure you made the Clustered index correct and not accidentally selected "non-clustered"?
What happens if you script the creation?
<br />
CREATE TABLE [YOUR_TABLE](<br />
[YOUR_TABLE_DEFINITION]<br />
CONSTRAINT [YOUR_INDEX_NAME] PRIMARY KEY NONCLUSTERED <br />
(<br />
[PRIMARY_KEY_COLUMN] ASC<br />
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br />
) ON [PRIMARY]<br />
Do you get a non-clustered index now?
|
|
|
|
|
i want the player to show the first frame of my movie as preview image. Is this supported by the player, or do i have to build this myself with javascript?
pls help me?
|
|
|
|
|
And what does it have to do with 'SQL / ADO / ADO.NET'?
|
|
|
|
|
Random question that popped up on a Friday afternoon at work that nobody seems to know the answer to:
How is Distinct implemented in MS SQL 2000/2005? Does it screen every row it pulls in or does it pulls in the whole set of data then run distinct on it?
|
|
|
|
|
It runs distinct on the set before returning it from the query.
You can see this using execution plans.
|
|
|
|
|
How can I create RowID auto incremented while selecting datafields from table but RowID does not exist in table.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
SQL Server 2005
SELECT ROW_NUMBER () OVER (ORDER BY Column Name) AS Rowid FROM tablename
Where Rowid will retrieve the row number based on the columns.
Otherwise you a number table and join to that - and before you ask, try Google e
Bob
Ashfield Consultants Ltd
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
