Connecting SQL Server2000 Using Static IP Over Internet
Sep 27, 2007
Hi Everybody
I am having same problem. I am trying to connect my vb6 application with SQL Server 2000. My database is on database server machine which has ID ADMIN and SQL Server is using default instance. Database instance name is DBPIMS. When I try to connect this database within any machine of LAN, it is working fine. But If I want to connect from my home or some other place through internet, it is not cannecting database to database.. I've 2wire router installed at my office. & I've done port forwarding for port 1433. Also I've one static IP which I am using for connection. My connection string is
"Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User ID=xxx;Initial Catalog=<atabase instance name;Data Source=" & static IP addres
But it couldn't get connected to database. Please can anybody help me. I am in urgent need to solve this as its been since long I am trying find its solution.
Thanks in advance
View 1 Replies
ADVERTISEMENT
Sep 23, 2006
hello,
we are learning sql2000 at school. i have been put in charge of trying to make it possible for the students to connect to the sql database from home.At the college they connect via a lan. Can anyone give me a way to do this, or is there a way. There are 30 students who will need to connect not all at the same time. Besides buying something like pcanywhere is it possible and how. I would really appreciate it. thanks again, tom
View 2 Replies
View Related
Jun 1, 2008
I have just started on SQl Server and C# and was wondering if the following is possible.
Using a Windows application, is it possible to connect to a database held on another computer via the Internet? I am not talking about a local network / domain whatever.
What I am really asking is can you use the IP address of a 'real' remote computer in the connection string or is it done some other way?
John
View 1 Replies
View Related
Jul 22, 2015
We have a bought in application written in Visual Basic 6 using ADO 2.7 to connect to SQL Server. The application has two connections strings and uses internal logic to determine which of the two connection strings connects to a read-write database. It does something as simple as trying an update that makes no changes to a very small table somewhere.
Previously this application connected to a Mirrored Database hosted on two Windows Server Failover Clusters and SQL Server 2005.For the future the App will be connecting this application to a SQL Server 2014 Availability Group.The Availability Group is made up of four servers, in a cluster, two at one site on Subnet A and the other two at a second site on Subnet B. The Availability Group has been given a Listener with a DNS name of AGLISTEST on port 1433 with two Static IP addresses, one for each subnet.
Our Contractor has configured the Application’s connection strings to connect to the two Static IP addresses assigned to the AG. He is of the opinion that although ADO has zero understanding of an Availability Group, at least one of the Static IP Address will translate to the Availability Group primary server because it is a Cluster Resource and so act like a Cluster IP Address on Windows Server Failover Cluster; i.e. sort of mimicking the previous configuration. This does work and he has demonstrated it, however I can’t find any article that proves to my satisfaction this is intended behavior not something that accidentally works. If it is accidental behavior then that would be something that might stop working at an unexpected point in the future.
All the research I have found relates to connecting to the AG Listener name, and all the multi-subnet issues and Active Directory issues that go with connecting using what is a legacy client.So; the question is, is this translation / redirection of static IP Addresses assigned to an Availability Group listener documented and safe?
View 3 Replies
View Related
Jul 23, 2005
I know it is possible to establish a connection to an SQL Server overthe Internet via Enterprise Manager. My question is, how secure is thisconnection? Is there a best practices document for this type ofconnection?Here is my scenario:We are looking to outsource our web hosting. Currently, we uploadclient sensitive data to our SQL Server databases within our internalnetwork. If we outsource, the SQL server will be on a differentnetwork. We are behind a firewall here and the dedicated hosted SQLServer will also be behind a firewall. Is the Enterprise Managerconnection succeptable to hackers? If so any reccomendations on how toaccomplish this would be appreciated.Another scenario is connecting to the SQL Server through a DSN. Canthis be accomplished from inside our network to outsourced server? Howsecure would that connection be?Thanks in Advance.
View 5 Replies
View Related
May 14, 2008
Hi,
I'm currently writing a desktop application that communicates directly with a SQL server database on the local network. Ideally we'd like to connect directly to the database via the Internet.
- connecting via the Internet is important because we want easy access from anywhere.
- directly is important because fast data transfer is a requirement.
Not knowing much about the security implications of such a connection, I thought I'd ask here. So what are the major risks and objections? Can the connection and data be made secure?
Cheers, Gavin
View 2 Replies
View Related
Apr 3, 2008
***PROBLEM***
Slow connectivity while connecting SQL server through internet (TCP port) using vb6 program
- Connecting a Database via VB 6 program : Very Slow speed
- Data Entry : medium speed
- Report generation : slow speed
***SERVER CONFIG***
- Intel Core 2 Duo, 2 GB RAM, Windows 2003 Standard with SP 2
- Sql server 2000 with SP4
- 2 Ethernet card. 1 connected to Broadband another with local network
- Database size 2.5 GB
- Internet: Broadband 1Mbps (upto 8 Mbps)
***CLIENT CONFIG***
-Intel P4, 256 MB RAM, win XP SP2
- Internet: 256 Kbps (upto 2 Mbps)
- There may 2 to 3 client connect simultaneously via internet and about 20 clients connect through local net work
* Web sites opening fast, downloading of other files are also fast, why SQL connectivity is slow???
View 4 Replies
View Related
Jun 9, 2005
I have set up an MSDE SQL Server in my Win XP Pro PC and am able to connect to it on the host PC, and over my LAN. However, when I try to connect to it over the Internet my connection is refused with the following message:SQL server does not exist or access denied. ConnectionOpen (Connect())Some background:I have router/NAT firewall and have opened port 1433 (I have even tried a DMZ to the SQL Server machine). The Router is definitely going to the SQL Server PC! I am fairly certain that the connection string is correct.Any help would be most gratefully received.
View 7 Replies
View Related
Feb 22, 2006
I'm using Delphi 2006 to create a DLL which will be integrated into SQL 2005. It's been a long road and I've made a lot of headway, however I am currently having the following problem creating the stored procedure:
My dll name is 'Crystal_Reports_Test_01'
In the DLL, my class is named 'Class01'.
In the DLL, my procedure is named 'TestMe'
I've managed to integrate the DLL into SQL using the following statement:
CREATE ASSEMBLY TEST_ERIC_01
AUTHORIZATION dbo
FROM 'c:mssqlassembliescrystalreports.dll'
WITH PERMISSION_SET = UNSAFE
I am attempting to create the stored procedure which points to the 'TestMe' method inside of the DLL. FYI: 'CrystalReports' is the namespace above my class that I had to add in order to get it to locate the class. The following code is used to create the stored procedure:
create procedure dbo.Crystal_Reports_Test_01(
@Parm1 nvarchar(255)
)
as external name TEST_ERIC_01.[CrystalReports.Class01].TestMe
But I get the following error:
Msg 6573, Level 16, State 1, Procedure Crystal_Reports_Test_01, Line 1Method, property or field 'TestMe' of class 'CrystalReports.Class01' in assembly 'CrystalReports' is not static.
I'm not sure what this means exactly. I think it means the method (the procedure) is not using Static method binding but should be. I have no idea what this really means or how to accomplish this in the DLL - or if I'm even going about this in the right way.
Any help would be appreciated ! I'll post the Delphi code (DLL) below.
Thanks,
Eric Gooden
library CrystalReports;uses System.Reflection, System.Runtime.InteropServices;...................type Class01 = class public procedure TestMe([MarshalAs(UnmanagedType.LPWStr)] var sVarString: wideString); export; end;procedure Class01.TestMe([MarshalAs(UnmanagedType.LPWStr)] var sVarString: wideString); export;begin sVarString:= 'Lets change the value and see if the stored proc. gets the change.';end;end.
View 4 Replies
View Related
Aug 27, 2007
When I try to install MS SQl server2000 on windows XP machine,it says the server component is not supported by OS.What should I do to get it run on my machine?
View 3 Replies
View Related
Feb 3, 2008
Hi,
I'm Arash Baseri a Sql Server2000 developer and mail you from Dubai (U.A.E). I have a problem in Sql Server locking table. My problem is not reasonable so the more I researched the more I understand it is not my problem .it is a bug in Sql Server2000.
Now I explain the situation:
I have two tables (Table A and Table B).Table A has a clustered index on col1 and col2, Table B has a clustered index on col1 and col2. I join these tables and update col3 in table A, like this
begin tran
insert [Table A]
select * from Arshiv_Master where Col1 between 26001 AND 26001
Update AI31 set Col3=Case
when 1=1 then 1
Else 0 End
From [Table A]AI5, [Table B]AI31
where AI5.Col1=AI31.Col1 And AI31.Col1 Between 26001 And 26001
/* intentionally I didn't rollback or commit transaction to hold locks on table*/
In another connection I execute this query and I face "Lock request timeout period exceeded" error message.
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 60000
Now the most interesting part is here .when I use a smaller data range for Col1 no error message is shown. A query like this
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 50000
As you see the difference between the last two queries is on WHERE clause especially on data rages of Col1.
As you know Sql Server 2000 has row level lock and when I acquire a lock on a record the other records are free. So what's wrong with Sql Server that assumes the others records are locked. I tested this situation in Sql Server 2005 and this problem was not seen so I think it's a bug in Sql Server 2000.Who can help me about this problem?
View 1 Replies
View Related
Feb 2, 2008
Hi,
I'm Arash Baseri a Sql Server2000 developer and mail you from Dubai (U.A.E). I have a problem in Sql Server locking table. My problem is not reasonable so the more I researched the more I understand it is not my problem .it is a bug in Sql Server2000.
Now I explain the situation:
I have two tables (Table A and Table B).Table A has a clustered index on col1 and col2, Table B has a clustered index on col1 and col2. I join these tables and update col3 in table A, like this
begin tran
insert [Table A]
select * from Arshiv_Master where Col1 between 26001 AND 26001
Update AI31 set Col3=Case
when 1=1 then 1
Else 0 End
From [Table A]AI5, [Table B]AI31
where AI5.Col1=AI31.Col1 And AI31.Col1 Between 26001 And 26001
/* intentionally I didn't rollback or commit transaction to hold locks on table*/
In another connection I execute this query and I face "Lock request timeout period exceeded" error message.
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 60000
Now the most interesting part is here .when I use a smaller data range for Col1 no error message is shown. A query like this
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 50000
As you see the difference between the last two queries is on WHERE clause especially on data rages of Col1.
As you know Sql Server 2000 has row level lock and when I acquire a lock on a record the other records are free. So what's wrong with Sql Server that assumes the others records are locked. I tested this situation in Sql Server 2005 and this problem was not seen so I think it's a bug in Sql Server 2000.Who can help me about this problem?
View 1 Replies
View Related
Oct 11, 2001
HI,
I have a application which has Access as Front end and SQLServer as BackEnd.
I have a table which has student details.
Table Fields are:
Record#,FirstName,LastName,MiddleName,Address,City ,State,Pin,.....
The table has about 1200 records.
Every Thing works fine but in the front end when i try to do a search by
FirstName it is VERY SLOW.But it is okey if i search by the Record#.
I need to search by lastname or Firstname and speed up the process.
Any Help will be appreciated,
Thanks,
Rang.
View 1 Replies
View Related
Apr 5, 2001
What are the experiences of those who have upgraded to
View 2 Replies
View Related
Apr 5, 2001
What are the experiences of those who have upgraded to SQL Server 2000?
I am writing a paper for my company and wish to list features of SQL Server 2000 from a user/developer/business aspect. We are on
SQL Server 6.5 and I need to highlight the advantages and disadvatages of upgrading.
Thanks
Jeff
View 7 Replies
View Related
Jun 11, 2001
Hi everybody,
I configured Logshipping in sql server 2000(Enterprise edition).in destination server copy and restore is failing(but there is no error).Out ofsync threshold value is set 27 minutes, after 27 minutes i found the error message in sql server error logs "The log shipping destination HARSHA.Northwind1 is out of sync by 27 minutes..
Any body help me
View 2 Replies
View Related
Aug 27, 2004
Hi gang,
Just trying to get some information on what is required to migrate from Access 2000 to SQL Server?? Is it pretty difficult to do? Are there any changes to the data or structure that is needed? Is SQL Server more secure? What about MSDE instead of SQL?? I'm just needing some tips and info on what to expect and all as I think we are going there kinda soon. I can do many things in Access but not sure how to go about them in SQL Server? Can you also do reports from there as well?
Inquiring mind wants to know
have a nice one,
Bud
View 3 Replies
View Related
Dec 18, 2006
There is a Server with 4G Memory. I installed a SQL Server 2000 standardversion on it.I heard that SQLServer2000 could use only up to 2GB memory. Is it true?How can I use those 4GB memory? I can not upgrade to SQL Server 2005 orother version because i don't want to take this risk.Thank you very much.
View 8 Replies
View Related
Oct 31, 2006
Hi, Is it possible to use ssis for the etl processes and still have an existing 2000 db? For e.g. CanI create a ssis pkg and use the xml task to download data to a 2000 db.
View 4 Replies
View Related
Jan 18, 2005
HI,Thank you to pay attention to this thread.i am chinese,may be i coudln't say my problem clearly,it's.....
okay,i use the TextBox,SQL Server 2000,i fill the TextBox as Chinese,then,I use the T-Sql INSERT to Finish Inserting A record,but when i open the SQL Server 2000,i find that the char showed in field as the char '???',i don't understand what happened,if the fault of UnicodeEncoding?can you help me? Thx~!
View 4 Replies
View Related
Feb 3, 2005
dear sir/madam,
i have to create a cube in analysis manager in sql server 2000.as i want to see the data according to my organisation levels.
organisation level:
1.Business unit
2.Team manager
3.Sales manager.
and also i create the three user respectively and assign all user has adminstrator category in user accounts of windows XP.
after create the user and design the manage role to restrict the levels which i have create the dimension.after login which i have to create the user i can see all levels of data.
so pls solution for see data which i have to restrict the dimenssion only..
thanks
kesavan
View 1 Replies
View Related
Nov 16, 2001
HI
I have a big problem with SQL server2000. I can't get COLUMN DESCRIPTION.
I will print DATADICTIONARY from a DB, I can get all elemnts (table name, columns name, datatype, precision, scale, FK, PK, default value..) I missed only DESCRIPTION. How I can get it????
Medo
View 1 Replies
View Related
Mar 2, 2001
Please Help me on this.
I installed the two instances SQL on one box. ONe is default instance called ACSQL1(actually machine name) and the other one is called ACSQL1/DEVELOPMENT. THrought the my client site of SQL 2000 I can access both instances. When I try to get connection from VB. I can access the default instance but I can not access the second instance. Any ideas about this???
Qun Lu
View 2 Replies
View Related
Jan 19, 2003
Hi,
I am new in SQL SERVER.I wanted to setup high availability database.It would be great if any one could answers my questions please.
-What are the options availability for HA except clustering?
-How to set up log shipping HA ?
-How to monitor log shipping?
-Is standby DB and log shipping same ?
-Can I setup log shipping without backup/restore method.Like I have to create db1 on server A and create db1 on server B and then configure log shipping?
-Is it necessary to ship log for master database or only user Database?
Thx
-Blace
View 1 Replies
View Related
Feb 1, 2004
I want make setup cd for my program and i use visualbasic 6 and SQL Server 2000 .
What i should make and include my setup file to make it work with any one install it in his computer and we assume he dont have SQL Server2000 in his computer .
Please help me on that
Should SQL Server 2000 must alreeady installed on his computer?
If its must be installed,Is there any way to make it easy through my setup file to make it install sql server automatic ?
Can i make my program in visual basic create database and tables and relations and so.
Please help me on that becuase its too Important.
Thanks.
View 1 Replies
View Related
Oct 14, 2006
Hi,
I want to install the sql server2000 analysis service.Can you please tell me the website from which I can install that.
View 2 Replies
View Related
Aug 14, 2004
Hello,
Can anyone please tell me the best way to upgrade server1 with SERVER7 and OS of NT to a new server2 with SERVER2000 AND WINDOWS 2000 ?
The data in the old server is very important.
Thanks
View 2 Replies
View Related
Sep 18, 2006
Hi,
I'm wondering if anybody can help me. I have to restore the database from the backup sent by vendor. Backup itself (backup_0906 file) is 60 MB. Below is a statement I run:
RESTORE DATABASE PDMUpload
FROM
DISK = 'e:ftpdirackup_0906'
WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY ,
REPLACE ,
MOVE N'PDMUpload_Data' TO N'E:MSSQLDataPDMUpload_Data.MDF',
MOVE N'PDMUpload_Log' TO N'E:MSSQLDataPDMUpload_Log.LDF'
I get the following error messages:
Server: Msg 3257, Level 16, State 1, Procedure RestoreUpload, Line 9
There is insufficient free space on disk volume 'E:' to create the database. The database requires 28181331968 additional free bytes, while only 6759866368 bytes are available.
RESTORE DATABASE is terminating abnormally.
If anybody can explain why DB needs 28 GB???? BTW, there is 6 GB of diskspace available on E: drive.
I appreciate any help.
View 6 Replies
View Related
Aug 20, 2007
Thanks for the invitation to post a question, so I will post one.
I need to create a job step that uses cmdExec.
This is the command line I entering:
D:odbcTimeClockUpdatesinReleaseTimeKeepingNo nLogouts.exe
When I run this job the job fails. When I look at the job history, the only information I get is the date and time, user that ran the job and the fact that it failed. I haven't been able to get any CmdExec job to run at all. Can anyone tell me what I'm doing wrong?
Facts.
1. This exact same command is used by my network administrator using windows scheduler on the server. The only reason he wants me to create an sql server job is because it's mostly sql functions.
2. I know the Sql Server agent is running, because I have other jobs that are run.
3. I have verified that I have permission to run the file because I can go to the actual directory and run the exe.
4. Do I need to enclose my command in quotes i.e. “D:odbcTimeClockUpdatesinReleaseTimeKeepingN onLogouts.exe”
5. the path of the file I need to run is the path on the server and not the path on my local machine.
If you need any other information, please let me know
Thanks for you help
GEM
View 7 Replies
View Related
Feb 27, 2008
Hello Everybody,
I am importing an csv file into Sql Server straight forward no data cleansing or anything and i noticed everyday it misses the last row in the CSV file.
Has anybody come accross this if so is there anything that i can do to get that row.
ANY HELP ON THIS IS GREATLY APPRECIATED.
Thanks In advance....
View 5 Replies
View Related
Sep 12, 2006
i have 10 to 15 records in my recordset object. i have to insert all these records in one call to the server instead of calling 15 times.
i am new to sqlserver. please give me a solution with code.
View 10 Replies
View Related
Dec 5, 2007
hi
at my work place some of the users migrated to another domain even thought with new domain name they can access SQL Server but user who are part of sysadmin(part of some group) on the box unable to execute a job. it means at operating system level newdomainuser credentials are get resolved that's why users are able to access box but why not able to execute jobs. why sysadmin Privilege not get resolved at SQL Server level very confused............
View 7 Replies
View Related
Jul 20, 2005
I have a database that had worked under msde 1.0 until reached the 2GBof dimension and the dB was blocked. To make possible the work i haddeleted old data from some table. The database restart, but theanswers from server become very slow. So i decided to pass to SqlServer 2000 without success. May i perform a check of this database?if is a indexs problem there is a way to rebuild them?Thanks in advanceAndy Wet
View 1 Replies
View Related
