I need a Data Source Name for My Datasource beginning with "\"

Hi,
Are you sure about this?
I tested Iron Speed here last year with SQL Server 2005 and I used the default DASP conn method.
Iron Speed does recognize "." as localhost, referring to SQL Express, but that is not supported here.
I do have to admit that while Iron Speed is amazing it is also very complex, even at simple tasks.
Salute,
Mark

 

Good day,

While I know this can be classed an Iron Speed Designer [ISD]issue;
I need a connection string to my database beginning with "\" instead of just 'tcp:sql2k506.discountasp.net'

Because if it begins without a "\" Iron Speed Designer considers it an oracle connection.
Can this be done?


Below are details as I raised them on the ISD forum.




The very exact connection string which runs well in ISD 5.0 and runs perfectly on the development machine when the connection string datasource is "\MyPCName\SQLExpress" is unable to get any records in ISD 5.1. once the datasource is changed to that of my webhost ('tcp:sql2k506.discountasp.net').

The Error is:
'Unable to get records. implicit conversion from data type sql_variant is not allowed. Use the CONVERT function to run this query.'

Thus every signin anddata access page does not work on Discount ASP.NET's webservers.

Having reviewed the post by Heyram, I also observed that removing 'Provider=SQLOLEDB;' from the connection string which I used successfulyy with ISD 5.0 leads ISD 5.1 to assuming the provider is oracle client and the error message changes to '
'Unable to get records. Unable to connect to database. System.Data.OracleClient required Oracle Client software version 8.1.7 or greater.'

It's unclear if it's because of the nature of the DiscountASP.NET connection string which has the datasource name ('tcp:sql2k506.discountasp.net')beginning without an initial "\".

Please is there a workaround this?
Thanks.