473,320 Members | 1,600 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL SERVER Connection Problem II

Hi,

I can connect using my PC local SQL Server Enterprise manager to Remote SQL
Server.
But I cannot connect using my Connection string?

strConn = "Data Source=190.168.0.97,1433;Network Library=DBMSSOCN;Initial
Catalog=DBANK;User ID=myID;Password=myPASSWORD;"

Does anyone knows any idea?

Thank you for reading this.

Rgds,
GC
Sep 30 '05 #1
9 6528
Hello,

What about:
strConn = "Data Source=190.168.0.97:1433;Network
Library=DBMSSOCN;Initial Catalog=DBANK;User
ID=myID;Password=myPASSWORD;"

Regards,

Mark
Hi,

I can connect using my PC local SQL Server Enterprise manager to
Remote SQL
Server.
But I cannot connect using my Connection string?
strConn = "Data Source=190.168.0.97,1433;Network
Library=DBMSSOCN;Initial Catalog=DBANK;User
ID=myID;Password=myPASSWORD;"

Does anyone knows any idea?

Thank you for reading this.

Rgds,
GC

Sep 30 '05 #2
Hello Niyazi,

I think everyting is rignt in your connection string.The port number you
have stated is default port.It might be possible that it is set other than
1433 in your case so check it.

if you still have problem let me know the error in details.

Thanks,

Bhavesh Patel.
Software Enggineer,
Ahmedabad.

"Niyazi" wrote:
Hi,

I can connect using my PC local SQL Server Enterprise manager to Remote SQL
Server.
But I cannot connect using my Connection string?

strConn = "Data Source=190.168.0.97,1433;Network Library=DBMSSOCN;Initial
Catalog=DBANK;User ID=myID;Password=myPASSWORD;"

Does anyone knows any idea?

Thank you for reading this.

Rgds,
GC

Sep 30 '05 #3
Hi,

I set the port number as correct ....:1433 but still I cannot connect. I
disable Windows XP firewall and now my Enterprise manager cannot see the
remote SQL Server.

When I set right connection to my application as you suggested I get an
error that says "Specified SQL Server not found: 192.168.0.90:1433"

And when I try to connect to Remote SQL Server via Enterprice Manager in my
Local PC I get and access denied error.

Does anyone know how to set SQL Logings in Remote SQL Server so I can use my
connection string. I am guessing that I am having access problem.

Thank you.

Rgds,
GC

"Bhavesh Patel" wrote:
Hello Niyazi,

I think everyting is rignt in your connection string.The port number you
have stated is default port.It might be possible that it is set other than
1433 in your case so check it.

if you still have problem let me know the error in details.

Thanks,

Bhavesh Patel.
Software Enggineer,
Ahmedabad.

"Niyazi" wrote:
Hi,

I can connect using my PC local SQL Server Enterprise manager to Remote SQL
Server.
But I cannot connect using my Connection string?

strConn = "Data Source=190.168.0.97,1433;Network Library=DBMSSOCN;Initial
Catalog=DBANK;User ID=myID;Password=myPASSWORD;"

Does anyone knows any idea?

Thank you for reading this.

Rgds,
GC

Oct 3 '05 #4
Hi,

I try to create a DSN to remote SQL Server and I get an error as follows.
--------------------------------------------------------------------------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnetionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
-----------------------------------------------------------------------------------------------

This morrning since 7am my local timne to 1pm I search the internet and I
only find that I should update my SQL Server with SP4.

Now I am nearly downloaded all the update and after lunch I will going to
try it.

But is the error is link the update or some other setting in my SQL Server
as well as my WinXP SP2 that reside the remote SQL Server setting has
something to do?

I will post my result this afternoon or tomorrow mornning.

Thank you.

Rgds,
GC
Oct 3 '05 #5
Hi,

After I install the SQL SERVER 2000 SP4 I try to connect using SQL SERVER
Enterprise manager and it was succesful. Then I test it using VS.NET 2003
Server Wizard Toolbox and created the connection. I copied the connection
string as:

Dim strConn As String
strConn = "Server=SQL_SERVER_TEST;Database=DBANK;User
ID=myid;Password=mypassword;"

And it worked very well.

I hope thsi will help others if they encounter similar problem.

Thank you.

Rgds,
GC
Oct 5 '05 #6
Hi,

I forget to write my SQL SERVER was in WIN XP PRO machine. So I open the
Windows Firewall Exceptions Diolog and I add a PORT as:

Name: TCP-IP
Port number: 1433

That will help me to access the SQL SERVER using the connection string as:

Dim strConn As String
strConn = "Server=SQL_SERVER_TEST;Database=DBANK;User
ID=myid;Password=mypassword;"

Thank you.

Rgds,
GC
Oct 5 '05 #7
Hi,

Also if anyone get an error as: "SQL Server does not exist or access denied. "

They should also check the microsft support article 839296
http://support.microsoft.com/kb/839269/

If the client mechine is the WIN XP SP2 then conecting remote SQL Server
might get the above error.

I red the article and I set the my client machine as it is as well as my SQL
Server Test that is in another WIN XP PRO SP2. When I set 2 machine evrything
worked fine.

Rgds,
GC


Oct 6 '05 #8
Lee
I use this all the time to connect to any sql server using a .NET
SQLConnection...

"Server=190.168.0.97;Database=DBank;Trusted_Connec tion=No;UID=myuid;PWD=mypwd;"
Oct 6 '05 #9
Hi Lee,

My problem was the Service Pack for MS SQL SERVER 2000. After I update It
worked fine when SQL Server 2000 reside on Win XP SP2 machine. I use this
machine as test mechine.

So after I search I found that If you connect SQL Server that resides on WIN
XP Pro with SP2 that means the Firewall is on than you cannot connect. Unless
you turn WIN XP PRO SP2 firwall to off mode. Than it connected. Than I search
and find the article (I posted previously) that I should adjust the setting
of the 2 machine to connect to SQL Server while WIN XP PRO SP2 Firewall in
the ON mode.

Now everythings fine with me expect the problem having in log In section.

I posted my problem how to convert SQL Server Binary data type to string and
string to Binary data type that I can store in SQL Server back when admin
people can register the new user.

If I mange this I will try to write small article about Employee application
that will be secure to connect to SQL Server for a small scale companies.

Thank you.

Rgds,
GC

"Lee" wrote:
I use this all the time to connect to any sql server using a .NET
SQLConnection...

"Server=190.168.0.97;Database=DBank;Trusted_Connec tion=No;UID=myuid;PWD=mypwd;"

Oct 7 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Fortepianissimo | last post by:
Here is the situation: I want my server started up upon connection. When the first connection comes in, the server is not running. The client realizes the fact, and then starts up the server and...
2
by: Dicky Cheng | last post by:
Hi, I am using .net remoting technology. I set up a .net remoting client and server in IIS. When the client calls the server, the server will run a long duration method (30-60seconds). I have a...
5
by: Fred Zuckerman | last post by:
Hello All, After reading in this group about the preference for connecting to a SQL Server using a connection string instead of a DSN file, I have done just that. BUT, I cannot update my data....
12
by: RKay | last post by:
I have a Win2k server running SQL Server 2000. On that box I built a working web service that pulls data from the database. One of the services available simply accepts an ado.net connection string...
0
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
25
by: _DD | last post by:
I'd like to include a 'Test Connection' button in an app, for testing validity of a SQL connection string. I'd prefer to keep the timeout low. What is the conventional way of doing this?
17
by: Anil Gupte | last post by:
I am using the following to try to connect to the database, but it does not seem to be working. Dim sConnString sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security...
39
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
5
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.