i need all of you help me. i want to conect sql server over internet from 1 country to other country using vb 6.
if can please show in example code?
thank for your help.
View Complete Post
Can VS 2010 connect to a SQL 2000 database?
I get this error while using the Data/Connect and SQL Server 2008 R2 comes up.
"The connection failed because this instance of SQL Server is not supported. The Editor cannot connect to SQL Server 2000 or earlier
Our production server is on SQL 2000
Are there any canned approaches to expose a database connection over the internet? I don't mean how to go about opening ports on firewalls to access database as if it was on the local LAN(already
know how to ). I also don't mean expose specific data like through a web service. The basic idea is to connect to something like a webservice url for example http://aa.aaa.com/con.db and i would have access to the same things i would have access
to as if i made a local connection object with a connect string, access to all tables, stored procedures, execute queries etc.
I would appreciate it if someone could point me in the right direction
How to create linked Server to connect from SQL Server 2008 to SQL Server 2000.
I following the steps to create the linked server in the GUI but failed with the following error message.
I used the full computer network name as the 'Linked Server' name
OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "my_server_network_name". The provider supports the interface, but returns a failure code when it is used.
Thanks a lot for your help.
I am getting an error while debug my application that unable to connect SQL server......The message is...
at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)
at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)
at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
at System.Web.Security.SqlRoleProvider.RoleExists(String roleName)
at System.Web.Security.Roles.RoleExists(String roleName)
at BusinessApplication4.Web.UserRegistrationService.CreateUser(RegistrationData user, String password) in C:\Users\Balakrishna\documents\visual studio 2010\Projects\BusinessApplication4\BusinessApplication4.Web\Services\UserRegistrationService.cs:line
at CreateUser(DomainService , Object )
at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object parameters)
at System.ServiceModel.DomainServices.Server.DomainService.Invoke(InvokeDescription invokeDescription, IEnumerable`1& validationErrors)
Hey'a guys kinda new in sql server..
Im developing a C# windows application.
I want to connect to my sql server remotely outside our local area network. Basically I want to connect through the internet. can I do that? How? through terminal services? any reference on how to install/ setup terminal services on my windows server..?
What could be the best connection string for that matter that I can use for my ADO.net?
my connection string is:
@"Network Library = dbnmpntw; Server = "servername\domain name,1433" ; DataBase = "databasename" ; User ID = "username " ; Password =
Ive tried going to connectionstrings.com but couldnt find one that works over the net.
Do I have to add the static Ip in my connection string?
When connecting through LAN everthing works fine. Problem happens when i try to connect outside our office.
I think maybe the problem is in my connection string....
"server was not found or was not accessible"
how to write SMO's conn.ConnectionString with IP address and port?
ÃÂ i got an error when i connect to sqlserver 2005 db with use of Sqlserver ManagementStudio.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)(Microsoft Sql Error - 64)...
i have two data base in two sql server instance and different computers and different places over the internet.
I can create a stored procedure that does a select of a table from a database of a computer, and then insert the table in another database of another computer?
SELECT * FROM SERVER1.DATABASE1.dbo.TABLE1
after prepare and insert in the other computer, SERVER2.DATABASE2.dbo.TABLE2
thanks in advanced
I am using Windows 7 and did install the MySQL ODBC connector a few days ago.
What I am trying: I´d like to connect to my remote database named "database" on the server "data.base.com" with a username and a password.
My Problem is, that I don´t know how create the connection string for a DSN on a server not in my intranet.
Any hints, suggestions, etc?
I need your advice, how to go about the following task which i need to do
1) Create SQLSERVER 2000 database creation script. This will have script for all objects in database.
2) Update the header of each sql files based on the template provided.
for task 1 i can create the sql scripts using enterpirse console for sqlserver. Database have lot of indexes and table. how to find the logical sequence the sql scripts(with out hit and trial) ?
for task 2 do you know any documentaion utility which can apply header template to each database object sql script ?
TITLE: Connect to Server
Cannot connect to (local).
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)