OLEDB connection to a remote SQL Server Database - Servername

I want to establish a ADO OLEDB connection to a SQL Server 2K at a webserver
with a reference to the server name instead of IP-adress. Just like :
db.Properties("Data Source").Value = "http://testserver.com"
Do I need to specify the standard port '1433' ( as is the case with IP
adressing) in the connection string ?
OscarI Have the same problem (under W2003 Server)
"Oscar" <oku@.xs4all.nl> a crit dans le message de
news:40575beb$0$126$e4fe514c@.dreader10.news.xs4all.nl...
> I want to establish a ADO OLEDB connection to a SQL Server 2K at a
webserver
> with a reference to the server name instead of IP-adress. Just like :
> db.Properties("Data Source").Value = "http://testserver.com"
> Do I need to specify the standard port '1433' ( as is the case with IP
> adressing) in the connection string ?
> Oscar
>

OLEDB Access PB

Hi

I definite a source OLEDB MS Access and my fields of the type “Text” are seen in type of field DT_WSTR (Unicode) instead of DT_STR.

I do not include/understand why? and like then, I must integrate them in fields varchar and not nVarchar, I do not find the solution?

thank for your solution

You can use a Derived Column transform to convert between Unicode and Ansi. Use the operators under the Type Casts section.

Code Snippet

(DT_STR, 50, 1252) [Your_Column]

|||

Hi plab,

You may even use a DataConversion transformation to change type DT_WSTR to DT_STR with a required length.

Thanks

Subhash Subramanyam

OLE DB Source and Isolation level

Is there a way to define Connection Manager with Read Uncommited isolation level? I do not want to specify (nolock) in all my commands and instead want to give a generic defenition at the Connection level.

Is this possible?

if i'm not mistaken, transaction isolation levels can only be set within a t-sql transaction.