problems with port in connections (in ASP)

Kavi

Hi all

i'm new to this, your assistence will be greatly appriated :-)

i have a connection string (this all in asp )

tCSCst = Provider=SQLOLEDB;Data Source=test02x2;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>

Set testCaseServerConn = Server.CreateObject("ADODB.Connection")
testCaseServerConn.Open tCSCstr

but i get the following error

An error occured:-2147467259 - Invalid connection string attribute

the problem seems to be the port itself, if i use 1433 then it works
fine.

Sep 21 '06 #1

Subscribe Post Reply

2790

Ray Costanzo [MVP]

Can you post your actual code? It appears you retyped it since your string
doesn't have quotes around it, and your variable names differ. Also, what
version of MDAC?

Ray at work

"Kavi" <Ka************@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...

Hi all

i'm new to this, your assistence will be greatly appriated :-)

i have a connection string (this all in asp )

tCSCst = Provider=SQLOLEDB;Data Source=test02x2;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>

Set testCaseServerConn = Server.CreateObject("ADODB.Connection")
testCaseServerConn.Open tCSCstr

but i get the following error

An error occured:-2147467259 - Invalid connection string attribute

the problem seems to be the port itself, if i use 1433 then it works
fine.

Sep 21 '06 #2

Kyle Peterson

try data source, then a comma, port number

that is how I do it

get rid of the port= stuff

"Kavi" <Ka************@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...

Hi all

i'm new to this, your assistence will be greatly appriated :-)

i have a connection string (this all in asp )

tCSCst = Provider=SQLOLEDB;Data Source=test02x2;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>

Set testCaseServerConn = Server.CreateObject("ADODB.Connection")
testCaseServerConn.Open tCSCstr

but i get the following error

An error occured:-2147467259 - Invalid connection string attribute

the problem seems to be the port itself, if i use 1433 then it works
fine.

Sep 21 '06 #3

Similar topics

Printing to serial port with ASP

by: PW | last post by:

I have to setup a point-of-sale system for a friend. He has a PC, barcode scanner, receipt printer and cashdrawer. The receipt printer connects to the serial port. The cashdrawer connects to...

ASP / Active Server Pages

Accessing Com- and LPT-Port with ASP.NET

by: Gerald | last post by:

hello, i am developing an intranet-portal and i have to communicate with the client's hardware (com- and lpt- ports). is it possible with asp.net or any other method to do that?

ASP.NET

How to port Classic ASP pages to ASP.NET?

by: Kapil Maheshwari | last post by:

Is there a standard way to do so , or a complete re-write of the pages necessary ? TIA, Kapil

ASP.NET

problems in running asp.net application

by: she | last post by:

I have following senario need you to help with: 1. Computer A crashed. 2. I reinstalled .net framework 1.1. 3. Copied all the files that used for the asp.net application from computer B to...

ASP.NET

Problems with accessing ASP.NET Session values in ASP

by: Anders Jansson | last post by:

Hi! I'm porting an ASP application to ASP.NET 1.1 and having problems with accessing Session values in ASP that were created and initialized in ASP.NET 1.1. For example, I added a variable in...

ASP.NET

access serial port from ASP.NET 2.0

by: leovg | last post by:

Can I access the serial port (RS232) out of an ASP.NET 2.0 client form? We are planning a barcode application where a barcode scanner delivers input to an ASP.NET form via RS232.

ASP.NET

Problems compiling/running ASP.NET AJAX sample pages...

by: celoftis | last post by:

Using VS 2005: This morning, following the instructions here: http://ajax.asp.net/docs/overview/InstallingASPNETAJAX.aspx, I installed ASP.NET AJAX on my WinXP Pro development machine. Following...

ASP.NET

Problems building an ASP.Net App / IIS issue

by: ripvonboomer | last post by:

I am fairly new to programming, and have purchased and installed VS 2003. No problems with windows apps, but I tried to create a new ASP.Net web app, and it won't even build the solution. I am...

IIS / Internet Information Server

Getting current host name and port in ASP.NET Application

by: John Q | last post by:

In Silverlight Application it's possible to query current Application's hostname and port using namespace Windows.System and code like below. Iused it in WCF client call. String hostname =...

.NET Framework

Problems with an ASP contact form...

by: jerry101 | last post by:

Okay, so I have no knowledge with ASP and I was asked to look at this contact form because the emails aren't delivering. I'll post the whole page of code, because I am unsure at what is what...

ASP / Active Server Pages

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

AI Job Threat for Devs

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,...

Career Advice