ODBC datasource wont work on report server!!

Hi,

I have VS2005 and sql server express and ive created some reports using sql server
as a backend. everything works as it should.

THEN...

i created a report that uses a system DSN odbc source and it works in VS2005 it works fine.
i have deployed it to the report server and the datasource appears t be there, but when i try and run the report i ge the following message

An error has occurred during report processing.

An attempt has been made to use a data extension 'ODBC' that is not registered for this report server.anyone got any ideas how i can make this work? i have tried to find an explanation using google, but i cannot seem to see any thing that answers the question.

Regards,

Russ
Express versions of Reporting Services allow for data sources to only be local and must be a matching SKU of SQL Server.

odbc datagrida

Good Day,
I got a table with company details.I am using ODBC to conect to it.

I am writing a windows form application in C# 2005 express edition.The task is to search companies. my code is as below.

---

OdbcCommand cmd = new OdbcCommand("use company", MyConnection);

cmd.CommandText = "SELECT * FROM employee WHERE Name = ?;"; /****line 3*****/
cmd.Parameters.Add("@.Name", OdbcType.VarChar, 30);
cmd.Parameters["@.Name"].Value = textBox1.Text;
cmd.ExecuteNonQuery();

OdbcDataAdapter datadapter = new OdbcDataAdapter(cmd.CommandText, MyConnection);
DataSet dataset = new DataSet();
datadapter.Fill(dataset,"employee"); /**error line***/

dataGridView1.DataMember="employee";
dataGridView1.DataSource=dataset;

---

The

above code compiles cleanly but when you run it,it gives a error. the

error statemnet is as below and the line giving error is show above in

coment.

---

ERROR [07002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]SQLBindParameter not used for all parameters

---

When line 3 is replaced by cmd.CommandText = "SELECT * FROM employee;"; the program works. fine.

I can view all employees only.BUT not a specific employee.
the problem looks complex.If some-one can help me out,it would be much appreciated.

Thanx
Rahul SK

msn add:ar_kul@.hotmail.comDo you sure that 'Name' field is exists in this table?

odbc datagrida

Good Day,
I got a table with company details.I am using ODBC to conect to it.

I am writing a windows form application in C# 2005 express edition.The task is to search companies. my code is as below.

---

OdbcCommand cmd = new OdbcCommand("use company", MyConnection);

cmd.CommandText = "SELECT * FROM employee WHERE Name = ?;"; /****line 3*****/
cmd.Parameters.Add("@.Name", OdbcType.VarChar, 30);
cmd.Parameters["@.Name"].Value = textBox1.Text;
cmd.ExecuteNonQuery();

OdbcDataAdapter datadapter = new OdbcDataAdapter(cmd.CommandText, MyConnection);
DataSet dataset = new DataSet();
datadapter.Fill(dataset,"employee"); /**error line***/

dataGridView1.DataMember="employee";
dataGridView1.DataSource=dataset;

---

The above code compiles cleanly but when you run it,it gives a error. the error statemnet is as below and the line giving error is show above in coment.

---

ERROR [07002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]SQLBindParameter not used for all parameters

---

When line 3 is replaced by cmd.CommandText = "SELECT * FROM employee;"; the program works. fine.

I can view all employees only.BUT not a specific employee.
the problem looks complex.If some-one can help me out,it would be much appreciated.

Thanx
Rahul SK

msn add:ar_kul@.hotmail.comDo you sure that 'Name' field is exists in this table?
sql

ODBC Connection with SQL Express

If I create any other user (test, felix, fido, etc) in my database, that user can login successfully through Management Studio Express except not through an ODBC connection. Thus, this is a very bizarre issue. I have made sure this user has the same roles as SA. My instance is configured to handle SQL Server Authentication and Integrated. This works fine in Studio Express, but not in the ODBC connection.

When using "SA" login, I can connect to Management Studio Express and through an ODBC connection. Seems rudimentary enough, however, if I change the name in the ODBC connection i get

"Connection Failed,

SQLState '28000', SQL

Server Error 18456,

Microsoft SQL Native Client SQL Server Login failed for user 'xyz'"

Any ideas? Do I need a different ODBC Administrator?

Hi,

I would suggest to refer http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx for connection troubleshooting.

Hemantgiri S. Goswami

|||

Most likely this is caused by the fact that you are connecting (or trying to connect) to a database within your connection string where you don′t have access to. The state in the error code should give you a bit more information about the problem during the connection time. try setting a database in the connection string which is in common accessible to everyone (master). Although this might work, you should consider putting the right database in the connection string afterwards, as changing database it not a cheap operation.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

ODBC connection for client application to SQL Server 2005 Express installed on network computer

Hi All,

I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.

I would now like to install my application on another workstation and connect remotely to the database located on my development machine.

The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?

Thanks!
Deployment of the SNAC can be found here:

http://msdn2.microsoft.com/en-us/library/ms131334.aspx

If you don′t use the new features of SQL Server 2005, you can also use the MDAC driver which is compatible with the Pre SQL 2005 features of SQL Server 2005.

My best practice is not to use the DSN rather than using direct connection strings which can be configured in configuration files.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de
|||Thanks for the reply.

I can't seem to find the sqlncli.msi file on my drive. I have the Express edition installed. Is there somewhere else I can find this installer for the SNAC driver?

If not, which version of MDAC do I need, and how would I build my DSN? I agree with using connection strings instead of DSN's, unfortunately that is a decision I'm unable to change.

|||

SNAC: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc
it

Just get the newest MDAC, since it makes no difference if you get 2.7 or 2.8 but getting the newest will keep you away from old bugs :-)

The connectionstrings can be found on www.connectionstring.com (Where I also posted an example for the SNAC one :-) )

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Excellent,

I got it working using MDAC.

Thanks!

ODBC Components not loading

I am running SQL Express on a Server 2003 R2 machine. The application that uses the database needs to have the ODBC drivers installed. Everytime I try to add them, the installer looks like it does something, but when I go to the Data Source option under Administrative Tools, the only driver I see is the SQL Native Client. Any ideas?1) What ODBC driver are you expecting to install?
2) When you mentioned "Data Source", you meant that the drivers did not show up under the "drivers" tab of "ODBC Data Source Administrator", correct?|||

The SQL Native client is the ODBC driver for SQL Server. You just need to add a new DSN to connect to the right server and then use the DSN to connect. If that is not what you intend on doing, please describe exactly what you trying to do.

The following links talks more about it in detail.

http://blogs.msdn.com/sqlnativeclient/archive/2006/09/27/774287.aspx

HTH

Riyaz

Obtaining Snapsot via FTP using SQL Express client

Hi All,

I really need some help here! I have spent the last few days upgrading a clients system to SQL 2005, part of which involved upgrading their sales people's laptops to Sql 2005 Express and setting up Merge Replication. I have configured the Server to use Web Synchronisation, and have tested that the replisapi.dll?diag all works ok and it does.

I am running into problems now with getting the laptops to synchronise. I have set up the Replication task, and am getting an error when I run the Wndows Synchroniser:

====================

The schema script '\\PTC42\ParklandsWebsiteV2\ftp\PTC42_PARKLANDS_PARKLANDS\20060812131209\' could not be propagated to the subscriber.

The process could not connect to FTP site 'mail.parklands.net' using port 21.

A connection with the server could not be established
==============

I have tested independantly connecting to the FTP server using Windows explorer and it works fine using the same username and password. I am at a loss here!!! I am going in circles looking for help too as there doesnt seem to be much info on this in SQL 2005 yet. I have re-read all the books online articles for Replication, Replication in SQL 2005 Express, and also gone back & reset up the Server & the Client several times - with no luck!

The client needs to get these sales guys laptops back ASAP and I am starting to really stress out here!! (can you tell I havent had much sleep in the last few days?) Any help would be so wonderfully apreciated!!!

Thanks so very much,

Catherine

Well I have FINALLY worked it out - and thought I would post my findings to help others that may run into the same problem.

I ran ftp using command prompt and all connected fine so I knew it wasnt the FTP side of things.

I set up the same replication on another machine and received the same error so that meant it was a config probem & not a problem specific to the laptop i was working on.

I ran replmerge.exe via the command prompt and received the same error message - after much testing & trying & playng with settings I realised that the setting I was entering for FTP address werent being used - the setting on the SQL server Publication were being used. It then occurred to me that the Mail.parklands.net address was an external address and perhaps the machine hosting the IIS component of the Web Sync may not be able to map that address. When I tested this on the IIS server I received the same message. I changed this connection path to the internal machine name - and could connect!! i changed this setting in the SQL publication & rebuilt the Snapshot. I then added the PTC42 machine name to my hosts file and tested I could FTP into that locally using the command prompt. When that all worked i tested the replmerge.exe via the ocmmand prompt once again and I am very happy to report that my DB is now synchronising!! :)

So in summary - ensure when you set up your FTP server for the snapshot of a Replicated database that the IIS server that is hosting the Web Synch can access that exact name - keeping in mind internal & external server names.

I am happy to be corrected on this (my explination & terminology may be way off) - but am breathing a sigh of relief as it seems to be working now!

Thanks,

Catherine