473,506 Members | 17,176 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

connection problem for vb with mssql 2005

137 New Member
hello all,

i'm getting problem while connecting another mssql server.
but i can connect with localhost.

my connection string that runs is

con.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Password=admin123;Persist Security Info=True;" & _
"User ID=sa;Initial Catalog=dtbs;Data Source=MYCOMPUTER\SQLEXPRESS"

where MYCOMPUTER is local host

but when i tried to connect another server "COMP1" with the following connection string, it throws the error

[DBNETLIB][ConnectionOpen (ParseConnectParams()).]invalid Connection


the connection string is

con.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Password=comp1;Persist Security Info=True;" & _
"User ID=sa;Initial Catalog=dtbs;Data Source=COMP1:1433\SQLEXPRESS"

and the default port for mssql is 1433.

how could i connect to remote server, please help

TIA
Jun 7 '10 #1
1 1492
debasisdas
8,127 Recognized Expert Expert
please find the connection string details .
Jun 7 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2538
by: theintrepidfox | last post by:
Dear Group. Wondered if any of you has any suggestion for the following? Trying to install SQL Server 2005 Eval on a 'clean' machine. Well, my mistake was probably that I had installed Visual...
0
1615
by: doron.almog | last post by:
anybody know which driver to use to make a linked server connection between MSSQL 2005 and Access 2007
0
1434
by: Derftics | last post by:
Hi Guys, Is there anyone who have tried installing MSSQL 2000 and MSSQL 2005 servers in one desktop computer? I have tried using MSDE and successfully install the MSSQL 2000 server but when I...
1
1601
by: PeerGrid | last post by:
We have a membership web site that is heavily database driven using MSSQL 2000. We are looking at converting to MSSQL 2005. What is the level of pain in doing this? Will all database calls have to be...
3
1584
by: Robert Johnson | last post by:
Hi all. My datasource is a MSSQL 2005 database with several tables all visable in my datasources tab. I can preview data in the Designer OK so my connection is fine. Now, I add a form, drag from...
0
1111
by: Derftics | last post by:
Hi Guys, Anyone knows how to script all the users with permission and access level to an object in MSSQL 2005? In MSSQL 2000 you can use the scripting in EM just go to the option "script...
0
1215
by: 123bargains | last post by:
Hello, I have a question on importing a database from MSSQL 2000 to MSSQL 2005. I hope someone on here can help me answer it. I am trying to import a database from MSSQL 2000 to 2005. But, when I...
3
1629
by: mazdotnet | last post by:
Hi guys, I'm thinking of buying a laptop time this time and I was wondering if anyone has any experience with running VisualStudio 2008 and MSSQL 2005 on a laptop? Please include your processor,...
1
1852
by: mmf.stavelot | last post by:
How to find out what type of the data procedure in MSSQL 2005 returns? Using inquiry about sample. Example: SELECT paramtypes FROM sysprocedures; Result:
0
1145
by: Mugs321 | last post by:
Hi there, I'm trying to use an asp-based database GUI (a-la PHPMyAdmin) and I'm having problems connecting to my production MSSQL 2005 database. I connected successfully to my SQLExpress server...
0
7218
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7103
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7307
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7478
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5614
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4701
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3177
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
755
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
409
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.