How Can I Make Conect With Sql Server

Dec 12, 2005

In this code, I don´t know what is wrong.

<%

 Set conexao = Server.CreateObject("ADODB.Connection")
 stringconexao = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=username;Password=password;Initial Catalog=GeoSite;sdb=geocontrol;Data Source=128.2.1.158"
' Abro a conexão
 conexao.open(stringconexao)
dim mat
mat=1
   

  sql= "insert into sscusuar(cdmatricu,email) values ('"&mat&"','"&Request.form("cemail")&"')" 
  conexao.execute(sql)
%>

___________________
Edited by moderator SomeNewKid
Removed login credentials.

View 2 Replies


ADVERTISEMENT

Conect Via IP Not Server Name - Why?

Jun 16, 2005

Hi

My colleague has set up MSDE on his machine. I am only able to connect to his machine via IP and not servername

Why is this? I want to use ACCESS as a fornt end and can't useing IP address

Jerry

View 1 Replies View Related

Os Differs Can't Conect To The Other Server

Nov 29, 2003

i have installed winxp on one and win2k on the other. both r servers (msql7 desktop edition)

i want to see the other both the servers on one machine in EM but it does not show it in the ser registration list.

i have given sql server authentication in both.

help.

View 1 Replies View Related

Mirror Monitor Error: Server Replication Requires The Actual Server Name To Make A Connection

Oct 17, 2007

I'm getting the following error when launching the database mirroring monitor and attempt to connect to my database.


TITLE: Connect to Server
------------------------------

Cannot connect to dborat01.hs.pitt.edu.

------------------------------
ADDITIONAL INFORMATION:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'xxxxxx'. (Replication.Utilities)

------------------------------
BUTTONS:

OK
------------------------------

View 3 Replies View Related

Cannot Make Server As Target Server Or Link From Master Server

Jul 20, 2005

Sql Server 7 Standard EditionMy Server was renamed and the normal steps of reinstallingand running sp_dropserver and sp_addserver were followed.Everything seems to work fine but jobs from the master server.I did defect the server as a target server since it appeared as offlineanyway.On trying to re establish the status of the server as a target serverFailed to make "serverName" a target serverEnlist into Master Server "MasterServerName" Failed(Error 14262)Your insight is appreciatedVincento

View 3 Replies View Related

How To Make Sql Server 2000 Public On A Windows 2003 Server...any One Know?

Feb 14, 2008

set up windows 2003 serversql server 2000have public IP from netword soluctionsI can see websitewhat settings to i need to open up sql server to the public?

View 1 Replies View Related

Best Way To Make A Copy Of An Existing Sql Server Database To Another (physical) Server

Mar 9, 2007

Hello!
What is the best way to make a copy of an existing sql server database to another (physical) server?
Plan to make a full backup of another sql server database to another server. I've read about detach and attach
and copying the datafiles and log files but some say it is prone to data loss? Is this true?

And another thing, what if the existing sql server can't affor downtime for me to copy db files etc.?

Anybody here who have done the same?

Any help is very much appreciated.

Thanks!

View 3 Replies View Related

Can I Make Intall Sql Server 2005 As Server In XP Professional Edt.

Oct 23, 2007

I am Using Sql Server 2005 and XP OS Can i use sql server as a server by xp, if yes how? pls help

thanks in advance

View 3 Replies View Related

How To Make A SQL Server Connection With ASP.NET

Jan 18, 2006

Hi.Working with ASP this connection works:stringMyConn = "dsn=foo.com.bar;uid=john;pwd=xxxx;"set myConn = Server.CreateObject("ADODB.Connection") myConn.open stringMyConn But it doesn't with ASP.NETDim myConn As SqlConnection = New SqlConnection("dsn=foo.com.bar;uid=john;pwd=xxxx;")myConn.OpenWhat am I doing wrong? Thank you very much.

View 1 Replies View Related

How To Make A Linked Server To Mpp

Apr 12, 2007

please someone tell me how can i make a linked server to mpp file using the provider microsoft.project.11.0 oledb provider, i think there is a problem in such provider, i write the command

sp_addlinkedserver @provider="microsoft.project.11.0"

@product= "MPP"

@catalog="c: estmpp.mpp"

that create a linked server that shows all the tables in the mpp files, including tasks and so , but unfortuantly i can not select from it as it response that the it can get an interface for the provider "microsoft.project.11.0"

can anyone help me for such a problem

thanks

mostafas@horizonssoftware.com

View 1 Replies View Related

SQL Server 7 On Win 98 Machine Will Not Let Me Make A Connection.

Jun 24, 2001

Installed SQL Server 7 on Win 98 machine, keep getting errors:Unable to connect to server servername:

Server: msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

Did the troubleshooter on M$ Knowledgebase, still did not work.
Still get the above and this error:
General network error. Check your network documentation.
ConnectionOpen (connect())

Went to install SP3, and now It won't let me continue without an sa password.
I never had a password to begin with.

Oh, the fun of it all! :)

Any and all help will be greatly appreciated.

Thank You.

CZ

View 1 Replies View Related

How Do I Make My Access Db Into A Multiuser On A Server??

Mar 20, 2006

I been trying to split my database on a SQL Server but its almost impossible to split and make that multiuser. Other thing it is possible for a multiuser use the database in access without having the program on their computers just connecting to the server???

View 1 Replies View Related

Make A Copy Of SQL Server Database

Mar 13, 2007

I'm trying to make a copy of our 2005 SQL Server production database (25 meg) so we can install it in a new office being set up in another state. I have right clicked on the database I want to copy, selected Tasks, then option Copy Database... I'm trying to put the copy on the same server, and I am doing this work signed into the Management Studio as "sa" The wizard creates 5 steps, the first 4 run ok, then the 5th step runs for 10 to 20 seconds, then quits. The message says to look in the log on the server for the reason it quit. The only log I can find is the Error Logs at the bottom of the Object Explorer window. I look into the current log, then select the SQL Server log, the current one. There is only one line in here about the copy I just tried, and it only says "Starting up database XXXXXXXX" which is the database I'm trying to create through the copy process. Within Database Mail, SQL Agent, and Windows NT log lines, I can not find any reference to the copy job that just bombed. Needless to say, I'm VERY new to all of this SQL Server admin stuff. If someone could point me in the right direction, it would really help! Thanks!

View 2 Replies View Related

Challenge: Make SQL Server Run As Bad As Oracle

Apr 5, 2007

NEVER let anyone tell you that Oracle is faster than SQL Server:
http://www.dbforums.com/showthread.php?p=6265757#post6265757
So here is my challenge. What would you have to do to SQL Server to make it take 10 minutes to return a count from an empty table? Other than coding a loop that waits 10 minutes, of course.
I'm not sure it could be done.

View 11 Replies View Related

Make MS SQL Server Case-sensitive

Jul 20, 2005

I have already install my Microsoft SQL server 2000 as not casesensitive, how to I change it to be case sensitive?

View 2 Replies View Related

How To Make New Database Sql Server 2005!

Aug 29, 2006

i had no problems working whith sql server 2000
but whith 2005 i am unable to make new database!
question : HOW?
respond asap

View 1 Replies View Related

How To Make A Simple Database In SQL Server

Oct 22, 2007

Hi,
I am beginner developer, Creating simple application which will create, handle small database of genral store products (like adding products and substracting no. of products) . I am creating application with native win32 APIs in VS 2005.
Please suggest , how to create such data base , and suggest me link where i will get step by step knowledge to do (learn) it.
Do i need to learn ODBC or OLEDB or SQL server


Thanks

View 4 Replies View Related

Failing To Make Relationship Between To Tables Of SQL Server DB

Apr 27, 2004

Hi,

I'm trying to make relationship between two tables "reservation" and "charges". The column is "booking_ticket". Its giving me following error :


'reservations (akr)' table saved successfully
'charges (akr)' table
- Unable to create relationship 'FK_charges_reservations'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_charges_reservations'. The conflict occurred in database 'limp', table 'reservations', column 'booking_ticket'.


I used to make relationship before , but never found this problem.


Kindly guide me to solve it.

Regards,

View 1 Replies View Related

Make Http Request From Sql Server Database

Dec 10, 2007

I would like to make an http request from sql server database and store the data in xml type. What are the steps involved?

In Oracle it can be done pretty easily using utl_http procedure. Any suggestions would be appreciated.

Thanks,
Ramki

View 1 Replies View Related

People Wanted: Enroll Now To Help To Make SQL Server Even Better!

Apr 14, 2006

SQL Server Usability Enrollment

Your opinions count.

The SQL Server Design and Usability team invites you to spend a few hours with us and our products (SSMS, SSIS, SSAS, SSRS, BIDS and etc) and tell us what you think. We are interested in how you interact with the products. The information we gather is directly translated into product design improvements, so your feedback makes a difference.

We periodically conduct lab research on campus as well as site visits on various aspects of SQL Server. Your involvement is extremely valuable to us. If you are working with
administering SQL Server databases, building database applications, performing BI
related tasks - we'd like to hear from you.

Please take a couple of minutes to fill out the SQL Server Usability Enrollment form. Your contact information is extremely confidential and will only be used by our team for usability and research purposes. Thanks for your help to make the SQL Server even better!

Microsoft SQL Server Design and Usability

View 1 Replies View Related

Nuisance: Help Make Microsoft SQL Server 2005 Better

Jun 6, 2006

I work for a consulting firm. Customers are reporting being annoyed with the popup "Help Make Microsoft SQL Server 2005 Better". Some customers don't want to be bothered with this even once. Is there a way to keep this popup from ever appearing?

The customers are intelligent. They understand why the popup appears and what its purpose is. The only point to address is that the customers have paid for SQL Server, they are annoyed by this feature and they want a way to suppress it. I want to give the customers what they want. When customers tells me something is a nuisance, it's not my place to tell them they are wrong.

View 3 Replies View Related

People Wanted: Enroll Now To Help To Make SQL Server Even Better!

Apr 14, 2006


SQL Server Usability Enrollment

Your opinions count.

The SQL Server Design and Usability team invites you to spend a few hours with us and our products (SSMS, SSIS, SSAS, SSRS, BIDS and etc) and tell us what you think. We are interested in how you interact with the products. The information we gather is directly translated into product design improvements, so your feedback makes a difference.

We periodically conduct lab research on campus as well as site visits on various aspects of SQL Server. Your involvement is extremely valuable to us. If you are working with
administering SQL Server databases, building database applications, performing BI
related tasks - we'd like to hear from you.

Please take a couple of minutes to fill out the SQL Server Usability Enrollment form. Your contact information is extremely confidential and will only be used by our team for usability and research purposes. Thanks for your help to make the SQL Server even better!

Microsoft SQL Server Design and Usability

View 1 Replies View Related

How To Make Sql Server Data Case - Sensitive?

Feb 25, 2008

Hii



I transferred data from Oracle to sql server 2005. Now what i want is to make data in the tables case-sensitive .(it has to be data inside the tables only and not table and column names).
what i tried is :


alter database test collate Latin1_General_CS_AS

But to my horror it made the tables name case-sensitive .
Plz help me out asap.


Thanx in advance
Supriya

View 18 Replies View Related

How To Make A Diagram From Data In A SQL Server Table?

Dec 19, 2005

Hi all,

I´m a real SQL rookie and after two days of intensive research and reading of dozens of articles and web pages a bit confused about all that knowledge concerning database technology ... and I only want to do something very easy ...

Now, my question is, how can I produce a diagram from that data, that is stored in a table, maybe called "DiagData1"?

I have installed SQL Server Express 2005 and Visual Basic Express 2005 and did some first steps with it as where shown in an brilliant tutorial that I´ve found on a Microsoft (?) webpage. It shows the complete way building a database and connecting it to a form which was build with Visual Basic. So all what is left is find out how the database tables are connected to a diagram.

thanks´n greets,

  VBFan

View 3 Replies View Related

How To Make Select Query To Access View In Other Server

Mar 7, 2007

Dear All,
i am making small web application using asp.net, C# ,sql2000.
i want a about regarding how to access view or table from other server to local server. i have base database where there is a view which need to access in my database of local server.that is how to make select query to access view in other server Please help
thanks 

View 1 Replies View Related

SQL Server Make ASP.net Load Slower At The First Time From Localhost.

Feb 16, 2004

I dont know if it's just a beginner issue.

My ASP.net project with database connection inside, I mean DataBound or whatever the name is make my website load slower because there's a delay about 8 til 9 seconds when in its first load from localhost, after the first load my ASP.net project run very fast and it just take 1 second or less to reload.
The problem will show up again after I restart my computer and trying to load my project from localhost at the first time.
How do I make my ASP.net project to load very fast with just 1 second or less at the first time from localhost?

Thanks.

View 1 Replies View Related

How To Make Password Field Case Sensitive In Sql Server 2005

Jan 14, 2007

Hi, 
SELECT     UserID, UserName, Password, PublisherID, CurrencyFROM         [User]WHERE     (Password = 'Anitha') I am using the above mentioned it is working but int the password field i had given it as anitha. Now the querry is retriving the record for anitha, it shouldnot happen. The querry should retrive the record of anitha only for where condition anitha and not for Anitha or ANITHA etc..
 Thanks
Vishwanath

View 4 Replies View Related

How Do I Make An MSSQL 2000 Server Database Go Offline/Online Using VB 6

Jun 21, 2001

Does anyone know how to do this? I am in the middle of writing a server side program, and this is one thing that I cannot do without.

Also, if anyone can answer that, how do I do the same with an Exchange 5.5 Email account?

Thanks ahead of time!
Cash Coleman

View 1 Replies View Related

SQL Server 2014 :: Adding Alphabet To A Number To Make It Unique

Nov 25, 2013

create table #temp_Alpha_num (
[uniquenum] [int] Not NULL,
[Somenum] [int] Not NULL,
)
Insert into #temp_Alpha_num(uniquenum,Somenum)
values
(1,121)

[Code] ....

For the somenum column I need to add alphabets to make them unique. for example

121a,121b,121c....121z,121aa,121ab,101a and so on...

View 4 Replies View Related

SQL Server 2012 :: Make Excel Visible In Script Task

Oct 1, 2014

I am wondering if I can show the Excel window when the SQL server agent job runs. The SSIS package contains a script task that opens Excel and does some formatting. I just need to monitor the formatting of these Excel files.

View 2 Replies View Related

SQL Server 2008 :: How To Make Query To Calculate A Dynamic Formula

Oct 16, 2015

I have 2 tables, one of those table is master formula which has some records like this :

Table1: MasterFormula
NoDescriptionFormula
1Occupancy
2Leased
3Rate Consumed

[Code] ....

Table2: TransactionFormula
Only has 2 fields, No & Amount

the formula fields means, we sum the Amount from TransactionFormula table for each No., for example if the formula is [3]+[8] means, we sum the Amount from No=3 added with the Amount from No=8 and we added records on TransactionFormula for row 9

Here's the example result for TransactionFormula records

NoAmount
1100
2100
310
43
510
610
720
810
920[3]+[8]
1020[6]+[8]
1140[7]+[9]
121.2[4]*[11]/100
134.58([11]+{12])/9
1445.78[11]+[12]+[13]

View 5 Replies View Related

Can't Make A Connection To SQL Express As Server Does Not Exist Or Access Denied...

Aug 9, 2006

Hi

I have recently downloaded SQL Server Express which I have installed using Windows authentication mode. I cannot seem to be able to make a connection to SQL Server from Dreamweaver or Microsoft Visual Web Developer as I am getting an error Server does not exist or access is denied....

I am relatively new to all of this, so would appreciate any advice....

When I installed SQL Server Express I chose Windows Authentication. When I fire up SQL Express and view Security option - the installation program has set up an sa login with a random password. I did not set this password, but think this might be a reason why I can't connect. To rectify the problem I tried creating a new user in SQL Server Express with a password that I specified. On going in to check the settings, I notice SQL Server Express has gone and changed it from the password that I set up.

Now when I try and connect to SQL Server Express I specify the following in the connection paramaters

Server: BGIRLSQLEXPRESS

Database The database name that I've created

User: the new user that I created

Password: the password I created as part of new user setup

Now I get error message Server does not exist or access denied

Is the problem to do with passwords or perhaps one of the many parameters one seems to have to set up? How can I change a password if I didn't create it? Is there anywhere I can reset it?

PLEASE HELP - I have literally spent 3 days attempting to get this working and am about to give up entirely. Due to my lack of experience, I need very specific step by step instructions..









View 3 Replies View Related

I Need To Make A Minor Change To A SQL Server Script That Is In Production. Need Advice So I Don't Screw Something Up.

Mar 1, 2007

Hello. I am not very strong with SQL server. But I know enough to get my way around. The reason I am asking forhelp is that I need to change a SQL server script that resides on one of the production database servers of thecompany I work for. I just need to add two new lines to the stored procedure.(See the lines that are bolded.) Thesevalues are [MO_FAX],[MO_EMAIL].
Can someone tell me if there is a best way of going about doing this? Can I just simply open up SQL server and quickly make the change? The big issue here is that this script is used in production. So I am just a little worriedabout screwing something up. Anyway, I would appreciate some good advice on this?
 
 
/* Returns all data given the region and country */ALTER  PROCEDURE [dbo].[GetAllInfomration]
AS SELECT   [COUNTRY],  [Company_NAME],   [CompanyAddress],   [CompanyPhone],
  [MO_FAX]  [MO_EMAIL]
  [CompanyFax],
 FROM [InfoLookup].[dbo].[Company_Contact]  RETURN

View 5 Replies View Related







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