Invalid object name error while constructing sql using datarelation

Hi mates

I am getting the following error "Invalid object name 't1'.Invalid object name 'relT1T2'."
from this line of code " String SQLREL = "SELECT t1.SubCategory2Name, t1.CityName, SubCategory2Name,relT1T2.N FROM " +
"t1 INNER JOIN relT1T2 ON t1.PKSUBCAT2ID = relT1T2.FKSUBCAT2ID";"

i am basically using datarelation and the relation is working fine and is showing all the data for the parent and child tables but while constructing sql i get above mentioned error.can some one pls help me out.

the full code is given below:

DataColumn parentCol;
DataColumn childCol;

parentCol = ds11.Tables["t1"].Columns["PKSUBCAT2ID"];
childCol = ds11.Tables["t2"].Columns["FKSUBCAT2ID"];

DataRelation relT1T2;
relT1T2 = new DataRelation("T1T2", parentCol, childCol);

ds11.Relations.Add(relT1T2);

Response.Write(ds11.Tables["t1"].Rows.Count);

foreach (DataRow rowParent in ds11.Tables["t1"].Rows)
{
foreach (DataRow rowChild in rowParent.GetChildRows(relT1T2))
{
Response.Write(ds11.Tables["t1"].Rows.Count);//test code
DataView dv1 = ds11.Tables["t1"].DefaultView;

String SQLREL = "SELECT t1.SubCategory2Name, t1.CityName, SubCategory2Name,relT1T2.N FROM " +
"t1 INNER JOIN relT1T2 ON t1.PKSUBCAT2ID = relT1T2.FKSUBCAT2ID";

DataSet ds77 = new DataSet();
SqlConnection cn77 = new SqlConnection(CONN1);
cn77.Open();
SqlDataAdapter da77 = new SqlDataAdapter(SQLREL, cn77);
da77.Fill(ds77);

DataList1.DataSource = ds77.Tables[0].DefaultView;

DataList1.DataBind();
cn77.Close();

Hi gurjeetsaini,

Could you please post your connection string "CONN1" here please?

Also, it seems to me you are drive data from your datarelation class, Based on my understanding, datarelation class is not designed for that purpose (it only represent relationships between tables in a dataset, it cannot be used like tables or datasets).

Hope my suggestion helps

Invalid Object Issue...

I ran the Upsizing wizard to convert an Access file to a SQL file.
Everything worked fine before. I changed my connection string and now I
get:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL
Server Driver][SQL Server]Invalid object name 'tbl_MRSongs'.
/impulse/impulse_MR.asp, line 77
For the record, the connection works fine in Live Data in DW.
Here's the offending code:
<%
var rs_MRSong = Server.CreateObject("ADODB.Recordset");
rs_MRSong.ActiveConnection = MM_con_MR_STRING;
rs_MRSong.Source = "SELECT * FROM tbl_MRSongs WHERE ID_Song = "+
rs_MRSong__MMColParam.replace(/'/g, "''") + "";
rs_MRSong.CursorType = 0;
rs_MRSong.CursorLocation = 2;
rs_MRSong.LockType = 1;
rs_MRSong.Open(); <-- This is line 77
var rs_MRSong_numRows = 0;
%>
Here's the connection string:
var MM_con_MR_STRING = "Provider=MSDASQL;Driver={SQL
Server};Server=(local);Database =
DataBASE;UID=USER;PWD=PASSWORD;Trusted_Connection= yes"
What changes did u make to the connection string? Also, you might want to
first test this new connection string and if it works by using a UDL file.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Invalid Object Issue...

I ran the Upsizing wizard to convert an Access file to a SQL file.
Everything worked fine before. I changed my connection string and now I
get:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][
ODBC SQL
Server Driver][SQL Server]Invalid object name 'tbl_MRSongs'.
/impulse/impulse_MR.asp, line 77
For the record, the connection works fine in Live Data in DW.
Here's the offending code:
<%
var rs_MRSong = Server.CreateObject("ADODB.Recordset");
rs_MRSong.ActiveConnection = MM_con_MR_STRING;
rs_MRSong.Source = "SELECT * FROM tbl_MRSongs WHERE ID_Song = "+
rs_MRSong__MMColParam.replace(/'/g, "''") + "";
rs_MRSong.CursorType = 0;
rs_MRSong.CursorLocation = 2;
rs_MRSong.LockType = 1;
rs_MRSong.Open(); <-- This is line 77
var rs_MRSong_numRows = 0;
%>
Here's the connection string:
var MM_con_MR_STRING = "Provider=MSDASQL;Driver={SQL
Server};Server=(local);Database =
DataBASE;UID=USER;PWD=PASSWORD;Trusted_C
onnection=yes"What changes did u make to the connection string? Also, you might want to
first test this new connection string and if it works by using a UDL file.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Invalid connection string on SQLXMLBulkLoad

Hi.

I'm using SQLXMLBulkLoad to insert data into the SQL database. It worked with the test database on my PC but when I changed it into a VPS it throws an error: Invalid Connection String. This connection string that I used worked in my program before the addition of 'provider = sqloledb'.

Here's the connection string:

@."Provider = sqloledb; Data Source=CRM;Initial Catalog=Works;Persist Security Info=True;User ID=userid;Password=password;Asynchronous Processing=True";

Anyone?

heres the error code:
-2147217887If anyone is experiencing the same problem, I just edited my connection string manually to the VPS and it worked.

Invalid connection string on SQLXMLBulkLoad

Hi.

I'm using SQLXMLBulkLoad to insert data into the SQL database. It worked with the test database on my PC but when I changed it into a VPS it throws an error: Invalid Connection String. This connection string that I used worked in my program before the addition of 'provider = sqloledb'.

Here's the connection string:

@."Provider = sqloledb; Data Source=CRM;Initial Catalog=Works;Persist Security Info=True;User ID=userid;Password=password;Asynchronous Processing=True";

Anyone?

heres the error code:
-2147217887
If anyone is experiencing the same problem, I just edited my connection string manually to the VPS and it worked.

Invalid connection string attribute

We have a development team that is having intermittant problems with
connecting to a server. They are receiving the following error:
Microsoft OLE DB Provider for SQL Server ... Error Message: Invalid
connection string attribute
for the following connection string:
Provider=SQLOLEDB;Data Source=SNLSQLDBD01;Initial
Catalog=WINTER;Trusted_Connection=Yes;DateFormat=m dy
I'd appreciate any insight - as I said the error is intermittant (love
those). I can't find any examples of DateFormat being used in a SQLOLEDB
provider so I am wondering about that.
thanks
Peter
We now think that the message was misleading - there may be something in the
conection string that it didn't like (DateFormat=mdy ?) but was able to
cope with. The job ran fine when scheduled to start at a different time when
there was lower activity.
"Peter Feakins" wrote:

> We have a development team that is having intermittant problems with
> connecting to a server. They are receiving the following error:
> Microsoft OLE DB Provider for SQL Server ... Error Message: Invalid
> connection string attribute
> for the following connection string:
> Provider=SQLOLEDB;Data Source=SNLSQLDBD01;Initial
> Catalog=WINTER;Trusted_Connection=Yes;DateFormat=m dy
> I'd appreciate any insight - as I said the error is intermittant (love
> those). I can't find any examples of DateFormat being used in a SQLOLEDB
> provider so I am wondering about that.
> thanks
> Peter
>
>
>
>
|||I couldn't find any reference in the docs on the provider
for the attribute DateFormat. I found some posts were a few
others were using it but they had the value in double quotes
and used formats such as "YYYY-MM-DD". DateFormat = mdy
looks more like a T-SQL thing. You may want to just execute
a set dateformat SQL statement if that's what you want to
set the format for the client entering datetime data.
-Sue
On Thu, 9 Sep 2004 14:59:13 -0700, "Peter Feakins"
<PeterFeakins@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>We now think that the message was misleading - there may be something in the
>conection string that it didn't like (DateFormat=mdy ?) but was able to
>cope with. The job ran fine when scheduled to start at a different time when
>there was lower activity.
>"Peter Feakins" wrote:

Invalid class string in Enterprise manager

Hi, Sorry to be cross-posting, but I'm not getting much response to this...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=807314&SiteID=1

...which I don't even think is in the right forum anyway. can anyone help?

Basically, I get a error box saying "Invalid class string" in Enterprise Manager whenever I try to run a query.

Apologies if this is the DTS-related article that you've already tried, but have you looked at this KB article? Even though you're not using DTS, the installer seems to have some problems during the upgrade to 2005. I haven't seen this issue before so I'm interested to see if this solves your problem.

http://support.microsoft.com/?kbid=912421

CAUSE

During the SQL Server 2005 installation, the support for the Analysis Services Processing task in SQL Server 2000 DTS is installed as the Msmdtsp.dll file. The Msmdtsp.dll file is not correctly registered after the SQL Server 2005 installation.

Back to the top

WORKAROUND

To work around this problem, click Start, click Run, type the following command, and then click OK:

regsvr32 "C:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll"

Thanks,
Sam Lester (MSFT)

|||

nope didn't work.

I installed the Analytical services, ran the regsvr line (which worked) but still having the same problem.

btw, I used to have some version of SQL Server 2005 installed (as part of Visual Studio 2005) but removed this, as I though this was causing the problem.

I tried a repair of Visual Studio 2005 hoping this might help, which took about an hour and the failed (twice). I can run queries through Server Explorer, so I can live with this for now, but I'd still like to have it fixed, SQL Server 2000 is a important tool for a developer!

|||

Samuel,

I got this reply on the other thread..

Please file a defect report on http://connect.microsoft.com.

I suspect one of the designer components is corrupt or missing on your machine. Can you design Views in SQL Enterprise Manager? The Open Table designer and View designer are packaged in the same component, so it would be helpful to know that.

Thanks,
Steve

I have filed a defect report

|||

Thanks for the update!

Sam

Invalid Class String (Database diagram)

I am getting an error trying to create a new database diagram. I assume that
some underlying COM component is not registered properly, but I am not sure
which one, as there is no Event Log entry, only the error in SQL Management
Studio.
===================================
Invalid class string
(MS Visual Database Tools)
Program Location:
at
System.Runtime.InteropServices.Marshal.ThrowExcept ionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VirtualProject.Microsoft.SqlServer.Managemen t.UI.VSIntegration.Editors.ISqlVirtualProject.Crea teDesigner(Urn
origUrn, DocumentType editorType, DocumentOptions aeOptions,
IManagedConnection con)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.ISqlVirtualProject.CreateDesigner(Urn
origUrn, DocumentType editorType, DocumentOptions aeOptions,
IManagedConnection con)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VsDocumentMenuItem.CreateDesignerWindow(IMan agedConnection
mc, DocumentOptions options)
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
Solved by uninstalling and reinstalling the tools.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamM> wrote in
message news:%23BR6sXg2HHA.5884@.TK2MSFTNGP02.phx.gbl...
>I am getting an error trying to create a new database diagram. I assume
>that some underlying COM component is not registered properly, but I am not
>sure which one, as there is no Event Log entry, only the error in SQL
>Management Studio.
>
> ===================================
> Invalid class string
> (MS Visual Database Tools)
> --
> Program Location:
> at
> System.Runtime.InteropServices.Marshal.ThrowExcept ionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VirtualProject.Microsoft.SqlServer.Managemen t.UI.VSIntegration.Editors.ISqlVirtualProject.Crea teDesigner(Urn
> origUrn, DocumentType editorType, DocumentOptions aeOptions,
> IManagedConnection con)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.ISqlVirtualProject.CreateDesigner(Urn
> origUrn, DocumentType editorType, DocumentOptions aeOptions,
> IManagedConnection con)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VsDocumentMenuItem.CreateDesignerWindow(IMan agedConnection
> mc, DocumentOptions options)
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> http://gregorybeamer.spaces.live.com
> Co-author: Microsoft Expression Web Bible (upcoming)
> ************************************************
> Think outside the box!
> ************************************************
>

Invalid Class String

Hi,

I'm working on both VWDEE and VBEE and, in each, when I try to add a database diagram I get the following message (after the 'Do you want to create required objects' prompt) 'Invalid Class String'.

Any ideas?

Hi,

Do you use SQLServer2000? Do you have the SQLServer 2000 SP4 isntalled? If so, replace the SP4 with SP3a and have a try.

Thanks.

|||

Hi,

The SQL I have is the default express edition that you get with VWD Express Edition, although it shows up in the program menu as 2005 (After installing SQL Server Management Studio Express).

I tried the advice of Salmontraining, in as much as I reinstalled all the express products, and now it works.

So, if you can't get your database diagrams to work, go to control panel/add remove programs and uninstall/reinstall VWD or any of the other Express applications, SQL should be reinstalled automatically.

Invalid Class String

Hi
This is sort of a repost of my previous posting, but I think the
problem is better explained in this one.
I have a windows 2003 cluster with two machines, SKADB01 and SKADB02.
There are two clusternames that both contain these two machines:
SKABIZCLU (For Microsoft BizTalk Server) and SKADBCLU for SQL Server.
Both are Active/Passive clusters. Usually, the SQL Server cluster runs
on one machine and the BizTalk cluster runs on the other machine.
If SQL Server runs on SKADB02, then everything runs just fine nomatter
which machine BizTalk runs on. There is only one MSDTC ressource and
it is in the BizTalk cluster group. "Enable Network DTC Access" is
installed on both machines.
If SQL Server runs on SKADB01, on the other hand, I seem to be getting
an "Invalid Class String" error when the BizTalk Adapter for SQL
Server is trying to put data into tables.
All I have been able to find on the big Net is that some DTS package
isn't installed, so I should install SQL Server client tools on both
machines. But, as you might have understood, the client tools as well
as the server are installed on both machines. So it must be something
else.
Can anyone help me?
Thanks in advance!
Jan Eliasen, MCP, MVP, MSDN Universal and TechNet
Jan Eliasen, representing himself and not the company he works for.
Hi
This is yet another repost, because I found out that if I signed up
for managed newsgroups at the MSDN site, I am guaranteed an answer
within two businessdays... Quite clever, actually.
So, to Microsoft: If you have any ideas about my below mentioned
problem, please let me know.
Jan Eliasen
On Fri, 27 Aug 2004 11:08:10 +0200, Jan Eliasen <spam@.eliasen.dk>
wrote:

>Hi
>This is sort of a repost of my previous posting, but I think the
>problem is better explained in this one.
>I have a windows 2003 cluster with two machines, SKADB01 and SKADB02.
>There are two clusternames that both contain these two machines:
>SKABIZCLU (For Microsoft BizTalk Server) and SKADBCLU for SQL Server.
>Both are Active/Passive clusters. Usually, the SQL Server cluster runs
>on one machine and the BizTalk cluster runs on the other machine.
>If SQL Server runs on SKADB02, then everything runs just fine nomatter
>which machine BizTalk runs on. There is only one MSDTC ressource and
>it is in the BizTalk cluster group. "Enable Network DTC Access" is
>installed on both machines.
>If SQL Server runs on SKADB01, on the other hand, I seem to be getting
>an "Invalid Class String" error when the BizTalk Adapter for SQL
>Server is trying to put data into tables.
>All I have been able to find on the big Net is that some DTS package
>isn't installed, so I should install SQL Server client tools on both
>machines. But, as you might have understood, the client tools as well
>as the server are installed on both machines. So it must be something
>else.
>Can anyone help me?
>Thanks in advance!
>Jan Eliasen, MCP, MVP, MSDN Universal and TechNet
Jan Eliasen, representing himself and not the company he works for.
|||Except that I don't think that this is a managed newsgroup. I don't see this
one listed under Enterprise Development/SQL Server on
http://msdn.microsoft.com/newsgroups/managed/. In addition to that, I
believe that the first post in the thread has to come from an MSDN
registered email address so even if there were MSDN engineers in here, they
probably wouldn't find this thread.
And finally, I'm sorry but I don't know the answer to your question. Please
email your MVP Lead and ask John to open a support case for you.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jan Eliasen" <eliasen@.nospam.nospam> wrote in message
news:t2n5j0ll6s8en07jv0h6arbjq2m9j4jjgd@.4ax.com...
> Hi
> This is yet another repost, because I found out that if I signed up
> for managed newsgroups at the MSDN site, I am guaranteed an answer
> within two businessdays... Quite clever, actually.
> So, to Microsoft: If you have any ideas about my below mentioned
> problem, please let me know.
> Jan Eliasen
> On Fri, 27 Aug 2004 11:08:10 +0200, Jan Eliasen <spam@.eliasen.dk>
> wrote:
>
> --
> Jan Eliasen, representing himself and not the company he works for.
|||Hi
Thank you for your answer.
I have failed to find a list of managed newsgroups - the link you
provided seems to be to a page where I can search in the managed
newsgroups?!?
Jan Eliasen
On Mon, 30 Aug 2004 09:11:54 -0700, "Stephen Dybing [MSFT]"
<stephd@.online.microsoft.com> wrote:

>Except that I don't think that this is a managed newsgroup. I don't see this
>one listed under Enterprise Development/SQL Server on
>http://msdn.microsoft.com/newsgroups/managed/. In addition to that, I
>believe that the first post in the thread has to come from an MSDN
>registered email address so even if there were MSDN engineers in here, they
>probably wouldn't find this thread.
>And finally, I'm sorry but I don't know the answer to your question. Please
>email your MVP Lead and ask John to open a support case for you.
Jan Eliasen, representing himself and not the company he works for.
|||Not sure whether this is off-track..
I followed the link to the managed news groups provided by Steven and
searched for "Invalid Class String" against ALL categories. If found this
series of posts! It therefore appears that the "managed" newsgroups are
probably super-sets made up of news groups such as
"microsoft.public.sqlserver.clustering".
Griff
|||I don't know if there is a simple list of the managed newsgroups. I seem to
recall one at some point, but I can't find it either. However, that page
that I sent you, http://msdn.microsoft.com/newsgroups/managed/, has all the
SQL Server managed newsgroups listed. Hover over Enterprise Development in
the left navigation pane, then hover over SQL Server when it expands. The
resultant list shows the 13 SQL Server managed newsgroups. I don't see
..clustering listed. I'll go check with the MSDN folks to make sure, but I
think that's all there is. We're in the process of adding .reportingsvcs to
that list, but it's not finalized yet.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jan Eliasen" <eliasen@.nospam.nospam> wrote in message
news:0um8j0p66ns38fvabkrcak7p59b83re17c@.4ax.com...
> Hi
> Thank you for your answer.
> I have failed to find a list of managed newsgroups - the link you
> provided seems to be to a page where I can search in the managed
> newsgroups?!?
> Jan Eliasen
> On Mon, 30 Aug 2004 09:11:54 -0700, "Stephen Dybing [MSFT]"
> <stephd@.online.microsoft.com> wrote:
>
> --
> Jan Eliasen, representing himself and not the company he works for.
|||I suspect that the web interface simply isn't smart enough to not query the
unmanaged newsgroups as well, but I'll go check.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Griff" <Howling@.The.Moon> wrote in message
news:OFAS3b1jEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Not sure whether this is off-track..
> I followed the link to the managed news groups provided by Steven and
> searched for "Invalid Class String" against ALL categories. If found this
> series of posts! It therefore appears that the "managed" newsgroups are
> probably super-sets made up of news groups such as
> "microsoft.public.sqlserver.clustering".
> Griff
>
|||OK, I've confirmed that this is an unmanaged newsgroup. Here is the list of
all SQL Server managed newsgroups:
microsoft.public.sqlserver.clients
microsoft.public.sqlserver.connect
microsoft.public.sqlserver.datawarehouse
microsoft.public.sqlserver.dts
microsoft.public.sqlserver.mseq
microsoft.public.sqlserver.odbc
microsoft.public.sqlserver.olap
microsoft.public.sqlserver.programming
microsoft.public.sqlserver.replication
microsoft.public.sqlserver.security
microsoft.public.sqlserver.server
microsoft.public.sqlserver.setup
microsoft.public.sqlserver.tools
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uyHBr52jEHA.3884@.TK2MSFTNGP10.phx.gbl...
>I don't know if there is a simple list of the managed newsgroups. I seem to
>recall one at some point, but I can't find it either. However, that page
>that I sent you, http://msdn.microsoft.com/newsgroups/managed/, has all the
>SQL Server managed newsgroups listed. Hover over Enterprise Development in
>the left navigation pane, then hover over SQL Server when it expands. The
>resultant list shows the 13 SQL Server managed newsgroups. I don't see
>.clustering listed. I'll go check with the MSDN folks to make sure, but I
>think that's all there is. We're in the process of adding .reportingsvcs to
>that list, but it's not finalized yet.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Jan Eliasen" <eliasen@.nospam.nospam> wrote in message
> news:0um8j0p66ns38fvabkrcak7p59b83re17c@.4ax.com...
>
|||Yep, we've filed a bug on the fact that even though you specify to search in
the managed newsgroups it searches all of them. Oops...
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:Oi7YB62jEHA.632@.TK2MSFTNGP12.phx.gbl...
>I suspect that the web interface simply isn't smart enough to not query the
>unmanaged newsgroups as well, but I'll go check.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Griff" <Howling@.The.Moon> wrote in message
> news:OFAS3b1jEHA.2764@.TK2MSFTNGP11.phx.gbl...
>

Intranet Set up with SQL server and ASP

Dear all,

I am trying to make a Intranet connection with SQL 2000 and ASP,
but a serious problem in connection string. Please can you help me in this issue

I am using following connection string.

(windows authontication)

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="PROVIDER=SQLOLEDB;Integrated Security=SSPI;Initial cataloge =nrth;DataSource=server"

System dsn =nrth
server name =server

This string makes following error

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

//global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

/test2.asp, line

can you correct this or suggest a valid connection string

Thank youThe DSN probably only exists on the one server. Try replacing it with
Server=servername.|||Originally posted by Satya
The DSN probably only exists on the one server. Try replacing it with
Server=servername.

still having error,

I am checking it in server itself